OSB Performances Degradation (Doc ID 2589973.1)

Last updated on DECEMBER 15, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.