This discussion is archived
1 2 3 Previous Next 32 Replies Latest reply: Mar 14, 2013 3:09 AM by Veeresh Rayan Go to original post RSS
  • 30. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Prabhu,

    Please go through the below link.

    http://biproducts.wordpress.com/2013/03/12/informatica-workflow-error/

    And the Status Description is below.

    ————————————————————————-

    2013-03-12 02:13:45.519 INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_ExchangeRateGeneral_Full:(Source : FULL Target : FULL) has started.

    ANOMALY INFO::: Error while executing : INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_ExchangeRateGeneral_Full:(Source : FULL Target : FULL)
    MESSAGE:::
    Irrecoverable Error
    Error while contacting Informatica server for getting workflow status for SDE_ORA_ExchangeRateGeneral_Full
    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 32-bit
    Copyright (c) Informatica Corporation 1994 – 2010
    All Rights Reserved.

    Invoked at Tue Mar 12 02:14:06 2013

    Connected to Integration Service: [EISBI_IS].
    Integration Service status: [Running]
    Integration Service startup time: [Tue Jan 29 22:41:20 2013]
    Integration Service current time: [Tue Mar 12 02:14:06 2013]
    Folder: [SDE_ORAR1213_Adaptor]
    Workflow: [SDE_ORA_ExchangeRateGeneral_Full] version [5].
    Workflow run status: [Failed]
    Workflow run error code: [36331]
    Workflow run error message: [WARNING: Session task instance [SDE_ORA_ExchangeRateGeneral_Compress_Full] failed and its “fail parent if this task fails” setting is turned on. So, Workflow [SDE_ORA_ExchangeRateGeneral_Full] will be failed.]
    Workflow run id [11333].
    Start time: [Tue Mar 12 02:13:46 2013]
    End time: [Tue Mar 12 02:13:47 2013]
    Workflow log file: [d02/informatica/server/infa_shared/WorkflowLogs/SDE_ORA_ExchangeRateGeneral_Full.log]
    Workflow run type: [User request]
    Run workflow as user: [Administrator]
    Run workflow with Impersonated OSProfile in domain: []
    Integration Service: [EISBI_IS]
    Disconnecting from Integration Service

    Completed at Tue Mar 12 02:14:06 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 EISBI_IS -d Domain_eld17.eistech.com -u Administrator -p **** -f SDE_ORAR1213_Adaptor -lpf /d02/informatica/server/infa_shared/SrcFiles//ORA_R1213.DataWarehouse.SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.txt SDE_ORA_ExchangeRateGeneral_Full

    2013-03-12 02:14:07.21 INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_ExchangeRateGeneral_Full:(Source : FULL Target : FULL) has finished execution with Failed status.

    —————————————————
    And the Location of DAC:

    /d02/informatica/server/infa_shared/SrcFiles/

    Thanks in Advance.

    Raghu Nagadasari
  • 31. Re: ExecutionPlan Error while loading HRMS data through DAC
    635583 Newbie
    Currently Being Moderated
    I think your statements are contradicting.

    As per you DAC log, the failed task was - SDE_ORA_ExchangeRateGeneral_Full. However failed wf log you sent earlier was SDE_ORA_ExchangeRateGeneral.

    Actual command DAC executes to invoke informatica job is - 'pmcmd startworkflow -sv EISBI_IS -d Domain_eld17.eistech.com -u Administrator -p **** -f SDE_ORAR1213_Adaptor -lpf /d02/informatica/server/infa_shared/SrcFiles//ORA_R1213.DataWarehouse.SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.txt SDE_ORA_ExchangeRateGeneral_Full'

    Here parameter file is - /d02/informatica/server/infa_shared/SrcFiles//ORA_R1213.DataWarehouse.SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.txt

    Please verify the parameter file exists as per above statement and identify whether SDE_ORA_ExchangeRateGeneral_Full wf was stated atall. If yes, share the correct wf log.

    If it was not started, execute wf from command prompt using the above command and let us know what happens.

    Thanks,
    Prabu.V
  • 32. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    If the parameter file is in place then I dont think there should be a problem with parameter file.

    See I analysed your problem in the followinf ways.

    1)You are able to connect to DB,Informatica from DAC client --Answer is Yes

    2)You are able to locate the speciic parameter file -- Answer is Yes

    3)Have you applied cummulative DAC patch -- I haven't got ur answer yet?..

    I only see the problem is nothing to with individual tasks ..

    There is something else that is causing the issue.

    Once you apply patch let me know..

    Regards,
1 2 3 Previous Next

Legend

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