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

Fix packs for DataPower Gateway version 7.1
Fix packs for DataPower Gateway version 7.2
Fix packs for DataPower Gateway version 7.5
Fix packs for DataPower Gateway version 7.5.1
Fix packs for DataPower Gateway version 7.5.2

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

• Fix is available in 7.1.0.17, 7.2.0.14, 7.5.0.8, 7.5.1.7,
  7.5.2.7 and 7.6.0.0
  
  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 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