2 Replies Latest reply on Oct 8, 2019 9:12 AM by syed zuhaib

    Is it possible to do Flat file to Flat file Data Masking using PDM

    Naga Lakshmi New Member

       

      Hi,

      I used 10.2.0 HF1 version of TDM. for doing persistent data masking using Flat file to Flat file. Facing this issue.I created a new masking rule,made a new plan and execute it.but when Execution start it shows error.

       

      [2019-09-19 12:38:08.219] ERROR pool-3-thread-1

      1. c.i.ilm.pdmds.offline.load.internal.ETLTaskProgressMonitor null com.informatica.powercenter.sdk.lm.JLMException: null

      at com.informatica.powercenter.sdk.lm.JLMException.handleExceptionOrWarning(JLMException.java:545)

      at com.informatica.powercenter.sdk.lm.JLMSession10.getSessionDetails(JLMSession10.java:606)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskProgressMonitor.getSessionStatistics(ETLTaskProgressMonitor.java:305)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskProgressMonitor.updateLatestTaskDetails(ETLTaskProgressMonitor.java:124)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskProgressMonitor.updateTaskProgress(ETLTaskProgressMonitor.java:96)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskProgressMonitor.waitTillWorkflowCompletion(ETLTaskProgressMonitor.java:75)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskExecUtil.waitTillWorkflowCompletion(ETLTaskExecUtil.java:40)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskExecUtil.waitTillWorkflowCompletion(ETLTaskExecUtil.java:23)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskHandler.executeWorkflow(ETLTaskHandler.java:92)

      at com.informatica.ilm.pdmds.offline.load.internal.ETLTaskHandler.handle(ETLTaskHandler.java:46)

      at com.informatica.ilm.pdmds.offline.load.internal.LoaderThread.run(LoaderThread.java:47)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at java.lang.Thread.run(Thread.java:748)

       

       

      [2019-09-19 12:38:27.727] INFO  main

      1. c.i.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow All plan workflows executed

      [2019-09-19 12:38:28.025] INFO  main

      1. c.i.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow Updated plan execution details

      [2019-09-19 12:38:28.029] ERROR main

      1. c.i.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow LOAD_FAILED java.lang.Exception: LOAD_FAILED

      at com.informatica.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow.run(LoadWorkFlow.java:276)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJobStep.runInternal(OfflineJobStep.java:59)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJob.run(OfflineJob.java:133)

      at com.informatica.ilm.pdmds.offline.main.Executor.main(Executor.java:99)

       

       

      [2019-09-19 12:38:28.065] INFO  main

      1. com.informatica.ilm.pdmds.offline.util.OfflineUtil Plan status for flatfiletoflatfile is updated to LOAD_FAILED

      [2019-09-19 12:38:28.068] ERROR main

      1. c.i.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow LOAD_FAILED java.lang.Exception: LOAD_FAILED

      at com.informatica.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow.run(LoadWorkFlow.java:276)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJobStep.runInternal(OfflineJobStep.java:59)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJob.run(OfflineJob.java:133)

      at com.informatica.ilm.pdmds.offline.main.Executor.main(Executor.java:99)

       

       

      [2019-09-19 12:38:28.092] INFO  main

      1. com.informatica.ilm.pdmds.offline.util.OfflineUtil Plan status for flatfiletoflatfile is updated to LOAD_FAILED

      [2019-09-19 12:38:28.115] ERROR main

      1. com.informatica.ilm.pdmds.offline.internal.OfflineJob [OFFLINE_002] An unexpected error occurred when running the job. Cause: [OFFLINE_001] An internal error occurred while running the job. com.informatica.core.exception.InternalException: [OFFLINE_001] An internal error occurred while running the job.

      at com.informatica.ilm.pdmds.offline.internal.OfflineJobStep.runInternal(OfflineJobStep.java:63)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJob.run(OfflineJob.java:133)

      at com.informatica.ilm.pdmds.offline.main.Executor.main(Executor.java:99)

      Caused by: java.lang.RuntimeException: LOAD_FAILED

      at com.informatica.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow.run(LoadWorkFlow.java:324)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJobStep.runInternal(OfflineJobStep.java:59)

      ... 2 common frames omitted

       

       

      [2019-09-19 12:38:28.128] INFO  main

      1. com.informatica.ilm.pdmds.offline.internal.OfflineJob [OFFLINE_008] Job status set to ERRORED

      [2019-09-19 12:38:28.132] ERROR main

      1. com.informatica.ilm.pdmds.offline.main.Executor [OFFLINE_002] An unexpected error occurred when running the job. Cause: [OFFLINE_001] An internal error occurred while running the job. com.informatica.core.exception.InternalException: [OFFLINE_001] An internal error occurred while running the job.

      at com.informatica.ilm.pdmds.offline.internal.OfflineJobStep.runInternal(OfflineJobStep.java:63)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJob.run(OfflineJob.java:133)

      at com.informatica.ilm.pdmds.offline.main.Executor.main(Executor.java:99)

      Caused by: java.lang.RuntimeException: LOAD_FAILED

      at com.informatica.ilm.pdmds.offline.jobstephandlers.workflow.LoadWorkFlow.run(LoadWorkFlow.java:324)

      at com.informatica.ilm.pdmds.offline.internal.OfflineJobStep.runInternal(OfflineJobStep.java:59)

        ... 2 common frames omitted