CCB 2.4 - Thread Aborts With Maximum Number Of Replays (1) Have Been Exceeded At Time Of Commit (Doc ID 2164804.1)

Last updated on DECEMBER 01, 2023

Applies to:

Symptoms

In instances with long running cm jobs, only a hand full of threads may complete and the rest will fail.  The job may run for 5-8 hours before it times out with the following seen in the logs:

15:39:14,069 [DEFAULTWorker:1] INFO (com.splwg.shared.environ.ApplicationProperties) Milliseconds to suspend thread before attempting to replay database transaction is not specified via property ouaf.batch.worker.errorRecovery.transactionReplayDelayMs, defaulting to 100
I also saw the following just before this error:
15:39:13,898 [DEFAULTWorker:1] WARN (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) SQL Error: 22922, SQLState: 99999
15:39:13,898 [DEFAULTWorker:1] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-22922: nonexistent LOB value

15:39:13,979 [DEFAULTWorker:1] ERROR (com.splwg.base.support.context.FrameworkSession) Failed to flush session
org.hibernate.exception.GenericJDBCException: ORA-22922: nonexistent LOB value

Caused by: java.sql.SQLException: ORA-22922: nonexistent LOB value

15:39:14,044 [DEFAULTWorker:1] ERROR (com.splwg.base.api.service.ServiceExecutionPolicy) Encountered exception, session marked for rollback
15:39:14,047 [DEFAULTWorker:1] ERROR (com.splwg.base.support.scripting.actions.Action) Failed invoking step : invokeBO $syncRequestBo using "syncRequestBo" for update;
15:39:14,048 [DEFAULTWorker:1] ERROR (com.splwg.base.support.scripting.actions.Action) Failed invoking step : 40: edit data
.......
15:39:14,049 [DEFAULTWorker:1] ERROR (com.splwg.base.support.schema.rules.BusinessObjectStateTransitioner) BO C1-MDM2SPSyncRequest SyncRequest_Id(16088948850332) had status transition error transitioning from BusinessObjectStatusCode='PENDING' to BusinessObjectStatusCode='DETSYNCNEED'
com.splwg.shared.common.LoggedException:
The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.scripting.actions.EditData.privateInvoke(EditData.java:22): Failed invoking step : 40: edit data
com.splwg.base.support.scripting.actions.AbstractInvoke.privateInvoke(AbstractInvoke.java:83): Failed invoking step : invokeBO $syncRequestBo using "syncRequestBo" for update;
com.splwg.base.api.service.ServiceExecutionPolicy.requestCommitAndInitialize(ServiceExecutionPolicy.java:76): Encountered exception, session marked for rollback

Changes

Cause

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