IT22729: ABEND CALLING STORED PROC WITH LARGE CHAR DATA IN RESULT SET

APAR status

• Closed as program error.

Error description

• The following abend stack is observed when calling a stored
  procedure which returns a large character data column in a
  dynamic result set:
  
  #0   0x7f5800a41d09 in ?? from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #1   0x7f58007f8949 in ImbAbend::dumpCurrentStacksToFile(void
  const*, int) from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #2   0x7f58007f9f66 in ImbAbend::dumpToFile(char*, char const*,
  int, char const*, ImbAbend::Insert const&, ImbAbend::Insert
  const&, ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&, void const*)
  from /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #3   0x7f58007fbad6 in ImbAbend::logSystemErrorInternal(char
  const*, int, char const*, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, void const*, bool) from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #4   0x7f58007fce90
  inImbAbend::logSystemErrorAndTerminateProcessInternal(char
  const*, int, char const*, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, void const*, bool)
  from/u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #5   0x7f58007fd1f8 in ImbAbend::newHandler() from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #6   0x7f58009ee082 in imbRealloc(void*, unsigned long) from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #7   0x7f57ffec9871 in ImbOdbcDynamicResultSet::getValue(int)
  from /u/applic/iib/iib-10.0.0.7/server/lib/libMessageServices.so
  
  The issue is caused by the underlying driver being unable to
  determine the size of the data being transferred. This issue
  has been observed on SQL Server version 10.50.6220 using the
  DataDirect drivers shipped with IIB version 10.0.0.7 but it may
  affect other SQL Server versions or IIB fixpack versions.
  
  
  Additional Symptom(s) Search Keyword(s):SQL Stored Procedure
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus version 10 using ODBC
  connectivity.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  The following abend stack is observed when calling a stored
  procedure which returns a large character data column in a
  dynamic result set:
  
  #0   0x7f5800a41d09 in ?? from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #1   0x7f58007f8949 in ImbAbend::dumpCurrentStacksToFile(void
  const*, int) from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #2   0x7f58007f9f66 in ImbAbend::dumpToFile(char*, char const*,
  int, char const*, ImbAbend::Insert const&, ImbAbend::Insert
  const&, ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&, void const*)
  from /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #3   0x7f58007fbad6 in ImbAbend::logSystemErrorInternal(char
  const*, int, char const*, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, void const*, bool) from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #4   0x7f58007fce90
  inImbAbend::logSystemErrorAndTerminateProcessInternal(char
  const*, int, char const*, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, ImbAbend::Insert const&,
  ImbAbend::Insert const&, void const*, bool)
  from/u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #5   0x7f58007fd1f8 in ImbAbend::newHandler() from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #6   0x7f58009ee082 in imbRealloc(void*, unsigned long) from
  /u/applic/iib/iib-10.0.0.7/server/lib/libCommonServices.so
  #7   0x7f57ffec9871 in ImbOdbcDynamicResultSet::getValue(int)
  from /u/applic/iib/iib-10.0.0.7/server/lib/libMessageServices.so
  
  The issue is caused by the underlying driver being unable to
  determine the size of the data being transferred resulting in
  either allocation of a very large buffer or an attempt to
  allocate a negatively sized buffer due to overflowing the size
  of the data type used to hold the buffer size. This issue  has
  been observed on SQL Server version 10.50.6220 using the
  DataDirect drivers shipped with IBM Integration Bus version
  10.0.0.7, but it may affect other SQL Server versions or IBM
  Integration Bus fixpack versions.
  

Problem conclusion

• IBM Integration Bus has been modified such that if it has
  detected that it is being asked to grow the data buffer by more
  than 10Mb it will instead increase the buffer size by either the
  value of MQSI_LOB_BUFFER_INCREMENT_SIZE, if it is set, or 1Mb by
  default.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.12
  
  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

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels