Load Data Warehouse job fails

Document ID : KB000004219
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Problem:

Load Data Warehouse job fails with database lock ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired  

 

Steps to Reproduce:

This is an intermittent issue that occurs on multiple environments, usually on Incremental Load:

1. Schedule an Incremental Load Data Warehouse job few times per day
2. Check the job status in the Jobs - Log page 

 

Expected Result:

The Load Data Warehouse job completes every time.

 

Actual Result: 

The Load Data Warehouse job fails intermittently (sometimes once per month) with error ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. Any Full or Incremental Load after this will also fail until the lock is removed

 

 

 

Cause:

Cause: 

Reported as defect CLRT-81011

 

Resolution:

 

Resolution:

Resolved in PPM 15.2

Workaround:

Manual only: Contact the DBA to manually remove the lock from the specified table, then run Load Data Warehouse job - Full Load