CONCURRENCY ERROR OCCURS ON MULTI-THREADED BATCH (Doc ID 2113179.1)

Last updated on JANUARY 08, 2024

Applies to:

Symptoms

On : CCB 2.5.0.1.0 version,

While attempting to run batch LATEPYMT in multi-thread mode,
get this error in the batch log,

ERROR
-----------------------

1. Such error in the batch log,

ERROR (com.splwg.base.api.batch.ThreadWorkUnitExecutable) Error #1 encountered at work unit Bill_Id(729188067873) - this error will be logged and the unit skipped during the database transaction replay
com.splwg.shared.common.ApplicationError: (Server Message)
Category: 6
Number: 8
Call Sequence: ;CIPBBLLR
Program Name: CIPBBLLR
Text: Concurrency Error. Please retry this transaction.
Description: Concurrency Error. Another user updated this data while you were making your changes. Please try this transaction again.
Table:
Field:
at com.splwg.base.support.context.FrameworkSession.addError(FrameworkSession.java:1959)
at com.splwg.base.support.context.FrameworkSession.addError(FrameworkSession.java:1936)
at com.splwg.base.support.program.ThrowApplicationError.throwError(ThrowApplicationError.java:85)

2. On the Batch Run Tree, there are some errors showing that Concurrency Error. Please retry this Transaction. Account ID: XXX.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Batch Job Submission
2. Run LATEPYMT with Thread Count=5, Thread Num=0.

Cause

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