DM ORA20003 aquiring lock for shared data table.retry limit exceeded for table MSC_AGGR_MEASURE_DATA — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DM ORA20003 aquiring lock for shared data table.retry limit exceeded for table MSC_AGGR_MEASURE_DATA

in Supply Chain Planning and Collaboration 2 comments

Summary:

AggregatePlanningCollected Data job Errors

ORA20003 aquiring lock for shared data table..retry limit exceeded for table MSC_AGGR_MEASURE_DATA

Content (please ensure you mask any confidential information):

Summary of jobs ran. Starting with the latest job first.

  • 2025-08-27 Collection Job Set-
    • PROCESS ID: 111848
    • “ORA-00060: deadlock detected while waiting for resource”
  • 2025-08-26 Aggregate Planning Collected Data-  
    • PROCESS ID: 110419
    • ####[2025-08-27T03:31:22.128+00:00] [INFO] SnapshotAggregateMeasureData job got unknown status System Error service response from method snapshotAggregatedMeasureDataAsync and the server name: ServiceServer_1
    • Unkown Message: ORA-17002: I/O error: Connection closed
    • Else block of status check : ORA-17002: I/O error: Connection closed
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!