String or binary data would be truncated

Scenario: Triggered when trying to insert or update a value that exceeds the maximum allowed size for a column.

Error Message: String or binary data would be truncated in table 'Customers', column 'Name'.

Cause: Data from the source system has fields longer than defined in the NAV database schema.

Resolution:

  1. Use INFORMATION_SCHEMA.COLUMNS to check column sizes.
  2. Truncate or clean the source data to fit the column limits either directly into your system or by using our formulas such as ##COPY.