My Oracle Support Banner

Program 'APS Collections Refresh Snapshot Thread' Is Taking Longer And Log Shows Message Like '21-MAY 03:48:15 : Could not get lock, sleeping for 5 seconds' (Doc ID 2442712.1)

Last updated on FEBRUARY 20, 2019

Applies to:

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

Symptoms

Data Collections

ACTUAL BEHAVIOR
---------------
Sometimes APS Collections Refresh Snapshot Thread waits and does not progress - log shows messages

21-MAY 03:48:15 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:20 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:26 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:32 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:38 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:44 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:49 : Could not get lock, sleeping for 5 seconds

EXPECTED BEHAVIOR
-----------------------
APS Collections Refresh Snapshot Thread should end in seconds.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run APS Collections Refresh Snapshot 

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.