StaleObjectStateException Encountered In D1-CMCS Batch Run In Multithreaded
(Doc ID 2798117.1)
Last updated on MAY 31, 2024
Applies to:
Oracle Utilities Meter Data Management - Version 2.3.0.2.0 to 2.4.0.0.0 [Release 2.3 to 2.4]Oracle Utilities Customer to Meter Base - Version 2.7.0.3.0 and later
Information in this document applies to any platform.
Symptoms
On : 2.7.0.3.0 version, Framework
StaleObjectStateException encountered in D1-CMCS Batch Run in Multithreaded
When running D1-CMCS base batch in multi-threaded run, it returns the error:
ERROR
-----------------------
Error committing session's transaction
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.splwg.d1.domain.admin.measurementCycle.entities.MeasurementCycleSchedule_Per#MeasurementCycleSchedule_Id(measurementCycleId: [11], scheduleSelectionDate: 2020-01-14)].
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Required Test Data:
Measurement Cycle
Measurement Cycle Route
Measurement Cycle Schedule
Measurement Cycle Schedule with no Measurement Cycle Schedule Routes yet
linked to it.
2.Run D1-CMCS batch in multi-threaded.
Expected result: Measurement Cycle Schedule Routes should be created for the non-pre-
generated Measurement Cycle Schedules w/ scheduled selection date <= batch
business date.
3.Check batch run tree. Batch run status is in error.
4.Some of the threads are in error and some are completed.
-----------------------
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 |