IBM Support

IT19809: DATAPOWER UNABLE TO SUBMIT SQL QUERIES WITH PAYLOADS GREATER THAN 4MB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The following errors will be logged in the DataPower logs.
    However no entries should be logged in the DataBase logs.  The
    reason is the query is never making it off device.
    
    "sql-source (<Domain_name>): Database reported query error:
    Error (616) on input or output to a file. Error in parameter #."
    616 isn't a sqlserver error and there is no error on sqlserver.
    
    or
    
    "sql-source (<Domain_name>): Database reported query error:
    Insufficient disk space. Error in parameter #."
    

Local fix

Problem summary

  • When executing SQL command in the Stylesheet to write data to
    remote Microsoft SQL server, if a single field has large data
    greater than around 4MB, then the writing action might fail.
    

Problem conclusion

Temporary fix

  • N/A
    

Comments

APAR Information

  • APAR number

    IT19809

  • Reported component name

    DATAPOWER

  • Reported component ID

    DP1234567

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-23

  • Closed date

    2017-05-24

  • Last modified date

    2017-06-14

  • 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

  • R710 PSY

       UP

  • R720 PSY

       UP

  • R750 PSY

       UP

  • R751 PSY

       UP

  • R752 PSY

       UP



Document information

More support for: IBM DataPower Gateways
General

Software version: 750

Reference #: IT19809

Modified date: 14 June 2017