Troubleshooting
Problem
Unable to insert more than 8000 bytes into an nvarchar datatype (Microsoft SQL Server database) using an ITX 10 map with the ODBC adapter.
Symptom
Unable to insert more than 8000 bytes in nvarchar datatype into SQL Server database that uses ITX 10.
Cause
This has been identified as a product defect under APAR PH27615.
Environment
Using the ITX ODBC adapter to insert data into SQL Server with a column defined as nvarchar(max) and the size of the data is more than 8000 bytes.
Diagnosing The Problem
The following error is contained with the IBM Transformation Extender(ITX) Database trace log.
Buffer not wide enough for data - expanding it Error in SQLExecute Message: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation SQL State: 22001
Resolving The Problem
Obtain patch for APAR PH27615
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"ARM Category":[{"code":"a8m0z000000blV0AAI","label":"Adapters->ODBC"}],"ARM Case Number":"TS003935054","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
09 September 2020
UID
ibm16254321