IT44368: UNABLE TO RETRIEVE LOB DATA FROM A POSTGRESQL DATABASE

APAR status

• Closed as program error.

Error description

• When attempting to retrieve data from a LOB column in a
  PostgreSQL database this error is reported.
  BIP2322E DatabaseException ImbOdbcStatement::checkRcInner 'Child
  SQL exception' ['01004', -2, 'Fetched item was truncated.']
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All Users of IBM Integration Bus V10.1, App Connect Enterprise
  V11 or App Connect Enterprise V12 who attempt to retrieve LOB
  data from a PostgreSQL database.
  
  
  Platforms affected:
  AIX, Linux on x86-64 platform, Linux on zSeries platform, Linux
  on Power platform, Windows on x86-64 platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When a PostgreSQL database is unable to provide the size of the
  data to be returned for a LOB column App Connect Enterprise does
  not allocate a large enough buffer to store the retrieved data.
  This leads to an SQL exception ['01004', -2, 'Fetched item was
  truncated.']  to warn that the data has been truncated.
  

Problem conclusion

• IBM App Connect Enterprise now detects when a PostgreSQL
  database indicates that it does not know the size of the data
  being returned. For this scenario ACE now allocates a
  sufficiently sized buffer to hold the data preventing any
  truncation when the data is retrieved.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.1      10.1.0.2
  v11.0      11.0.0.23
  v12.0      12.0.10.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  APP CONNECT ENT

• Fixed component ID

  5724J0560

Applicable component levels