This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Aug 27, 2013 6:18 AM by 1007772 RSS

DAC execution fails in fist step

Sudha777 Explorer
Currently Being Moderated
HI

While running DAC full load iam getting following error, at first step only it is failing

2013-02-05 22:51:21.335 Acquiring Resources

2013-02-05 22:51:21.336 Acquired Resources


2013-02-05 22:51:21.337 INFORMATICA TASK:SILOS:SIL_InsertRowInRunTable:1:(Source : FULL Target : FULL) has started.



ANOMALY INFO::: Error while executing : INFORMATICA TASK:SILOS:SIL_InsertRowInRunTable:1:(Source : FULL Target : FULL)
MESSAGE:::
Irrecoverable Error
Request to start workflow : 'SIL_InsertRowInRunTable with the instance name SIL_InsertRowInRunTable' has completed with error code 17
Error Message : Parameter file does not exist.
Command Used: pmcmd startworkflow -sv infois -d Domain_123 -u Administrator -p **** -f SILOS -paramfile /Oracle/OBIAPPS/Informatica/9.1.0/server/infa_shared/SILOS.SIL_InsertRowInRunTable.ORA_R1213_Flatfile.txt SIL_InsertRowInRunTable
Workflow Message:

=====================================
STD OUTPUT
=====================================

Informatica(r) PMCMD, version [9.1.0 HotFix2], build [357.0903], LINUX 32-bit
Copyright (c) Informatica Corporation 1994 - 2011
All Rights Reserved.

Invoked at Tue Feb 05 22:51:26 2013

Connected to Integration Service: [infois].
Starting workflow [SIL_InsertRowInRunTable]
ERROR: Workflow [SILOS:SIL_InsertRowInRunTable[version 1]]: Parameter file [Oracle/OBIAPPS/Informatica/9.1.0/server/infa_shared/SILOS.SIL_InsertRowInRunTable.ORA_R1213_Flatfile.txt] not found. Please check the Integration Service log for more information.
Disconnecting from Integration Service

Completed at Tue Feb 05 22:51:27 2013

=====================================
ERROR OUTPUT
=====================================

EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.IrrecoverableException

com.siebel.analytics.etl.etltask.InformaticaTask.doExecute(InformaticaTask.java:254)
com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)
com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.java:138)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.java:138)
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
java.lang.Thread.run(Thread.java:662)

(Number of retries : 1)
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points