IBM Support

IT41112: DATAPOWER FAILS TO PROCESS SQL DATA TYPE VARGRAPHIC INCLUDED IN THE DATABASE CURSOR.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

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