Skip to main content

Error: String or Binary data would be truncated. Unable to insert into table SL_ADDRESSES

When trying to synchronise a Customer Record with Dimensions we are receiving the following error: "String or Binary data would be truncated. Unable to insert into table SL_ADDRESSES"

J
Written by Jes Foxall-Beckley
Updated over a week ago

This issue is caused by a Customer Address having a line with too many characters.
​
The error message that appears is being relayed from Dimensions and is warning the user that the address line is to long and the record can not be created.
​
Please check the Addresses for the Customer Account and amend/reduce characters on any lines where possible.

Did this answer your question?