6 Replies Latest reply: Apr 14, 2013 10:28 PM by 1002672 RSS

    New to BIAPPS- Getting Error while loading HR PAYROLL

    Jay66Online-Oracle
      Hello,

      I am installing BIApps for the first time on a Linux system, and have ensured all parameters to be set correctly as per the prescribed document.

      - DAC is up and Running
      - DB is running
      - Informatica service is running

      I have chosen the HR Payroll as part of my POC and am trying to run a Full Load for it, while doing so I got this error. Could anyone please tell me what could have gone wrong here?

      Thanks,
      Jay

      ********************************************************************************************************

      2013-03-14 19:43:58.206 INFORMATICA TASK:SDE_ORAR1212_Adaptor:SDE_ORA_Flx_ListTmpLoad:(Source : FULL Target : FULL) has started.



      ANOMALY INFO::: Error while executing : INFORMATICA TASK:SDE_ORAR1212_Adaptor:SDE_ORA_Flx_ListTmpLoad:(Source : FULL Target : FULL)
      MESSAGE:::
      Irrecoverable Error
      Error while contacting Informatica server for getting workflow status for SDE_ORA_Flx_ListTmpLoad
      Error Code = 36331:Unknown reason for error code 36331
      Pmcmd output :

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

      Informatica(r) PMCMD, version [9.0.1 HotFix2], build [242.1111], LINUX 64-bit
      Copyright (c) Informatica Corporation 1994 - 2010
      All Rights Reserved.

      Invoked at Thu Mar 14 19:44:19 2013

      Connected to Integration Service: [BI_IS].
      Integration Service status: [Running]
      Integration Service startup time: [Mon Mar 11 18:38:00 2013]
      Integration Service current time: [Thu Mar 14 19:44:20 2013]
      Folder: [SDE_ORAR1212_Adaptor]
      Workflow: [SDE_ORA_Flx_ListTmpLoad] version [1].
      Workflow run status: [Failed]
      Workflow run error code: [36331]
      Workflow run error message: [WARNING: Session task instance [SDE_ORA_Flx_ListTmpLoad] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_Flx_ListTmpLoad] will be failed.]
      Workflow run id [8].
      Start time: [Thu Mar 14 19:43:59 2013]
      End time: [Thu Mar 14 19:44:02 2013]
      Workflow log file: [u01/oracle/informatica/server/infa_shared/WorkflowLogs/SDE_ORA_Flx_ListTmpLoad.log]
      Workflow run type: [User request]
      Run workflow as user: [Administrator]
      Run workflow with Impersonated OSProfile in domain: []
      Integration Service: [BI_IS]
      Disconnecting from Integration Service

      Completed at Thu Mar 14 19:44:20 2013

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


      Re-Queue to attempt to run again or attach to running workflow
      if Execution Plan is still running or re-submit Execution Plan to execute the workflow.
      EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.IrrecoverableException

      com.siebel.analytics.etl.etltask.InformaticaTask.doExecute(InformaticaTask.java:179)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.doExecuteWithRetries(GenericTaskImpl.java:410)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:306)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.execute(GenericTaskImpl.java:213)
      com.siebel.analytics.etl.etltask.GenericTaskImpl.run(GenericTaskImpl.java:585)
      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)

      pmcmd startworkflow -sv BI_IS -d Domain_ssi.biw066.idc.oracle.com -u Administrator -p **** -f SDE_ORAR1212_Adaptor -lpf /u01/oracle/informatica/server/infa_shared/SrcFiles/FlatFileConnection.DataWarehouse.SDE_ORAR1212_Adaptor.SDE_ORA_Flx_ListTmpLoad.txt SDE_ORA_Flx_ListTmpLoad

      2013-03-14 19:44:20.443 INFORMATICA TASK:SDE_ORAR1212_Adaptor:SDE_ORA_Flx_ListTmpLoad:(Source : FULL Target : FULL) has finished execution with Failed status.

      **********************************************************************************************************************************************************