[MSCSDW] Memory Based Snapshot Delete Worker Is Hanging (Doc ID 1335174.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
MSCSDW

Symptoms

When attempting to to run an ASCP plan, the Snapshot Delete Worker (MSCSDW) which is launched from the Memory Based Snapshot appears to be hung up or looping. It runs for hours and keeps posting the same messages in the request .

LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 01-JUL-2011 09:22:04 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=115) (DATE=01-JUL-2011 09 0:00
.01-JUL-2011 09:22:04: executed 115 (115) (TASK=MSLSDW_TSK_DEL_SRP_EXCEP 0:00
fetching info on request: 436489
LOCK TABLE msc_snapshot_tasks IN EXCLUSIVE MODE
..Locked msc_snapshot_tasks at 01-JUL-2011 09:22:04 0:00
.SNAP-PROCESS TASK (ACTION=E_FETCHED) (TASK_ID=-2) (DATE=01-JUL-2011 09: 0:00
.01-JUL-2011 09:22:14: executed -2 (-2) (TASK=-2)


STEPS:
1) Create a distribution plan
2) Click 'Launch' to run the plan
3) Check the status from 'view->request'
4) Monitor the request status, the snapshot delete worker is hanging , check the log, find that it tries to lock the table msc_snapshot_tasks .

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms