AnsweredAssumed Answered

Datamart Extraction job failure in Clarity v13.2

Question asked by ram.iyer on Apr 24, 2014
Latest reply on Apr 24, 2014 by niting

Hi 

The datamart extraction job fails with the following error message. 

Clarity Version 13.2.0.472 07 15

Job: Datamart Extraction

Failure message: 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 "NIKU.NBI_EXTRACT_SP", line 362

ORA-06512: at line 1

 

The below indexes on NBI_PRT_FACTS were found.

Index Name

NBI_PRT_FACTS_N1 
NBI_PRT_FACTS_N2 
NBI_PRT_FACTS_N3 
NBI_PRT_FACTS_N4 
NBI_PRT_FACTS_U2 

 

 

The NBI_R_FACTS_U1 index on NBI_R_FACTS was missing and  the following statement was executed to create it.

EXEC CMN_CREATE_INDEX_SP('NBI_R_FACTS','NBI_R_FACTS_U1','UNIQUE','FACT_DATE, RESOURCE_ID',<tablespace name>);

 

We also cofirmed with the DBA to ensure that the alter session privilege is granted.

 

Please let me know if there is anything else that could be tried.

 

Regards Ram

 

 

Outcomes