My Oracle Support Banner

ASCP Plan Erroring Out In MSCSDW Snapshot Delete Worker With Lock On Table MSC_SUPPLIES (Doc ID 1242077.1)

Last updated on JANUARY 22, 2025

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information 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.

 OR Log may show

..Locked msc_snapshot_tasks at 22-JAN-2025 02:36:04 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=-2) (DATE=22-JAN-2025 02: 0:00
.22-JAN-2025 02:36:14: executed -2 (-2) (TASK=-2) 0:10
LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 22-JAN-2025 02:36:14 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=-2) (DATE=22-JAN-2025 02: 0:00
.22-JAN-2025 02:36:24: executed -2 (-2) (TASK=-2) 0:10
LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 22-JAN-2025 02:36:24 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=40) (DATE=22-JAN-2025 02: 0:00
wait for lock in MSC_SUPPLIES
You have entered an invalid task value: 142

***** End Of Program - No title available *****
+---------------------------------------------------------------------------+

 

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.