AnsweredAssumed Answered

Datamart Extraction Failure in v13.2

Question asked by nmanoha on Sep 24, 2013
Latest reply on Sep 24, 2013 by nmanoha
Hi All,


We recently upgraded to v13.2 patch2.

Datamart extraction job is failed with the below error. First when i received the error, I had CA case opened and they recommemned me to check the indexes and to verify if teh DB user account as Alter Session permissions.

I had it done and the job was processing fine.

From past two days the job is failing again with the same error. I have verified the Indexes and the DB user account as the Alter session permission as well.

Any thoughts on why this is happening again.

Failure message: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Executing NBI_EXTR_PCF_SP: ORA-20000: Error in NBI_EXTR_PCF_SP - executing NBI_PROJECT_CURRENT_FACTS_SP: ORA-20000: Error in NBI_PROJECT_CURRENT_FACTS_SP - : ORA-01403: no data found
ORA-06512: at "NIKU.NBI_EXTRACT_SP", line 362
ORA-06512: at line 1



Thanks

Outcomes