AnsweredAssumed Answered

Datamart job is failing

Question asked by sparc.helpdesk on Sep 18, 2014
Latest reply on Oct 1, 2014 by sparc.helpdesk

Hi All,


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?