0 Replies Latest reply: Nov 28, 2013 3:08 AM by 981976 RSS

    Error while running ETL for Financials_Oracle R1213.

    981976

      Hi All,

       

      I have done all installation and configuration for OBIA 7.9.6.4. I am getting following error while running ETL for Financials_Oracle R1213.

      ===========================================================================================================

       

      1)While starting DAC server, I am getting following  error:

       

      SEVERE: Incorrectly specified Post-Etl Script/Executable

       

       

      ================================================================================================================

      2) After starting ETL Financials_Oracle R1213,

       

      ANOMALY INFO::: Error while executing : INFORMATICA TASK:SILOS:SIL_InsertRowInRunTable:1:(Source : FULL Target : FULL)

      MESSAGE:::

      Irrecoverable Error

      pmcmd startworkflow -sv BIA_IS -d Domain_oracle2go2.us.oracle.com -u Administrator -p ****  -f SILOS  -paramfile /home/oracle/Informatica/9.0.1/server/infa_shared/SILOS.SIL_InsertRowInRunTable.ORA_R1213_Flatfile.txt  SIL_InsertRowInRunTable

      Status Desc : Failed

      WorkFlowMessage :

      Error Message : Unknown reason for error code 36331

      ErrorCode : 36331

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

       

      1. com.siebel.analytics.etl.etltask.InformaticaTask.doExecute(InformaticaTask.java:254)
      2. com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
      3. com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
      4. com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
      5. com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)
      6. com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
      7. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      8. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      9. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      10. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      11. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      12. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
      13. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
      14. java.lang.Thread.run(Thread.java:619)

      (Number of retries : 1) pmcmd startworkflow -sv BIA_IS -d Domain_oracle2go2.us.oracle.com -u Administrator -p ****  -f SILOS  -paramfile /home/oracle/Informatica/9.0.1/server/infa_shared/SILOS.SIL_InsertRowInRunTable.ORA_R1213_Flatfile.txt  SIL_InsertRowInRunTable 2013-11-27 11:26:59.923 INFORMATICA TASK:SILOS:SIL_InsertRowInRunTable:1:(Source : FULL Target : FULL) has finished execution with Failed status.2013-11-27 11:26:28.855 Acquiring Resources 2013-11-27 11:26:28.857 Acquired Resources  2013-11-27 11:26:28.858 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 Errorpmcmd startworkflow -sv BIA_IS -d Domain_oracle2go2.us.oracle.com -u Administrator -p ****  -f SILOS  -paramfile /home/oracle/Informatica/9.0.1/server/infa_shared/SILOS.SIL_InsertRowInRunTable.ORA_R1213_Flatfile.txt  SIL_InsertRowInRunTableStatus Desc : FailedWorkFlowMessage : Error Message : Unknown reason for error code 36331ErrorCode : 36331EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.IrrecoverableException

      1. com.siebel.analytics.etl.etltask.InformaticaTask.doExecute(InformaticaTask.java:254)
      2. com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:477)
      3. com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:372)
      4. com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:253)
      5. com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:655)
      6. com.siebel.analytics.etl.taskmanager.XCallable.call(XCallable.java:63)
      7. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      8. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      9. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      10. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      11. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      12. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
      13. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
      14. java.lang.Thread.run(Thread.java:619)

       

      (Number of retries : 1)

       

      pmcmd startworkflow -sv BIA_IS -d Domain_oracle2go2.us.oracle.com -u Administrator -p ****  -f SILOS  -paramfile /home/oracle/Informatica/9.0.1/server/infa_shared/SILOS.SIL_InsertRowInRunTable.ORA_R1213_Flatfile.txt  SIL_InsertRowInRunTable

       

      2013-11-27 11:26:59.923 INFORMATICA TASK:SILOS:SIL_InsertRowInRunTable:1:(Source : FULL Target : FULL) has finished execution with Failed status.

      ====================================================================================================================

       

      Could anyone please help me to resolve this error?

       

      Regards,

      Narottam