https://github.com/famousdraw

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.
 

posted on   红色MINI  阅读(202)  评论(0)  编辑  收藏  举报

相关博文：
· Disabling progressive streaming with CLI/JDBC applications
· IT15527: IN SPECIFIC TIMING CONDITIONS WITH MULTIPLE DB2READLOG API CALLERS(CDC, ETC), "NO ROOM FOR RETRIEVED LOG" occurs in db2diag.log
· Clob转String报错SQLRecoverableException: 关闭的连接
· 一则> ORA-00932: inconsistent datatypes: expected - got CLOB 错误处理的方法
· db2 一些工作中碰到的问题1 ERRORCODE=-4499, SQLSTATE=08001
阅读排行：
· 被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单，K8s 太复杂？w7panel 让容器管理更轻松！

导航

< 2025年3月 >
日 一 二 三 四 五 六
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

统计

点击右上角即可分享
微信分享提示