5 Replies Latest reply: Aug 26, 2013 4:56 AM by 1007772 RSS

    Unknown reason for error code 36331 in DAC run

    Sudha777
      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
          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
            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
              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
                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

                  hello,

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