PH68803: ERROR 'STRING DATA, RIGHT TRUNCATION' WHEN INSERTING DATA INTO MS SQL SERVER TABLE COLUMN NVARCHAR(MAX) USING ITX ODBC ADAPTER

APAR status

• Closed as program error.

Error description

• When using IBM Sterling Transformation Extender (ITX) ODBC
  adapter to insert data into a Microsoft SQL
  Server table column defined as NVARCHAR(MAX), the 'STRING DATA,
  RIGHT TRUNCATION' error occurs.
  

Local fix

• ITXCQ - ITX00063295
  CN / CN
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users who who are inserting large
  amounts of data into NVARCHAR(MAX) columns.
  
  Problem Description:
  When inserting large amounts of data into NVARCHAR(MAX) columns,
  
  
  the ODBC adapter encounters a failure that indicates data
  truncation.
  
  Platforms Affected:
  Windows
  

Problem conclusion

• The ODBC adapter streams the data to the Microsoft SQL Server
  database whenever inserting data into NVARCHAR(MAX) columns.
  
  Applies to:
  11.0.1.1, 11.0.2.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next fix pack or product release is available,
  check the IBM Transformation Extender product Release Notes
  page:
  https://www.ibm.com/support/pages/node/318755
  
  If a fix pack release is available, download it from Fix
  Central:
  http://www.ibm.com/support/fixcentral/
  
  If a new product release is available, download it from
  PassportAdvantage:
  https://www.ibm.com/software/passportadvantage/pao_customer.html
  
  
  If the fix pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  
  Interim Fix (LAIF) by opening a support Case:
  https://www.ibm.com/mysupport
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels