My Oracle Support Banner

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 JULY 18, 2019

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.2.0 and later
Information in this document applies to any platform.

Symptoms

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
OUAF/FW - Oracle Utilities Framework
CM - Customer Modification
CLOB - Character large object
JDBC - Java Data Base Connectivity

 

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

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


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