1 2 Previous Next 16 Replies Latest reply on Aug 27, 2013 1:18 PM by 1007772

    DAC execution fails in fist step

    Sudha777
      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