APAR status
Closed as program error.
Error description
The IBM Transformation Extender (ITX) 10.0 and 10.1 Database adapter (ODBC) fails to call a MicroSoft SQL Server Stored Procedure when one of the datatypes is VARBINARY and the data passed to this exceeds 8000 bytes. 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 - ITX00061123 PB / PB Circumvention: None
Problem summary
Users Affected: IBM Transformation Extender users inserting data of size >8000 into varbinary datatype of MS sql server table Problem Description: String truncation error was observed for VARBINARY data type when used with a stored procedure. Platforms Affected: Windows, All Unix
Problem conclusion
Set the datatype to LONG_VARBINARY if size of string more. Applies to: 10.0.0.0, 10.1.0.1, 10.1.1.0 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
PH42358
Reported component name
ITX
Reported component ID
5724Q2300
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-11-25
Closed date
2022-05-26
Last modified date
2022-10-05
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
[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSVSD8","label":"Transformation Extender"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10"}]
Document Information
Modified date:
05 October 2022