StaleObjectStateException Encountered In D1-CMCS Batch Run In Multithreaded
(Doc ID 2798117.1)
Last updated on AUGUST 09, 2021
Applies to:Oracle Utilities Meter Data Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 2.3]
Oracle Utilities Customer to Meter Base - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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 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: , scheduleSelectionDate: 2020-01-14)].
The issue can be reproduced at will with the following steps:
1.Required Test Data:
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
3.Check batch run tree. Batch run status is in error.
4.Some of the threads are in error and some are completed.
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