Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

Executing the sales Sales order archiving function errors with this message.  can sometime give thefollowing errors. Can apply to 7.00.175 and 7.01.00 databases.

Image Removed

Solution

Warning
titleSQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

  • String or binary data would be truncated.  

Image Added

The error is caused when there are sales orders with Email logs which have message bodies greater than 255 characters in length.

...

 Another cause of the error is when the PrintlogID is greater than 20 characters in length.


  • Archiving sales orders that included lines for service manager jobs errored as follows:

Image Added

The problem was caused by service manager jobs linking part lines to sales order lines.  Download and apply the attached stored procedure to the relevant database.

Solution

Warning
titleSQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

Download and apply the attached modified stored procedure to correct the issue.  The issue has been correct in 7.01.01 under DEV-5934.

View file
nameusp_Jiwa_Archiving_SalesOrders_Provider.sql
height250

Filter by label (Content by label)
showLabelsfalse
max5
spacesJ7UG
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("sales_orders","archiving","binary","sales","archive","string") and type = "page" and space = "J7UG"
labelssales_orders sales archive archiving string binary

...