This discussion is archived
5 Replies Latest reply: Aug 26, 2013 2:56 AM by 1007772 RSS

Unknown reason for error code 36331 in DAC run

Sudha777 Explorer
Currently Being Moderated
Hi,

While running full load i am getting following error

Can any one give me the solution

ANOMALY INFO::: Error while executing : INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_GLJournals_Full:1:(Source : FULL Target : FULL)
MESSAGE:::
Irrecoverable Error
pmcmd startworkflow -sv INFOIS -d Domain_oracle.ebiz.com -u Administrator -p **** -f SDE_ORAR1213_Adaptor -paramfile /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters/SDE_ORAR1213_Adaptor.SDE_ORA_GLJournals_Full.ORA_R1213.txt SDE_ORA_GLJournals_Full
Status Desc : Failed
WorkFlowMessage :
Error Message : Unknown reason for error code 36331
ErrorCode : 36331
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)

pmcmd startworkflow -sv INFOIS -d Domain_123 -u Administrator -p **** -f SDE_ORAR1213_Adaptor -paramfile /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters/SDE_ORAR1213_Adaptor.SDE_ORA_GLJournals_Full.ORA_R1213.txt SDE_ORA_GLJournals_Full

2013-02-07 01:41:19.126 INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_GLJournals_Full:1:(Source : FULL Target : FULL) has finished execution with Failed status.
  • 1. Re: Unknown reason for error code 36331 in DAC run
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Did you copy the Out of the Box (OOB) source files from bi apps's dwrep folder to Informatica's SrcFolder?
    Make sure you have all source files available for load.

    Let me/us know updates
  • 2. Re: Unknown reason for error code 36331 in DAC run
    Sudha777 Explorer
    Currently Being Moderated
    HI Srini,

    I had copied Src files from BIApps to informatica Src file

    While running DAC11g full load, we are en counting some issues below is the error we are facing

    ERROR CODE - Unknown reason for error code 36331


    one more thing to consider, In DAC10g we give /Oracle/OBIAPPS/Informatica/9.1.0/server/infa_shared/SrcFiles as Informatica parameter path in DAC system properties but in DAC11g if i take same path no task is running, it is failing at first task only and no parameter file is generating.

    But if i give dafault in that Informatica parameter path of DAC11g some tasks are running success and i am able to see some parameters generated in DAC PATH, but Default is taking
    /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters path for that location.

    Informatica Server details are Success, Physical Data sorce are success.
    I had copied SrcFiles and LkpFiles to informatica from BIApps.
    ParameterDW and parameterOLTP are moved to /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters as well as Informatica Src folder

    for one task below is the error

    2013-02-07 21:50:17.515 Acquiring Resources

    2013-02-07 21:50:17.517 Acquired Resources


    2013-02-07 21:50:17.519 INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_GLJournals_Full:1:(Source : FULL Target : FULL) has started.



    ANOMALY INFO::: Error while executing : INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_GLJournals_Full:1:(Source : FULL Target : FULL)
    MESSAGE:::
    Irrecoverable Error
    pmcmd startworkflow -sv INFOIS -d Domain_oracle.ebiz.com -u Administrator -p **** -f SDE_ORAR1213_Adaptor -paramfile /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters/SDE_ORAR1213_Adaptor.SDE_ORA_GLJournals_Full.ORA_R1213.txt SDE_ORA_GLJournals_Full
    Status Desc : Failed
    WorkFlowMessage :
    Error Message : Unknown reason for error code 36331
    ErrorCode : 36331
    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)

    pmcmd startworkflow -sv INFOIS -d Domain_oracle.ebiz.com -u Administrator -p **** -f SDE_ORAR1213_Adaptor -paramfile /Oracle/OBIAPPS/DAC/orahome/11g/dac/Informatica/parameters/SDE_ORAR1213_Adaptor.SDE_ORA_GLJournals_Full.ORA_R1213.txt SDE_ORA_GLJournals_Full

    2013-02-07 21:50:46.989 INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_GLJournals_Full:1:(Source : FULL Target : FULL) has finished execution with Failed status.
  • 3. Re: Unknown reason for error code 36331 in DAC run
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Can you send me the session log to my email?

    sveerava@gmail.com

    Edited by: Srini VEERAVALLI on Feb 7, 2013 11:41 PM
  • 4. Re: Unknown reason for error code 36331 in DAC run
    Sudha777 Explorer
    Currently Being Moderated
    ur email id plz

    session log is not able to generate

    This is workflow log

    LM_36488     Session task instance [SDE_ORA_GLJournals] : [CMN_1761 Timestamp Event: [Thu Feb 07 22:18:01 2013]]

    LM_36488     Session task instance [SDE_ORA_GLJournals] : [VAR_27026 Error: Missing initial value for session parameter:[$DBConnection_OLAP].]

    LM_36488     Session task instance [SDE_ORA_GLJournals] : [CMN_1761 Timestamp Event: [Thu Feb 07 22:18:01 2013]]

    LM_36488     Session task instance [SDE_ORA_GLJournals] : [TM_6270 Error: Variable parameter expansion error.]

    LM_36488     Session task instance [SDE_ORA_GLJournals] : [TM_6163 An error occurred initializing variables and parameters for the partition.]

    LM_36331     Session task instance [SDE_ORA_GLJournals] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_GLJournals] will be failed.
  • 5. Re: Unknown reason for error code 36331 in DAC run
    1007772 Newbie
    Currently Being Moderated

    hello,

    i'm facing the same situation , did you find a solution to your problem?

Legend

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