ASCP Plan Erroring Out In MSCSDW Snapshot Delete Worker With Lock On Table MSC_SUPPLIES
(Doc ID 1242077.1)
Last updated on JUNE 07, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Executable:MSCSDW - Snapshot Delete Worker
Symptoms
When attempting to run an ASCP plan, the MSCSDW - Snapshot Delete Worker shows thousands of the following message:
LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
Then it errors out with no specific error message as per the bottom of the log:
LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 14-OCT-2010 11:12:27 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=-2) (DATE=14-OCT-2010 11: 0:00
.14-OCT-2010 11:12:37: executed -2 (-2) (TASK=-2) 0:10
LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 14-OCT-2010 11:12:37 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=40) (DATE=14-OCT-2010 11: 0:00
wait for lock in MSC_SUPPLIES
***** End Of Program - Snapshot Delete Worker *****
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
No completion options were requested.
Output is not being printed because:
The print option has been disabled for this report.
Concurrent program returned no reason for failure.
There were no other concurrent requests running apart from the plan.
STEPS:
1. Run ASCP plan
2. Plan fails in snapshot delete worker with no detailed message as to why
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 |