1 2 Previous Next 16 Replies Latest reply: Aug 27, 2013 8:18 AM by 1007772 RSS

    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. Re: DAC execution fails in fist step
          Srini VEERAVALLI
          Make sure that you have these files at location \bifoundation\dac\Informatica\parameters

          parameterfileDW.txt
          parameterfileOLTP.txt

          You may get these files from BIApps folders->dwrep

          Also DAC->Setup->DAC System Properties->InformaticaParameterFileLocation set to Default

          Mark if helps and also appreciate if you update your other posts by marking when helps or else with your solution.

          Edited by: Srini VEERAVALLI on Feb 6, 2013 12:01 AM
          • 2. Re: DAC execution fails in fist step
            Sudha777
            Thanks for ur reply

            In /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters/input

            i have parameterfileDW.txt and parameterfileOLTP.txt

            should it be in

            /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters

            or
            /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters/input
            • 3. Re: DAC execution fails in fist step
              Srini VEERAVALLI
              Keep them at
              /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters/input

              How about DAC setting as below?
              DAC->Setup->DAC System Properties->InformaticaParameterFileLocation set to Default

              Edited by: Srini VEERAVALLI on Feb 6, 2013 12:54 AM

              Also make sure you have oob files at folders SrcFiles,LkpFiles

              Edited by: Srini VEERAVALLI on Feb 6, 2013 12:55 AM
              • 4. Re: DAC execution fails in fist step
                Sudha777
                The location of paramaters are in that /input location only,

                can i know is there any other steps which i need to check or where i had done wrong
                • 5. Re: DAC execution fails in fist step
                  Srini VEERAVALLI
                  How about DAC setting as below?
                  DAC->Setup->DAC System Properties->InformaticaParameterFileLocation set to Default
                  Also make sure you have oob files at folders SrcFiles,LkpFiles
                  For more details check
                  http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e14849/dacparameters.htm
                  • 6. Re: DAC execution fails in fist step
                    Sudha777
                    'oob'files mean

                    /Informatica/9.1.0/server/infa_shared/SrcFiles how to check oob files in this path, is it .oob?

                    except this i had checked every thing all r set as u said
                    • 7. Re: DAC execution fails in fist step
                      Sudha777
                      Hi,

                      I had created container with name EBS_R1213, and create EBS_Finance_1213 copied subject areas, build parameter and generated

                      but files in SrcFiles like EBS_R1211-3_Flatfile.DataWarehouse.SILOS.SIL_xxxxxxxx are not created

                      once we run generate , it should create files with above prefix (am i right)

                      if yes, they are not created. may i know why and where i need to check
                      • 8. Re: DAC execution fails in fist step
                        Sudha777
                        Hi Srini

                        The problem is iam not able to generate parameter files, that is why it is showing parameters not found.


                        I had generated parameters ,but parameters are not able to generate .

                        Did i missed any configaration

                        i followed this blog

                        http://oraclebisolutions.blogspot.in/2013/01/dac-installation-and-configuration.html

                        can u give any solution where i had gone wrong
                        • 9. Re: DAC execution fails in fist step
                          Srini VEERAVALLI
                          Looks like the issue is command side, the below command is generated by dac
                          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

                          There is another argment -lpf can use instead of -paramfile

                          You may need these changes; I would suggest you to read the comments from the below file and follow them

                          dac\conf-shared\infa_command.xml


                          If you still have same issue! then ping me on gtalk and do send me a email too.

                          Edited by: Srini VEERAVALLI on Feb 6, 2013 9:26 AM
                          • 10. Re: DAC execution fails in fist step
                            Sudha777
                            HI,

                            I had changed it and checked but same issue so again i reversed them,

                            U had not given u mail id,

                            One request if possible can u check using teamviewer
                            • 11. Re: DAC execution fails in fist step
                              Srini VEERAVALLI
                              Okay give try by keeping those files at location
                              /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters

                              and with setting DAC->Setup->DAC System Properties->InformaticaParameterFileLocation set to Default

                              sveerava@gmail.com
                              • 12. Re: DAC execution fails in fist step
                                Lombo
                                Hi
                                Once you Generate... maybe you could check the Parameters that have been generated... Are they correct ? I mean the source and target are OK ?

                                Good Luck
                                Antonio
                                BExpert, Brazil
                                • 13. Re: DAC execution fails in fist step
                                  SunilSharma
                                  Go to DAC Client ->setup->DAC System properties -> look for Informatica paramter filelocation -> point the path to srcfiles(eg: informatica/9.1/infa_shared/srcfiles) . After making the changes restart the dac server. once its up now run the execution plan and now it will pick it up from right location.
                                  • 14. Re: DAC execution fails in fist step
                                    Sudha777
                                    Hi ,

                                    I had checked every thing , informatica srcfile path is same as u said , i checked with default and by giving srcfile path even though it shows no parameter file exist.

                                    the problem is iam not able to generate parameter files.

                                    any solution plz
                                    1 2 Previous Next