CMIngestion Batch Failed
(Doc ID 2958032.1)
Last updated on JULY 03, 2023
Applies to:
Oracle Financial Services Crime and Compliance Management Transaction Monitoring Cloud Service - Version 10.0.0.0.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |