CMIngestion Batch Failed (Doc ID 2958032.1)

Last updated on JULY 03, 2023

Applies to:

Symptoms

CMIngestion batch failed with error "ORA-30926

java.lang.Exception: ORA-30926 unable to get a stable set of rows in the source tables
at com.oracle.fccm.amlxe.dataPipelineService.sequencer.impl.SequencerDAOImpl.getQueries(SequencerDAOImpl.java:107) ~[classes!/:?]
at com.oracle.fccm.amlxe.dataPipelineService.sequencer.impl.SequencerDAOImpl$$FastClassBySpringCGLIB$$7e36e608.invoke(<generated>) ~[classes!/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.27.jar!/:5.3.27]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[

Service:::{"execTech":"REST","sqlQuery":"[{\"vParamName\":\"datamovementcode\",\"vParaValue\":\"AML_ECM_CUST_RISK_LATEST\"},{\"vParamName\":\"URL\",\"vParaValue\":\"datamovementservice/datamovementservice\"},{\"vParamName\":\"FICMISDATE\",\"vParaValue\":\"$MISDATE\"},{\"vParamName\":\"METHOD\",\"vParaValue\":\"POST\"},{\"vParamName\":\"dataorigin\"},{\"vParamName\":\"datamovementoperation\",\"vParaValue\":\"MI\"},{\"vParamName\":\"BATCHRUNID\",\"vParaValue\":\"$BATCHRUNID\"},{\"vParamName\":\"loadtype\"},{\"vParamName\":\"params\"},{\"vParamName\":\"sourcename\"},{\"vParamName\":\"serviceName\",\"vParaValue\":\"datamovementservice\"}]","rtpObj":{"$DATAORIGIN$":"MAN","$FICMISDATE$":"2020-05-16","$TASKID$":"BCUSTLOAD","$RUNTYPE$":"","batchRunType":"run","$BATCHTYPE$":"DATA","$OFSBATCHRUNID$":"CMIngestion_2020-05-16_1","$ORIGINAL_RUN_ID$":"CMIngestion_2023-06-06_1686064047440_1","$JOBNAME$":"Load Customer Business Data to Case Management","$BATCHRUNID$":"CMIngestion_2023-06-06_1686064047440_1"},"sqlParams":"{\"MISDATE\":\"2020-05-16\",\"BATCHRUNID\":\"CMIngestion_2023-06-06_1686064047440_1\"}","execType":"REST"}

Cause

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