APAR status
Closed as program error.
Error description
The log shows DataPower has executed the SQL command (stored procedure) successfully, and got some response data. But later got problem when reading the response. From DataPower logs , we see the following : Prepare SQL query: {CALL .... ... ... SQL query execution succeeded Writing results The full results of the SQL select statement have been read Fetching stored procedure output Incomplete markup or missing document element at offset 0 of file:///%sql%
Local fix
n/a
Problem summary
Datapower fails to process the SQL data including SQL data type VARGRAPHIC from SQL server.
Problem conclusion
Fix is available in 2018.4.1.22, 10.0.1.9, 10.5.0.1 For a list of the latest fix packs available, please see: http://www-01.ibm.com/support/docview.wss?uid=swg21237631
Temporary fix
Comments
APAR Information
APAR number
IT41112
Reported component name
DATAPOWER
Reported component ID
DP1234567
Reported release
A0X
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-06-02
Closed date
2022-07-22
Last modified date
2022-09-08
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9H2Y","label":"IBM DataPower Gateways"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A0X","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
08 September 2022