Oracle Customer Screening Cloud Services Bad Records Issue
(Doc ID 2930025.1)
Last updated on APRIL 24, 2023
Applies to:
Oracle Financial Services Crime and Compliance Management Transaction Monitoring Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
we have executed AMLDataLoad we are getting the below error.
[DEBUG] 2023-02-09 05:59:27.027 [qtp276777344-28] AutoWireUtil - HttpEntity request:: <{"blockId":3274,"data":{"fileName":"STG_PARTY_MASTER.csv","seprator":",","enclosedByQuotes":"true","skipLine":"0","tableName":"STG_PARTY_MASTER","FICMISDATE":"2023-02-06"},"runSkey":3601,"inputs":[],"name":"Data Load for STG_PARTY_MASTER","type":"EESERVICE","prevRunSkey":2957,"batchParams":{"$TYPE$":"DL","$DATAORIGIN$":"MAN","$FICMISDATE$":"2023-02-06","$TASKID$":"CustomerPipeline","batchRunType":"run","$OFSBATCHRUNID$":"AMLDataLoad_2023-02-06_7","$ORIGINAL_RUN_ID$":"AMLDataLoad_2023-02-09_1675922323528_1","$JOBNAME$":"Load Customer Staging Data","$BATCHRUNID$":"AMLDataLoad_2023-02-09_1675922323528_1"},"execId":7023},[Authorization:"Basic", ofs_remote_user:"OFS_SRV_ACCT", Content-Type:"application/json"]>
[DEBUG] 2023-02-09 05:59:27.027 [qtp276777344-28] AutoWireUtil - HttpEntity restTemplate:: 2078887126
[INFO ] 2023-02-09 05:59:30.486 [qtp276777344-28] AutoWireUtil - Response from Service:: <200,{"STATUS":"FAILED","MESSAGE":"Error:Some Bad Records ::36;","NO_OF_RECORDS":184},[Content-Type:"application/json", Transfer-Encoding:"chunked", Date:"Thu, 09 Feb 2023 05:59:30 GMT", Keep-Alive:"timeout=60", Connection:"keep-alive"]>
[INFO ] 2023-02-09 05:59:30.486 [qtp276777344-28] AutoWireUtil - Response from Service JsonObj:: {"RESPONSECODE":200,"MESSAGE":"Error:Some Bad Records ::36;","STATUS":"FAILED","NO_OF_RECORDS":184}
[DEBUG] 2023-02-09 05:59:30.486 [qtp276777344-28] ExecutorDAOImpl - Current act response::{"13257337-60c3-4112-aa04-c50dfbe9bd25":{"RESPONSECODE":200,"MESSAGE":"Error:Some Bad Records ::36;","STATUS":"FAILED","NO_OF_RECORDS":184}}
[ERROR] 2023-02-09 05:59:30.496 [qtp276777344-28] ExecutorDAOImpl - Exception in executePipeline
java.lang.Exception: Error:Some Bad Records ::36;
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl.executePipeline(ExecutorDAOImpl.java:1148) ~[classes!/:?]
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl.executeBatch(ExecutorDAOImpl.java:905) ~[classes!/:?]
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl$$FastClassBySpringCGLIB$$ab9f0391.invoke(<generated>) ~[classes!/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.22.jar!/:5.3.22]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl$$EnhancerBySpringCGLIB$$e3c0a0b4.executeBatch(<generated>) ~[classes!/:?]
[DEBUG] 2023-02-09 05:59:27.027 [qtp276777344-28] AutoWireUtil - HttpEntity restTemplate:: 2078887126
[INFO ] 2023-02-09 05:59:30.486 [qtp276777344-28] AutoWireUtil - Response from Service:: <200,{"STATUS":"FAILED","MESSAGE":"Error:Some Bad Records ::36;","NO_OF_RECORDS":184},[Content-Type:"application/json", Transfer-Encoding:"chunked", Date:"Thu, 09 Feb 2023 05:59:30 GMT", Keep-Alive:"timeout=60", Connection:"keep-alive"]>
[INFO ] 2023-02-09 05:59:30.486 [qtp276777344-28] AutoWireUtil - Response from Service JsonObj:: {"RESPONSECODE":200,"MESSAGE":"Error:Some Bad Records ::36;","STATUS":"FAILED","NO_OF_RECORDS":184}
[DEBUG] 2023-02-09 05:59:30.486 [qtp276777344-28] ExecutorDAOImpl - Current act response::{"13257337-60c3-4112-aa04-c50dfbe9bd25":{"RESPONSECODE":200,"MESSAGE":"Error:Some Bad Records ::36;","STATUS":"FAILED","NO_OF_RECORDS":184}}
[ERROR] 2023-02-09 05:59:30.496 [qtp276777344-28] ExecutorDAOImpl - Exception in executePipeline
java.lang.Exception: Error:Some Bad Records ::36;
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl.executePipeline(ExecutorDAOImpl.java:1148) ~[classes!/:?]
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl.executeBatch(ExecutorDAOImpl.java:905) ~[classes!/:?]
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl$$FastClassBySpringCGLIB$$ab9f0391.invoke(<generated>) ~[classes!/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.22.jar!/:5.3.22]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.5.RELEASE.jar!/:5.2.5.RELEASE]
at com.oracle.fccm.amlxe.pipelineService.impl.ExecutorDAOImpl$$EnhancerBySpringCGLIB$$e3c0a0b4.executeBatch(<generated>) ~[classes!/:?]
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 |