The datamart extraction job fails with the following error message.
Clarity Version 22.214.171.1242 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.
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.