OSB Performances Degradation
(Doc ID 2589973.1)
Last updated on DECEMBER 15, 2023
Applies to:
Oracle Service Bus - Version 12.1.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
Seeing below error
{})],CoordinatorURL=SOSBPRD1_MS1+sosbprdappsvr01:8101+SOSBPRD1+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=com.bea.wli.reporting.jmsprovider.runtime.MDBMessageReporting@da06427
[OSB-473522]An error occurred while inserting data into the Reporting Table with Batch Update {0}
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:2003)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:370)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:261)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:480)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:376)
at weblogic.ejb.container.internal.TokenBasedJMSMessagePoller.processOneMessage(TokenBasedJMSMessagePoller.java:338)
at weblogic.ejb.container.internal.TokenBasedJMSMessagePoller.run(TokenBasedJMSMessagePoller.java:137)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.__AW_run(SelfTuningWorkManagerImpl.java:553)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.__AW_run(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java)
Caused by: java.lang.RuntimeException: [OSB-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:149)
at weblogic.transaction.internal.ServerSCInfo$CallBeforeCompletionsAction.run(ServerSCInfo.java:1813)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:365)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1386)
at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1363)
at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:127)
at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1410)
at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2245)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:294)
... 10 more
Caused by: java.sql.BatchUpdateException: ORA-02049: timeout: distributed transaction waiting for lock
at oracle.jdbc.driver.OraclePreparedStatement.__AW_executeBatch(OraclePreparedStatement.java:15709)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java)
at oracle.jdbc.driver.OracleStatementWrapper.__AW_executeBatch(OracleStatementWrapper.java:264)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216)
at com.bea.wli.reporting.jmsprovider.runtime.MDBBatch.beforeCompletion(MDBBatch.java:124)
... 19 more
Changes
N/A
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 |
Changes |
Cause |
Solution |
References |