ORA-22920: row containing the LOB value is not locked if Clicking on Detail in a Report (Doc ID 887269.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Service Bus - Version 2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 12-May-2014***

Symptoms

In OSB or ALSB, when viewing Report Details:
(From OSB console --> Operation --> Reporting --> Message Reports --> Report Detail),
the following error occurs:

####<Jul 23, 2009 2:55:10 PM CDT> <Error> <EJB> <tghai-us> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <alsb-system-user> <> <> <1248378910093> <BEA-010026> <Exception occurred during commit of transaction Name=NewJMSMessagePoller.ReportingMDB,Xid=BEA1-001B1BD5CECFAD42ACE7(21259653),Status=Rolled back. [Reason=java.lang.RuntimeException: [OSB-Reporting:473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=60,XAServerResourceInfo[weblogic.deployment.jms.WrappedXAResource_weblogic_transaction_internal_TransactionManagerImpl$TMXAResource]=(ServerResourceInfo[weblogic.deployment.jms.WrappedXAResource_weblogic_transaction_internal_TransactionManagerImpl$TMXAResource]=(state=rolledback,assigned=AdminServer),xar=weblogic.deployment.jms.WrappedXAResource_weblogic_transaction_internal_TransactionManagerImpl$TMXAResource@bdf1e2,re-Registered = false),XAServerResourceInfo[WLStore_ReportingDomain_FileStore]=(ServerResourceInfo[WLStore_ReportingDomain_FileStore]=(state=rolledback,assigned=AdminServer),xar=WLStore_ReportingDomain_FileStore5465140,re-Registered = false),SCInfo[ReportingDomain+AdminServer]=(state=rolledback),properties=({weblogic.transaction.name=NewJMSMessagePoller.ReportingMDB}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=AdminServer+10.139.95.140:7001+ReportingDomain+t3+, XAResources={WLStore_ReportingDomain_FileStore, weblogic.deployment.jms.WrappedXAResource_weblogic_transaction_internal_TransactionManagerImpl$TMXAResource, WLStore_ReportingDomain_WseeFileStore, WLStore_ReportingDomain__WLS_AdminServer},NonXAResources={})],CoordinatorURL=AdminServer+10.139.95.140:7001+ReportingDomain+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting@18b0d53
[OSB-Reporting:473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1818)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:336)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:230)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:500)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
at weblogic.ejb.container.internal.NewJMSMessagePoller.processOneMessage(NewJMSMessagePoller.java:257)
at weblogic.ejb.container.internal.NewJMSMessagePoller.run(NewJMSMessagePoller.java:121)
at weblogic.ejb.container.internal.NewJMSMessagePoller.timerExpired(NewJMSMessagePoller.java:204)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:273)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: java.lang.RuntimeException: [OSB-Reporting:473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}
at com.bea.wli.reporting.jmsprovider.runtime.MDBBatch.beforeCompletion(MDBBatch.java:146)
at weblogic.transaction.internal.ServerSCInfo$CallBeforeCompletionsAction.run(ServerSCInfo.java:1581)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1213)
at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1195)
at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:118)
at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1302)
at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2114)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:263)
... 10 more
Caused by: java.io.IOException: ORA-22920: row containing the LOB value is not locked
at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:1163)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:313)
at oracle.jdbc.driver.OracleBlobOutputStream.flush(OracleBlobOutputStream.java:241)
at com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting.insertMsgContentForOracle(MDBMessageReporting.java:475)
at com.bea.wli.reporting.jmsprovider.runtime.MDBBatch.beforeCompletion(MDBBatch.java:133)
... 19 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms