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
The Load Data Warehouse job completes every time.
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