MSSQL Sorting or binary data would be truncated

From support-works
Jump to navigation Jump to search

Status: Published
Version: 1.0
Authors: HTL QA
Applies to: any Supportworks ESP Version

Error on extended table when logging an Incident or Service Request. The call still gets logged but the call details form has some fields missing information.

Open the log and check the Insert statement that is failing. It will have:

[Microsoft][ODBC SQL Server Driver][SQL Server] String or binary data would be truncated.

It means there is a field in the extended table that you are attempting to populate that is not large enough for the amount of data you are sending to it. For example, table extoc_cfh has varchar 12 but you are trying to enter 'reset your password' into that field which is 19 characters long.