Planning ODS Load Worker Fails With " ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0" Error
(Doc ID 3042771.1)
Last updated on AUGUST 21, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When Data Collections is launched, one of the requests, Planning ODS Load Worker, fails.
Nav: Advanced Supply Chain Planner(R) -> Collections -> Oracle Systems -> Standard Collections -> Enter the parameters and Click on Submit.
The following error could be seen in the log:
MSCPDCW: Planning ODS Load Worker
+---------------------------------------------------------------------------+
Current system time is 14-AUG-2024 00:50:29
+---------------------------------------------------------------------------+
[14-AUG-2024 00:50:29]: **Starts**
[14-AUG-2024 01:05:51]: **Ends**
ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
.......
14-AUG 00:50:50 : The sql statement is INSERT INTO MSC.JOB_OPERATIONS_xxx SELECT * from MSC.MSC_JOB_OPERATIONS WHERE sr_instance_id .....
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
14-AUG 01:05:51 : <>
14-AUG 01:05:51 : <>SELECT ms.TRANSACTION_ID, opr.OPERATION_SEQ_NUM, opr.SR_INSTANCE_ID, opr.ORGANIZATION_ID, opr.RECOMMENDED,.....
14-AUG 01:05:51 : <>INSERT INTO MSC.JOB_OPERATIONS_xxx SELECT * from MSC.MSC_JOB_OPERATIONS WHERE sr_instance_id = ....
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
+---------------------------------------------------------------------------+
Current system time is 14-AUG-2024 00:50:29
+---------------------------------------------------------------------------+
[14-AUG-2024 00:50:29]: **Starts**
[14-AUG-2024 01:05:51]: **Ends**
ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
.......
14-AUG 00:50:50 : The sql statement is INSERT INTO MSC.JOB_OPERATIONS_xxx SELECT * from MSC.MSC_JOB_OPERATIONS WHERE sr_instance_id .....
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
14-AUG 01:05:51 : <
14-AUG 01:05:51 : <
14-AUG 01:05:51 : <
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
14-AUG 01:05:51 : ORA-04021: timeout occurred while waiting to lock object MSC.BIN$Hgi/YBfKzgTgY+ME1Apg7A==$0
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 |