IT48096: POSTGRESQL STORED PROCEDURE EXECUTION RETURNS RESULT SET IN INCORRECT ORDER

APAR status

• Closed as program error.

Error description

• When executing a PostgreSQL stored procedure that returns
  multiple result sets, the ODBC driver occasionally retrieves the
  result sets in the wrong order. This issue tends to occur
  intermittently, especially when handling large result sets, and
  the order may vary between executions
  

Local fix

Problem summary

• ****************************************************************
  
  USERS AFFECTED:
  All users of App Connect Enterprise v13, v12 and IBM Integration
  
  Bus v10.1 who use the DataDirect PostgreSQL ODBC driver and
  return a result set from a database stored procedure.
  
  
  Platforms affected:
  AIX, ZOS, LinuxZ64, LinuxX64, LinuxPPCLE64, WinX64
  
  ****************************************************************
  
  PROBLEM DESCRIPTION:
  When invoking a stored procedure in a PostgreSQL database which
  returns multiple resultsets via an ODBC connection from IBM App
  Connect Enterprise, the ODBC driver intermittently returns the
  resultsets in the wrong order.
  

Problem conclusion

• After updating the ODBC driver, the execution of stored
  procedures in the PostgreSQL database via the ODBC connection
  now returns the result sets in the correct order, resolving the
  previously observed issue.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version   Maintenance Level
  v10.1      10.1.0.6
  v12.0      12.0.12.16
  v13.0      13.0.4.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

  5724J0570

Applicable component levels