AnsweredAssumed Answered

Datamart Job Fails

Question asked by jadhavvinod123 on Apr 25, 2014
Latest reply on Nov 3, 2014 by ThomasConnery

Post our upgrade to 13.2 Datamart job was running OK for a while howver it has been failing since last week and have no clue why. This is the error we get however the SPs in qts look fairly innocent not sure what's happening, any ideas please?

 

Log Entry Date Message
Job Started 24/04/14 9:00 PM 
Job Completed 24/04/14 9:04 PM java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Calling NBI_EXTR_RF_SP: ORA-20000: Error in NBI_EXTR_RF_SP - SELECTING PROJECTS COUNT: ORA-20000: Error in NBI_RF_SP - : ORA-01403: no data found
ORA-06512: at "CLARITY_OWNER.NBI_EXTRACT_SP", line 362
ORA-06512: at line 1
Error 24/04/14 9:04 PM PMD application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Calling NBI_EXTR_RF_SP: ORA-20000: Error in NBI_EXTR_RF_SP - SELECTING PROJECTS COUNT: ORA-20000: Error in NBI_RF_SP - : ORA-01403: no data found
ORA-06512: at "CLARITY_OWNER.NBI_EXTRACT_SP", line 362
ORA-06512: at line 1

Outcomes