Hello Everyone, we're in the middle of testing retirement job.

but then the job cannot start to insert data from the staging file created by ilm retirement entity.

the staging file creation is completed successfully by ilm.

we also notice the table has been generated in the datavault, by the file archive loader job.

we think there's no problem in generating the staging file & loading the xml, bcp.zip file.

below is the error message shown in ilm web.

our setup is the following

ILM 6.4.4

IDV 6.4.4

WIN Svr 2016

Ora12c Repo

===================== ERROR MESSAGE =================

07-Feb-2019 14:56:22ICT  AMEngineLogAdvice: Invoking com.informatica.fas.services.impl.FileArchiveLoaderServiceImpl.execute(38, 128, {ARCHIVE_JOB_ID=null})

07-Feb-2019 14:56:22ICT  File Archive Loader invoked as part of archive schedule, will process job/s 37

07-Feb-2019 14:56:22ICT  Initiating load process for 37 to destination CONN_DC1ACVILM01_DBSSK_VAULT

07-Feb-2019 14:56:23ICT  Validated IDV server in 78 milliseconds

07-Feb-2019 14:56:23ICT  Validating Metadata XML - started 37_METADATA_20190207_1.xml

07-Feb-2019 14:56:23ICT  Validation Metadata XML - completed in 31 milliseconds

07-Feb-2019 14:56:23ICT  Parsing Metadata XML - started 37_METADATA_20190207_1.xml

07-Feb-2019 14:56:24ICT  Parsing Metadata XML - completed for 37_METADATA_20190207_1.xml in 1093 milliseconds

07-Feb-2019 14:56:24ICT  Extracting ddl from metadata file - started

07-Feb-2019 14:56:24ICT  All schema, tables and their domains are committed successfully

07-Feb-2019 14:56:24ICT  Extracting ddl - completed for metadata file 37_METADATA_20190207_1.xml in 32 milliseconds

07-Feb-2019 14:56:24ICT  Loading of Transaction Data for Archive Job Id 37 - started

07-Feb-2019 14:56:24ICT  Loading transaction data files

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 1 [95] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 2 [96] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 2 [96] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 3 [97] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 12 [106] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 11 [105] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 10 [104] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 9 [103] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 8 [102] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 7 [101] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 6 [100] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 5 [99] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 4 [98] started

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 12 [106] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 11 [105] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 8 [102] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 9 [103] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 10 [104] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 1 [95] started processing 37_M69_-9_20190207_1.bcp.zip for ITEM_DKE_KR from schema DBSSK

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 6 [100] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 7 [101] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 5 [99] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 4 [98] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 3 [97] stopped

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 1 [95] picking and unzipping 37_M69_-9_20190207_1.bcp.zip

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 1 [95] included 37_M69_-9_20190207_1.bcp for loading

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 1 [95] importing ITEM_DKE_KR from schema DBSSK in DBSSK_VAULT

07-Feb-2019 14:56:24ICT  TransactionLoaderThread 1 [95] stopped

07-Feb-2019 14:56:24ICT  Loading of Transaction Data Failed for Archive Job Id 37 . Check logs for more details

07-Feb-2019 14:56:24ICT  AMEngineLogAdvice: Exception com.informatica.fas.services.impl.FileArchiveLoaderServiceImpl.execute(38, 128, {ARCHIVE_JOB_ID=null})

07-Feb-2019 14:56:24ICT  The file archive loader received the following exception: #Exception occurred while processing Table :DBSSK.ITEM_DKE_KR#

07-Feb-2019 14:56:24ICT  java.lang.Exception: The file archive loader received the following exception: #Exception occurred while processing Table :DBSSK.ITEM_DKE_KR#

07-Feb-2019 14:56:24ICT  com.applimation.aop.AMEngineLogAdvice.afterThrowing(AMEngineLogAdvice.java:156)

07-Feb-2019 14:56:24ICT  sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

07-Feb-2019 14:56:24ICT  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

07-Feb-2019 14:56:24ICT  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

07-Feb-2019 14:56:24ICT  java.lang.reflect.Method.invoke(Method.java:497)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invokeHandlerMethod(ThrowsAdviceInterceptor.java:144)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:129)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:51)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

07-Feb-2019 14:56:24ICT  org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)

07-Feb-2019 14:56:24ICT  com.informatica.fas.services.impl.FileArchiveLoaderServiceImpl$$EnhancerBySpringCGLIB$$bbab27c8.execute(<generated>)

07-Feb-2019 14:56:24ICT  com.applimation.services.thread.AMServiceThread.run(AMServiceThread.java:91)

07-Feb-2019 14:56:24ICT  com.applimation.services.thread.AMThreadQueueManager$AMThreadQueueElement.run(AMThreadQueueManager.java:531)

07-Feb-2019 14:56:24ICT  java.lang.Thread.run(Thread.java:745)

07-Feb-2019 14:56:24ICT  The file archive loader received the following exception: #Exception occurred while processing Table :DBSSK.ITEM_DKE_KR#

==========================================

Hopefully sombody have an idea about this error.

Regards,

Aji