My Oracle Support Banner

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 later
Information 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


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