IT47742: UNABLE TO EXECUTE A POSTGRESQL STORED PROCEDURE THAT HAS MORE THAN 32 PARAMETERS

APAR status

• Closed as program error.

Error description

• BIP2921E: The procedure 'my_33_parameter_procedure' with '33'
  parameters could not be matched with a corresponding Database
  stored procedure.
  

Local fix

Problem summary

• ****************************************************************
  
  USERS AFFECTED:
  All Users of App Connect Enterprise who use ODBC to execute
  stored procedures in a PostgreSQL database
  
  
  Platforms affected:
  AIX, LinuxX64, WinX64
  
  ****************************************************************
  
  PROBLEM DESCRIPTION:
  When attempting to call a database stored procedure in
  PostgreSQL, via ODBC, that has more than 32 parameters it is
  reported that the stored procedure could not be found.
  

Problem conclusion

• A new ODBC driver for PostgreSQL has been included in App
  Connect Enterprise that can successfully call stored procedures
  that have more that 32 parameters.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version   Maintenance Level
  v12.0      12.0.12.13
  v13.0      13.0.3.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