AnsweredAssumed Answered

Load Data Warehouse fails in 5 minutes:  resource busy and acquire with NOWAIT specified or timeout expired

Question asked by Suhas Kamble on Jan 19, 2016

It does this for different tables as I re-run on failures. This happened on Full load.

 

ETL Job timeout is 10 hours!

 

dwh_db_check_ - An error occurred executing this job entry :

Couldn't execute SQL: TRUNCATE TABLE DWH_FIN_PLAN

 

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Outcomes