IT28798: MS SQL STORED PROCEDURES FAIL POST UPGRADE
Closed as program error.
The user observed MS SQL Stored Procedures failing on upgrade from DataPower 126.96.36.199 (ODBC library 7.15) to 7.6.0.x (ODBC library 7.16). These showed up on DataPower side as "Query timed out" errors and as "Could not find prepared statement" on MS SQL side.
When DataPower calls specific SQL stored procedure in remote MS SQL server, DP hangs for minutes to execute the command, and finally fails with the error message "Query timed out".
Fix is available in 188.8.131.52 and 2018.4.1.6 For a list of the latest fix packs available, please see: http://www-01.ibm.com/support/docview.wss?uid=swg21237631
Reported component name
Reported component ID
NoSpecatt / Xsystem
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID