PH43824: ODBC ADAPTER INSERTS GARBLED CHARACTERS INTO COLUMN WHEN LARGER DATA IS BEING INSERTED AND BUFFER IS EXPANDED

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 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