Troubleshooting
Problem
Users may notice that the following error message is displayed in the database adapter trace when attempting to insert more than 8000 characters in columns of type either NVARCHAR(max) or VARBINARY(max) using IBM Transformation Extender 10.0 or 10.1.
Message: [Microsoft][ODBC Driver 17 for SQL Server]String data,
right truncation
right truncation
The data is not inserted, and the map fails, if it has been designed to do so.
Symptom
The database transaction fails, and if a database trace is enabled, it will contain an error message such as:
Message: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLU4JS","label":"IBM Sterling Transformation Extender"},"ARM Category":[{"code":"a8m0z000000blV0AAI","label":"Adapters-\u003EODBC"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
15 May 2022
UID
ibm16516432