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
This error usually indicates that something (another session) is already using this table, so the SQL statements issued by the Load Data Warehouse job could not be executed.
Please check with your DBA to ensure any queries using PPM_DWH table DWH_FIN_PLAN are stopped, and re-run your job again.
This should resolve your issue. Hope this helps!
Nika HadzhikidiCA TechnologiesPrincipal Support Engineer