Search Descriptions All MSx ML8 Version

This article applies to: ML v7, ML8, MultiStore

String or binary data would be truncated

Symptoms
The error below occurs when importing data from xml/excel format

<Error Message="Exception, Message=String or binary data would be truncated.&#xD: The statement has been terminated." /></ AspDotNetStorefrontImportResult>

Cause
One of the values in the column specified in the import file had exceeded the length allocated for that field (i.e. SEName, Name nvarchar (400))

Solution
Make sure that the values in the column does not exceed the field length allocated in the table.