ILM retirement job cannot insert data to Datavault
Wicakson Aji Feb 7, 2019 8:13 AMHello 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