Tuesday, April 15, 2008

DAC Task synchronize results in Error

When you try to synchronize the task in DAC, it might results in the following error.

MESSAGE:::Failed to create folder/workflow/session cache fileEXCEPTION CLASS::: com.siebel.analytics.etl.infa.interaction.PmrepUtilsException
com.siebel.analytics.etl.infa.interaction.PmrepUtils.exportListWorkflow(PmrepUtils.java:659)com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:147)com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:123)com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)
::: CAUSE :::EXCEPTION CLASS::: java.lang.NullPointerException
com.siebel.analytics.etl.infa.interaction.PmrepUtils.getRelatedObjects(PmrepUtils.java:520)com.siebel.analytics.etl.infa.interaction.PmrepUtils.getWorkflowObjects(PmrepUtils.java:490)com.siebel.analytics.etl.infa.interaction.PmrepUtils.readSessions(PmrepUtils.java:447)com.siebel.analytics.etl.infa.interaction.PmrepUtils.exportListWorkflow(PmrepUtils.java:650)com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:147)com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:123)com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

This might be because of the DAC client Windows machine setup. DAC client will use the pmrep.exe utility to connect to the Informatica repository server but if the PATH environment variable is not pointing to the Informatica client installation on the Windows machine, DAC task synchronize will results in the above error.

Please add the Informatica client path to PATH environment variable, and re-start the DAC client and then try to synchronize the task again.

2 comments:

Kiran Reddy Manne said...

I'm not able to sync the task in DAC, which was working fine till last week.

Same thing when we are connecting from different server its working fine.

Path: D:\Informatica\PowerCenter8.1.1\server\bin;
D:\oracle\product\10.2.0\client_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;
D:\oracle\product\10.2.0\client_1\jre\1.4.2\bin;;
C:\WINDOWS\system32\WindowsPowerShell\v1.0


MESSAGE:::Failed to create folder/workflow/session cache file
EXCEPTION CLASS::: com.siebel.analytics.etl.infa.interaction.PmrepUtilsException

com.siebel.analytics.etl.infa.interaction.PmrepUtils.exportListWorkflow(PmrepUtils.java:659)
com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:147)
com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:123)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)
com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

::: CAUSE :::
EXCEPTION CLASS::: java.lang.NullPointerException

com.siebel.analytics.etl.infa.interaction.PmrepUtils.getRelatedObjects(PmrepUtils.java:520)
com.siebel.analytics.etl.infa.interaction.PmrepUtils.getWorkflowObjects(PmrepUtils.java:490)
com.siebel.analytics.etl.infa.interaction.PmrepUtils.readSessions(PmrepUtils.java:447)
com.siebel.analytics.etl.infa.interaction.PmrepUtils.exportListWorkflow(PmrepUtils.java:650)
com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:147)
com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:123)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)
com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

Kiran Reddy Manne said...

I'm not able to sync the task in DAC, which was working fine till last week.

Same thing when we are connecting from different server its working fine.

Path: D:\Informatica\PowerCenter8.1.1\server\bin;
D:\oracle\product\10.2.0\client_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;
D:\oracle\product\10.2.0\client_1\jre\1.4.2\bin;;
C:\WINDOWS\system32\WindowsPowerShell\v1.0


MESSAGE:::Failed to create folder/workflow/session cache file
EXCEPTION CLASS::: com.siebel.analytics.etl.infa.interaction.PmrepUtilsException

com.siebel.analytics.etl.infa.interaction.PmrepUtils.exportListWorkflow(PmrepUtils.java:659)
com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:147)
com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:123)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)
com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)

::: CAUSE :::
EXCEPTION CLASS::: java.lang.NullPointerException

com.siebel.analytics.etl.infa.interaction.PmrepUtils.getRelatedObjects(PmrepUtils.java:520)
com.siebel.analytics.etl.infa.interaction.PmrepUtils.getWorkflowObjects(PmrepUtils.java:490)
com.siebel.analytics.etl.infa.interaction.PmrepUtils.readSessions(PmrepUtils.java:447)
com.siebel.analytics.etl.infa.interaction.PmrepUtils.exportListWorkflow(PmrepUtils.java:650)
com.siebel.analytics.etl.infa.fileParsing.TaskSync.sync(TaskSync.java:147)
com.siebel.analytics.etl.client.action.TaskSynchronizationAction.doOperation(TaskSynchronizationAction.java:123)
com.siebel.etl.gui.view.dialogs.WaitDialog.doOperation(WaitDialog.java:53)
com.siebel.etl.gui.view.dialogs.WaitDialog$WorkerThread.run(WaitDialog.java:85)