Exception 50142 (): Read input stream error: ORA-22990: LOB locators cannot span transactions
(Doc ID 1070517.1)
Last updated on MAY 04, 2021
Applies to:
Oracle Reports Developer - Version 10.1.2.2 and laterAdverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.
Symptoms
Running reports request and pushing report outputs to Oracle Portal are not viewable from Oracle Portal.
Having Reports Server trace enabled the following trace information is being recorded.
[2010/2/2 3:10:24:708] Exception 50142 (): Read input stream error: ORA-22990: LOB locators cannot span transactions
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:758)
at oracle.reports.server.WebDBIntegration.uploadForPortal9i(WebDBIntegration.java:1329)
at oracle.reports.server.WebDBIntegration.upload(WebDBIntegration.java:1228)
at oracle.reports.server.WebDBIntegration.putJobContent(WebDBIntegration.java:610)
at oracle.reports.server.DesOraclePortal.send(DesOraclePortal.java:119)
at oracle.reports.server.JobObject.distribute(JobObject.java:1593)
at oracle.reports.server.JobManager.updateJobStatus(JobManager.java:2332)
at oracle.reports.server.EngineCommImpl.updateEngineJobStatus(EngineCommImpl.java:134)
at oracle.reports.server._EngineCommImplBase._invoke(_EngineCommImplBase.java:94)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)
[2010/2/2 3:10:24:708] State 56016 (JobManager:updateJobStatus): Job ### status is: Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
REP-50142: oracleportal : Read input stream error: ORA-22990: LOB locators cannot span transactions
[2010/2/2 3:10:24:708] Debug 50103 (WebDBIntegration:putJobStatus): this is a one time job, and parent job is null.
[2010/2/2 3:10:24:708] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusFolderId: <id_number>
[2010/2/2 3:10:24:708] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusItemId: <id_number>
[2010/2/2 3:10:25:349] Info 50103 (WebDBIntegration:createScheduledJob): new job.m_statusItemId: <id_number>
[2010/2/2 3:10:25:349] Debug 50103 (WebDBIntegration:putJobStatus): this is a one time job, and parent job is null.
[2010/2/2 3:10:25:349] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusFolderId: <id_number>
[2010/2/2 3:10:25:349] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusItemId: <id_number>
[2010/2/2 3:10:25:380] Info 56084 (WebDBIntegration:createScheduledJob): Notify that Oracle Portal folder have been created for job ###
[2010/2/2 3:10:25:396] Info 56013 (ConnectionManager:release): Connection 942 is released
[2010/2/2 3:10:25:458] Debug 50103 (JobManager:notifyWaitingJobs): Primary job ### notify its duplicated jobs.
[2010/2/2 3:10:25:458] Debug 50103 (JobManager:updateJobStatus): Finished updating job: ###
[2010/2/2 3:10:25:458] Debug 50103 (JobManager:removeJob): will remove job ###
[2010/2/2 3:10:25:458] Debug 50103 (RWCache:deleteItem): delete item for job ###
[2010/2/2 3:10:25:458] Debug 50103 (RWCacheItem:clear): job xxx become invalid
[2010/2/2 3:10:25:458] Debug 50103 (RWCache:updateCurrentCapacity): Current cache capacity is 39630893
[2010/2/2 3:10:25:458] Debug 50103 (EngineManager:updateEngineState): Engine rwEng-1 status is 1
[2010/2/2 3:10:25:458] State 56004 (EngineInfo:setState): Engine rwEng-1 state is: Ready
[2010/2/2 3:10:25:474] Debug 50103 (JobManager:removeJob): removed job ###
[2010/2/2 3:10:25:474] Exception 50159 (): Executed successfully but there were some errors when distribute the output
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1110)
at oracle.reports.server.ExecAsynchJobThread.run(ExecAsynchJobThread.java:54)
[2010/2/2 3:10:25:474] Debug 50103 (JobManager:runJobInEngine): Encounted exception in job ###
[2010/2/2 3:10:25:474] Exception 50159 (): Executed successfully but there were some errors when distribute the output
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1110)
at oracle.reports.server.ExecAsynchJobThread.run(ExecAsynchJobThread.java:54)
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:758)
at oracle.reports.server.WebDBIntegration.uploadForPortal9i(WebDBIntegration.java:1329)
at oracle.reports.server.WebDBIntegration.upload(WebDBIntegration.java:1228)
at oracle.reports.server.WebDBIntegration.putJobContent(WebDBIntegration.java:610)
at oracle.reports.server.DesOraclePortal.send(DesOraclePortal.java:119)
at oracle.reports.server.JobObject.distribute(JobObject.java:1593)
at oracle.reports.server.JobManager.updateJobStatus(JobManager.java:2332)
at oracle.reports.server.EngineCommImpl.updateEngineJobStatus(EngineCommImpl.java:134)
at oracle.reports.server._EngineCommImplBase._invoke(_EngineCommImplBase.java:94)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)
[2010/2/2 3:10:24:708] State 56016 (JobManager:updateJobStatus): Job ### status is: Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
REP-50142: oracleportal : Read input stream error: ORA-22990: LOB locators cannot span transactions
[2010/2/2 3:10:24:708] Debug 50103 (WebDBIntegration:putJobStatus): this is a one time job, and parent job is null.
[2010/2/2 3:10:24:708] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusFolderId: <id_number>
[2010/2/2 3:10:24:708] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusItemId: <id_number>
[2010/2/2 3:10:25:349] Info 50103 (WebDBIntegration:createScheduledJob): new job.m_statusItemId: <id_number>
[2010/2/2 3:10:25:349] Debug 50103 (WebDBIntegration:putJobStatus): this is a one time job, and parent job is null.
[2010/2/2 3:10:25:349] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusFolderId: <id_number>
[2010/2/2 3:10:25:349] Info 50103 (WebDBIntegration:putJobStatus): job.m_statusItemId: <id_number>
[2010/2/2 3:10:25:380] Info 56084 (WebDBIntegration:createScheduledJob): Notify that Oracle Portal folder have been created for job ###
[2010/2/2 3:10:25:396] Info 56013 (ConnectionManager:release): Connection 942 is released
[2010/2/2 3:10:25:458] Debug 50103 (JobManager:notifyWaitingJobs): Primary job ### notify its duplicated jobs.
[2010/2/2 3:10:25:458] Debug 50103 (JobManager:updateJobStatus): Finished updating job: ###
[2010/2/2 3:10:25:458] Debug 50103 (JobManager:removeJob): will remove job ###
[2010/2/2 3:10:25:458] Debug 50103 (RWCache:deleteItem): delete item for job ###
[2010/2/2 3:10:25:458] Debug 50103 (RWCacheItem:clear): job xxx become invalid
[2010/2/2 3:10:25:458] Debug 50103 (RWCache:updateCurrentCapacity): Current cache capacity is 39630893
[2010/2/2 3:10:25:458] Debug 50103 (EngineManager:updateEngineState): Engine rwEng-1 status is 1
[2010/2/2 3:10:25:458] State 56004 (EngineInfo:setState): Engine rwEng-1 state is: Ready
[2010/2/2 3:10:25:474] Debug 50103 (JobManager:removeJob): removed job ###
[2010/2/2 3:10:25:474] Exception 50159 (): Executed successfully but there were some errors when distribute the output
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1110)
at oracle.reports.server.ExecAsynchJobThread.run(ExecAsynchJobThread.java:54)
[2010/2/2 3:10:25:474] Debug 50103 (JobManager:runJobInEngine): Encounted exception in job ###
[2010/2/2 3:10:25:474] Exception 50159 (): Executed successfully but there were some errors when distribute the output
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1110)
at oracle.reports.server.ExecAsynchJobThread.run(ExecAsynchJobThread.java:54)
Checking Reports Server cache directory, the report output is being created fine there. The process to push the report output to Oracle Portal is the one that is failing.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |