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 number
PH42034
Reported component name
ITX
Reported component ID
5724Q2300
Reported release
A00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-11-11
Closed date
2021-11-16
Last modified date
2021-11-18
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
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"Transformation Extender"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A00"}]
Document Information
Modified date:
19 November 2021