SAP Issue - String or binary data would be truncated. The statement has been terminated.

  • Updated

In some cases, there is an SAP bug when you try to select multiple users in the B1 Dashboard "Select Users" form. The error is seen in the screenshot below:

mceclip0.png

System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.

You can fix this error by deleting the UDF in the "User-Defined Fields - Management" -screen. Please note that other users should be disconnected from the database.

mceclip1.png

After you've removed the field, restart the add-on and the field will be created properly and the error will not show up anymore.

 

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.