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:
Reported as defect CLRT-81011
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