ECM 8.0.8 - 'Oracle_CS_Event_Processing' FCCM Batch Failing (Doc ID 2752465.1)

Last updated on NOVEMBER 25, 2022

Applies to:

Symptoms

Oracle_CS_Event_Processing batch failed at Task 42 (DT_CORRELATION) with the below Error.

Error in Task logs :

Inside Method for fetching the Ingestion and Correlation Skeys
Query for fetching the surrogate Keys for Ingestion and Correlation is::SELECT T.N_INGESTION_RUNSKEY, T.N_CORRELATION_RUNSKEY FROM FCC_BATCH_DETAIL T WHERE T.N_CORRELATION_RUNSKEY IN (SELECT M.N_RUN_SKEY FROM FCC_BATCH_RUN M WHERE M.V_BATCH_RUN_ID = 'FCCMINFO_1613073481954_20180202_1')
Batch Run ID is::FCCMINFO_1613073481954_20180202_1
Correlation Skey picked up is ::740
ingestSkey are::740
selectSourceSkey is ::select listagg(V_GROUP_NAME,',') within group(order by V_GROUP_NAME) V_GROUP_NAME from FCC_PROCESSING_GROUP inner join (select grpid from (SELECT TRIM(SUBSTR(txt,INSTR(txt, ';', 1, level) + 1,INSTR(txt, ';', 1, level + 1) -Instr(Txt, ';', 1, Level) - 1)) As grpid FROM (SELECT ';'||replace(t.V_SOURCE_ID,',',';')||';' txt FROM fcc_batch_run t INNER JOIN FCC_PROCESSING_GROUP ON FCC_PROCESSING_GROUP.N_GROUP_ID = t.n_group_id WHERE t.v_batch_run_id= ?) CONNECT BY level <= LENGTH(txt) - LENGTH(REPLACE(txt, ';', '')) - 1)) t on t.grpid = FCC_PROCESSING_GROUP.N_GROUP_ID
Batch Name is:::ORACLECS
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.