APAR status
Closed as program error.
Error description
The ODBC Adapter inserts garbled characters into (Oracle or PostgreSQL) table column (defined as text or longvarchar datatype) when larger data is being inserted for a row after another row of smaller data is inserted. The database adapter trace indicates the buffer is expanded "Buffer not wide enough for data - expanding it". The garbled characters that are inserted vary each time the problem occurs. When the problem occurs, all the rows following the larger data row, including rows with smaller data, are also inserted with the same garbled characters as the larger data row. The problem does not occur if the row with the larger data is the first row being inserted.
Local fix
ITXCQ - ITX00061184 GM / GM Circumvention: None
Problem summary
Users Affected: IBM Transformation Extender users using the ODBC adapter to insert large data in varchar column postgresql table. Problem Description: ODBC Adapter inserts garbled characters into PostgreSQL table column defined as text datatype when larger data is being inserted and buffer is expanded. Platforms Affected: All
Problem conclusion
Made code changes to avoid buffer corruption. Applies to: 10.0.0.0, 10.0.3.0 10.1.0.1, 10.1.1.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
PH43824
Reported component name
ITX
Reported component ID
5724Q2300
Reported release
A00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-02-02
Closed date
2022-05-26
Last modified date
2022-06-17
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:
18 June 2022