I have a custom field on Shipments Screen telling me the status of the order in a different system, the code is given below:
declaring UsrRWSStatusthe shipments screen for a visual representation
Now I have a service which will update its status to Pick Created , with the following request:
POSTMAN PUT request
But I get this error in response,
"String or binary data would be truncated in table 'AcumaticaDB.dbo.SOShipment', column 'UsrRWSStatus'. Truncated value: 'P'.\r\nThe statement has been terminated.",
this as the exception message,
I am confused here, am I sending the request correctly, or do I have to change something else in my customization of the DAC?
If any more context is required please let me know.
Cheers,
Jdeol
Best answer by Vignesh Ponnusamy
@jdeol, Considering the below error stack, looks like the field length is smaller than in the database.
"String or binary data would be truncated in table 'AcumaticaDB.dbo.SOShipment', column 'UsrRWSStatus'. Truncated value: 'P'.\r\nThe statement has been terminated.",
Did you check if the field length in database is rightly? Are you able to save/update the field value from the UI?
@jdeol, Considering the below error stack, looks like the field length is smaller than in the database.
"String or binary data would be truncated in table 'AcumaticaDB.dbo.SOShipment', column 'UsrRWSStatus'. Truncated value: 'P'.\r\nThe statement has been terminated.",
Did you check if the field length in database is rightly? Are you able to save/update the field value from the UI?
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.