PH42034: UNABLE TO INSERT MORE THAN 8000 BYTES INTO A MICROSOFT SQL SERVER DATABASE TABLE COLUMN DEFINED AS VARBINARY DATATYPE

APAR status

• Closed as program error.

Error description

• Transformation Extender ODBC Database Adapter fails to insert
  more than 8000 bytes into a MicroSoft SQL Server database
  table column defined as a varbinary datatype.
  
  The varbinary column is set to MAX.
  
  The following error is found in the ITX database adapter trace
  file:
  
  <31905-1043865984-Tue Nov  9 11:42:30 2021>: Error in SQLExecute
  
  Message: [Microsoft][ODBC Driver 17 for SQL Server]String data,
  right truncation
  SQL State: 22001
  

Local fix

• ITXCQ - ITX00061086
  PB / PB
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender ODBC driver users who connect to MS
  SQL server and trying to load data of size > 4000 into varbinary
  column.
  
  Problem Description:
  Unable to insert over 8000 bytes into database for varbinary
  column.
  
  Platforms Affected:
  All unix type platforms.
  

Problem conclusion

• Changed this default value for varbinary datatype for UNIX-ODBC
  driver to 8000 to avoid issue with sqlBindParameter() of MS SQL
  server.
  
  Applies to:
  10.0.0.0, 10.0.3.0, 10.1.0.1
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the IBM Transformation Extender Release Notes page:
  https://www.ibm.com/support/docview.wss?uid=swg27008337
  
  If the service pack or product release is available, download it
  from Fix Central:
  http://www.ibm.com/support/fixcentral/
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a case:
  https://www.ibm.com/mysupport/
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

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