AMLToCMEventData Batch Fail (Doc ID 3038786.1)

Last updated on AUGUST 06, 2024

Applies to:

Symptoms

Observed below error in AMLToCMEventData_2015-07-31_1_EVACCTLOAD.log.

---------------------------------------

raValue":"IS"},{"vParamName":"serviceName","vParaValue":"datamovementservice"}]
[DEBUG] 2024-07-10 04:25:57.895 [qtp1187146208-24] LoggerConnection - Trying to fetch connection for log.
[DEBUG] 2024-07-10 04:25:57.896 [qtp1187146208-24] LoggerConnection - isJNDI value retrieved is true
[DEBUG] 2024-07-10 04:25:57.922 [pool-38-thread-1] MultiThreadedDataPipelineExecution - Query being resulted::::[{"vParamName":"loadtype"},{"vParamName":"dataorigin"},{"vParamName":"METHOD","vParaValue":"POST"},{"vParamName":"URL","vParaValue":"datamovementservice/datamovementservice"},{"vParamName":"FICMISDATE","vParaValue":"$MISDATE"},{"vParamName":"datamovementcode","vParaValue":"AML_ECM_INSURANCE_POLICY_BAL_EV"},{"vParamName":"params"},{"vParamName":"BATCHRUNID","vParaValue":"$BATCHRUNID"},{"vParamName":"sourcename"},{"vParamName":"datamovementoperation","vParaValue":"IS"},{"vParamName":"serviceName","vParaValue":"datamovementservice"}]
[ERROR] 2024-07-10 04:25:57.928 [qtp1187146208-24] ExecutorService - Exception occurred
java.lang.RuntimeException: java.lang.RuntimeException: External service execution failed with exception: Expected a ':' after a key at 76 [character 77 line 1]
at com.oracle.fccm.amlxe.dataPipelineService.sequencer.impl.SequencerDAOImpl.getQueries(SequencerDAOImpl.java:117) ~[classes!/:24.05.01]
at jdk.internal.reflect.GeneratedMethodAccessor216.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:756) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:756) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-6.0.11.jar!/:6.0.11]
at com.oracle.fccm.amlxe.dataPipelineService.sequencer.impl.SequencerDAOImpl$$SpringCGLIB$$0.getQueries() ~[classes!/:24.05.01]
at com.oracle.fccm.amlxe.dataPipelineService.impl.ExecutorDAOImpl.executePipeline(ExecutorDAOImpl.java:247) ~[classes!/:24.05.01]
at jdk.internal.reflect.GeneratedMethodAccessor200.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:756) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:756) ~[spring-aop-6.0.11.jar!/:6.0.11]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-6.0.11.jar!/:6.0.11]
at com.oracle.fccm.amlxe.dataPipelineService.impl.ExecutorDAOImpl$$SpringCGLIB$$0.executePipeline() ~[classes!/:24.05.01]
at com.oracle.fccm.amlxe.dataPipelineService.services.ExecutorService.executePipeline(ExecutorService.java:101) ~[classes!/:24.05.01]
at jdk.internal.reflect.GeneratedMethodAccessor198.invoke(Unknown Source) ~[?:?]

Cause

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