The Datamart job is failing after the upgrade to 13.3 patch 7. It gives below error:
PMD application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - : ORA-20000: Error in NBI_CLEAN_DATAMART_SP: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "SPATQA1.NBI_EXTRACT_SP", line 362
ORA-06512: at line 1
It is scheduled to run at 1:00 AM but it has failed all the time on its schedule. When we run it in immediate mode, it runs sucessfully.
What could be the possile reason for this?