Lob is closed. ERRORCODE=-4470, SQLSTATE=null

XQE-GEN-0005 Found an internal error. Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null

Troubleshooting

Problem

After migrating from CQM to DQM connections to DB2 data source Reports that query CLOB data type result in error when run in HTML and user clicks Page Down.

XQE-GEN-0005 Found an internal error: [jcc][10120][11936][4.25.13] Invalid operation: Lob is closed

Cause

Progressive Streaming enabled in DB2 database.

Resolving The Problem

Problems may occur when retrieving LOB or XML data when the data size is larger than 32K after migrating to DB2 servers that support the progressive streaming interface. You may want to disable this feature so that LOB / XML data is processed the way it was before the progressive streaming interface was implemented.

The error can be resolved by adding this parameter "progressiveStreaming=2;" to the JDBC connection string for the DB2 data source defined in IBM Cognos Administration.

 

Related Information

Disabling progressive streaming with CLI/JDBC applications