My Oracle Support Banner

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

Last updated on NOVEMBER 01, 2018

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

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
References


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