My Oracle Support Banner

CDA Trial Error Connection Failed: ORA-00054: Resource Busy And Acquire With NOWAIT Specified Or Timeout Expired (Doc ID 2226389.1)

Last updated on MAY 11, 2018

Applies to:

Oracle Health Sciences Clinical Development Analytics - Version 3.2.0.0.0 and later
Information in this document applies to any platform.

Goal

Running the following procedure on the CDA database, displays errors:

 

  
BEGIN
CDA<Trial_Name>.CDA_PROCS.CONSOLIDATE;
COMMIT;
END;
  

Oracle Database Error:
Lookup Error
ORA-20500: CDA Consolidation failed. See error stack for error. ORA-06512: at "CDA<Trial_Name>.CDA_PROCS", line 115 ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at line 2

 

Solution

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
Goal
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.