C1-TXNCU Buffer Deadlock
(Doc ID 2402780.1)
Last updated on MAY 11, 2023
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 2.5.0.3.0 and laterInformation in this document applies to any platform.
Symptoms
On : ORMB 2.5.0.3.0 version, BT - Batch
C1-TXNCU Buffer Deadlock
ERROR
-----------------------
00:27:49,250 [RPAG1EPWorker:0] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-00060: deadlock detected while waiting for resource
00:27:49,263 [RPAG1EPWorker:0] ERROR (com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionCleanUpBatch) HibernateException in executeWorkUnit :
org.hibernate.exception.LockAcquisitionException: ORA-00060: deadlock detected while waiting for resource
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:144)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.__AW_convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy6.__AW_executeBatch(Unknown Source)
at com.sun.proxy.$Proxy6.executeBatch(Unknown Source)
at com.splwg.ccb.domain.util.LoggablePreparedStatement.__AW_executeBatch(LoggablePreparedStatement.java:231)
at com.splwg.ccb.domain.util.LoggablePreparedStatement.executeBatch(LoggablePreparedStatement.java)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionCleanUpBatch$Worker.__AW_updateDisAggBchgStatus(TransactionCleanUpBatch.java:3438)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionCleanUpBatch$Worker.updateDisAggBchgStatus(TransactionCleanUpBatch.java)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionCleanUpBatch$Worker.processDisAggregatedBillableCharges(TransactionCleanUpBatch.java:3388)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionCleanUpBatch$Worker.__AW_executeWorkUnit(TransactionCleanUpBatch.java:1885)
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.TransactionCleanUpBatch$Worker.executeWorkUnit(TransactionCleanUpBatch.java)
at com.splwg.base.api.batch.AbstractThreadWorker.executeWorkUnitDetailedResult(AbstractThreadWorker.java:195)
at com.splwg.base.api.batch.ThreadWorkUnitExecutable.executeAndAccumulateStats(ThreadWorkUnitExecutable.java:103)
at com.splwg.base.api.batch.ThreadWorkUnitExecutable.__AW_execute(ThreadWorkUnitExecutable.java:74)
at com.splwg.base.api.batch.ThreadWorkUnitExecutable.execute(ThreadWorkUnitExecutable.java)
at com.splwg.base.api.batch.AbstractCommitStrategy.__AW_executeWorkUntilCommitOrEnd(AbstractCommitStrategy.java:135)
at com.splwg.base.api.batch.AbstractCommitStrategy.executeWorkUntilCommitOrEnd(AbstractCommitStrategy.java)
at com.splwg.base.api.batch.AbstractCommitStrategy.__AW_concreteExecuteWork(AbstractCommitStrategy.java:74)
at com.splwg.base.api.batch.AbstractCommitStrategy.concreteExecuteWork(AbstractCommitStrategy.java)
at com.splwg.base.api.batch.CommitEveryUnitStrategy.concreteExecuteWork(CommitEveryUnitStrategy.java:36)
at com.splwg.base.api.batch.AbstractExecutionStrategy.__AW_executeWork(AbstractExecutionStrategy.java:243)
at com.splwg.base.api.batch.AbstractExecutionStrategy.executeWork(AbstractExecutionStrategy.java)
at com.splwg.base.support.batch.JavaBatchWork.executeThreadWork(JavaBatchWork.java:109)
at com.splwg.base.support.batch.JavaBatchWork.access$300(JavaBatchWork.java:29)
at com.splwg.base.support.batch.JavaBatchWork$DoExecuteWorkInSession.doBatchWorkInSession(JavaBatchWork.java:92)
at com.splwg.base.support.batch.BatchWorkInSessionExecutable.__AW_run(BatchWorkInSessionExecutable.java:62)
at com.splwg.base.support.batch.BatchWorkInSessionExecutable.run(BatchWorkInSessionExecutable.java)
at com.splwg.base.support.batch.JavaBatchWork.doExecuteWork(JavaBatchWork.java:51)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run C1-TXNCU.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This is impacting the Production Parallel processing,
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 |