DAC is failing to start the Informatica ETL. Ver:Apps 7.9.5 & infa 8.1.1
685897Feb 18 2009 — edited Feb 19 2009hello ALL.
My DAC client and Informatica client is on windows and DAC server and Informatica is on Linux.
I am getting similar issue:
D:\OracleBI\DAC\ServerLog
12 SEVERE Wed Feb 18 14:22:43 PST 2009 Starting ETL Process.
13 SEVERE Wed Feb 18 14:22:48 PST 2009 Informatica Status Poll Interval new value : 20000(milli-seconds)
14 SEVERE Wed Feb 18 14:22:52 PST 2009 /d01/OracleBIApps/DAC/Informatica/parameters/input/FLAT FILE specified is not a currently existing directory
15 SEVERE Wed Feb 18 14:22:53 PST 2009 Request to start workflow : 'SILOS:SIL_InsertRowInRunTable' has completed with error code 7
16 SEVERE Wed Feb 18 14:22:54 PST 2009 ETL seems to have completed. Invoking shut down dispatcher after the notification from the last running task.
17 SEVERE Wed Feb 18 14:22:54 PST 2009 Finishing ETL Process.
18 SEVERE Wed Feb 18 14:22:54 PST 2009 MESSAGE:::Some steps failed.
EXCEPTION CLASS::: com.siebel.etl.engine.bore.SomeSessionsFailedException
I have made sure that everything that ED has mentioned, i have checked still can't resolve the issue.
in my WorkflowLogs/SIL_InsertRowInRunTable.log (according to this error, i have placed the required parameters files in the SrcFiles and LkpFiles. but still, the ETL process is being stuck at first step).
this is the error i found:
INFO : LM_36435 Wed Feb 18 12:06:13 2009 : (25894|-1589191776) Starting execution of workflow SIL_InsertRowInRunTable in folder SILOS last saved by user Administrator.
INFO : LM_44195 Wed Feb 18 12:06:13 2009 : (25894|-1589191776) Workflow SIL_InsertRowInRunTable service level SLPriority:5,SLDispatchWaitTime:1800.
INFO : LM_36388 Wed Feb 18 12:06:14 2009 : (25894|-1589191776) Session task instance SIL_InsertRowInRunTable is waiting to be started.
INFO : LM_36682 Wed Feb 18 12:06:16 2009 : (25894|-1589191776) Session task instance SIL_InsertRowInRunTable: started a process with pid 14937 on node http://node01_osirhdev12.osius.com.
INFO : LM_36330 Wed Feb 18 12:06:16 2009 : (25894|-1589191776) Session task instance SIL_InsertRowInRunTable: Execution started.
ERROR : VAR_27086 : (25894|-1578701920) Cannot find specified parameter file [d01/Informatica/PowerCenter8.1.1/server/infa_shared/SrcFiles/SILOS.SIL_InsertRowInRunTable.txt] for [session http://SIL_InsertRowInRunTable.SIL_InsertRowInRunTable].
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : TM_6793 Fetching initialization properties from the Integration Service. : (Wed Feb 18 12:06:23 2009)
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [DISP_20305 The Preparer DTM with process id 14937 is running on node http://node01_osirhdev12.osius.com.
: (Wed Feb 18 12:06:23 2009)]
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : http://PETL_24036 Beginning the prepare phase for the session.
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [TM_6721 Started http://Connect to Repository].
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [TM_6722 Finished Connect to Repository. It took http://0.24927] seconds.
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [TM_6794 Connected to repository PowerCenter in domain http://Domain_osirhdev12.osius.com user Administrator]
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [TM_6721 Started http://Fetch Session from Repository].
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [TM_6722 Finished Fetch Session from Repository. It took http://16.3948] seconds.
INFO : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : TM_6793 Fetching initialization properties from the Integration Service. : (Wed Feb 18 12:06:40 2009)
ERROR : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [CMN_1761 Timestamp Event: Wed Feb 18 12:06:40 2009]
ERROR : LM_36488 Wed Feb 18 12:06:40 2009 : (25894|-1599681632) Session task instance SIL_InsertRowInRunTable : [PETL_24049 Failed to get the initialization properties from the master service process for the prepare phase [Session task instance SIL_InsertRowInRunTable: Unable to read variable definition from parameter file [/d01/Informatica/PowerCenter8.1.1/server/infa_shared/SrcFiles/SILOS.SIL_InsertRowInRunTable.txt].] with error code http://4].
ERROR : LM_36320 Wed Feb 18 12:06:42 2009 : (25894|-1589191776) Session task instance SIL_InsertRowInRunTable: Execution failed.
WARNING : LM_36331 : (25894|-1589191776) Session task instance SIL_InsertRowInRunTable failed and its "fail parent if this task fails" setting is turned on. So, Workflow SIL_InsertRowInRunTable will be failed.
ERROR : LM_36320 Wed Feb 18 12:06:42 2009 : (25894|-1589191776) Workflow SIL_InsertRowInRunTable: Execution failed.
IF any one had similar issues, please reply to this.
Thanks