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":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLU4JS","label":"IBM Sterling Transformation Extender"},"ARM Category":[{"code":"a8m0z000000blV0AAI","label":"Adapters->ODBC"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. 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
More support for:
IBM Sterling Transformation Extender
Component:
Adapters->ODBC
Software version:
All Versions
Operating system(s):
Linux, Windows
Document number:
6516432
Modified date:
15 May 2022
UID
ibm16516432
Manage My Notification Subscriptions