CA PPM Load Data Warehouse Job Fails with error ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired with Oracle as Database
Steps to Reproduce
Expected Result:The job to complete successfully 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
This is a known bug CLRT-81011 and targeted to be fixed in next major release
BEGIN
FOR J IN (select INDEX_NAME from USER_INDEXES where INDEX_NAME like 'DWH%')
LOOP
EXECUTE IMMEDIATE 'ALTER INDEX '|| J.INDEX_NAME || ' NOLOGGING NOPARALLEL';
END LOOP J;
END;