Fixes are available
APAR status
Closed as program error.
Error description
The user observed MS SQL Stored Procedures failing on upgrade from DataPower 7.5.2.1 (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.
Local fix
Problem summary
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".
Problem conclusion
Fix is available in 7.6.0.15 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
Temporary fix
N/A
Comments
APAR Information
APAR number
IT28798
Reported component name
DATAPOWER
Reported component ID
DP1234567
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-04-15
Closed date
2019-05-23
Last modified date
2019-05-29
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
DATAPOWER
Fixed component ID
DP1234567
Applicable component levels
R18X PSY
UP
R760 PSY
UP
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS9H2Y","label":"IBM DataPower Gateways"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760"}]
Document Information
Modified date:
27 September 2021