"[Microsoft OLE DB Provider for SQL Server] [SQL Code=8152 SQL State=22001] String or binary data would be truncated." appearing in the logs. Does not seem to be causing any problems in Service Desk

Document ID : KB000024630
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

[Microsoft OLE DB Provider for SQL Server] [SQL Code=3621 SQL State=01000] The statement has been terminated. [Microsoft OLE DB Provider for SQL Server] [SQL Code=8152 SQL State=22001] String or binary data would be truncated. This appears in the stdlog.

Solution

This occurs when ServiceDesk tries to enter a UUID over 20 characters in length into the anima table.

  1. Change your ddict.sch file to reflect the following:
  2. TABLE Animator MEDIUM READ_ONLY { id INTEGER KEY UNIQUE NOT_NULL ; a_name STRING 30 S_KEY ; t_persid STRING 60 S_KEY ;
  3. Change your t_persid in your anima table to reflect the 60 character length.  You can right click on the anima table within SQL Server Enterprise manager, select design table and change the length of the columns.  Please consult with your DBA for other database types.

This is no longer an issue in ServiceDesk r12 where UUID character length has been expanded to 60 characters.