This discussion is archived
6 Replies Latest reply: Apr 14, 2013 8:28 PM by 1002672 RSS

New to BIAPPS- Getting Error while loading HR PAYROLL

Jay66online Newbie
Currently Being Moderated
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.

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

Legend

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