5 Replies Latest reply: Apr 30, 2012 9:54 PM by Ahsan Shah RSS

    VAR_27026 Error:Missing intial Value for Session Parameter

    user10330106
      Hi all,

      We are using OBIA 7.9.6.3 to enable standard dashboards for HRMS,Procurement and Finance.

      When we try to run the finance execution plan thru DAC,the tasks SDE_ORA_STAGE_ARRevenueFact_DiffManDerive and

      SDE_ORA_STAGE_GLRevenueFact_DiffManDerive.

      This the error message is *VAR_27026 Error:Missing intial Value for Session Parameter [DBCONNECTION_OLTP]*

      For above two mappings there's no session log files also generated.

      Thnx
      Rama
        • 1. Re: VAR_27026 Error:Missing intial Value for Session Parameter
          KBabu
          Hi

          Please Check if Session Name Mentioned in Param File is Matching with the Original name in Workflow. If not match then variable assigment will not happen. Compare both names and modify the difference, it will work

          Please mark as Correct or Helpful if it clears

          Thanks
          • 2. Re: VAR_27026 Error:Missing intial Value for Session Parameter
            Benoît
            Hi Rama,

            Before to run the finance execution plan thru DAC, have you updated the Execution Plan Parameters ?
            To update the Execution Plan Parameters:
            1- Select menu Execute
            2 - Select Tab Execution Plans
            3 - Select Sub-Tab Parameters
            4 - Click on button Generate and updated the Datasource Parameter with the name of datasource you have written in the SETUP/Physical Datasource

            Hope it helps,

            Benoît
            • 3. Re: VAR_27026 Error:Missing intial Value for Session Parameter
              933450
              Hi,

              All other mappings are working fine.Execpt this two mapping shows the below error


              INFO : LM_36435 [Thu Apr 26 16:31:47 2012] : (4412|10512) Starting execution of workflow [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] in folder [SDE_ORAR1213_Adaptor] last saved by user [Administrator].
              INFO : LM_44206 [Thu Apr 26 16:31:47 2012] : (4412|10512) Workflow SDE_ORA_Stage_ARTransactionFact_DiffManDerive started with run id [4439], run instance name [], run type [Concurrent Run Disabled].
              INFO : LM_44195 [Thu Apr 26 16:31:47 2012] : (4412|10512) Workflow [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] service level [SLPriority:5,SLDispatchWaitTime:1800].
              INFO : VAR_27085 [Thu Apr 26 16:31:47 2012] : (4412|10512) Parameter file [D:\orahome\10gR3_2\bifoundation\dac\Informatica\parameters\\DataWarehouse.DataWarehouse.SDE_ORAR1213_Adaptor.SDE_ORA_Stage_ARTransactionFact_DiffManDerive.txt] is opened for [workflow [SDE_ORA_Stage_ARTransactionFact_DiffManDerive]].
              INFO : LM_44253 : (4412|10512) Workflow started. Clients will be notified
              INFO : LM_36330 [Thu Apr 26 16:31:47 2012] : (4412|10512) Start task instance [Start]: Execution started.
              INFO : LM_36318 [Thu Apr 26 16:31:47 2012] : (4412|10512) Start task instance [Start]: Execution succeeded.
              INFO : LM_36505 : (4412|10512) Link [Start --> SDE_ORA_Stage_ARTransactionFact_DiffManDerive]: empty expression string, evaluated to TRUE.
              INFO : LM_36388 [Thu Apr 26 16:31:47 2012] : (4412|10512) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] is waiting to be started.
              INFO : LM_36682 [Thu Apr 26 16:31:47 2012] : (4412|10872) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive]: started a process with pid [11208] on node [node01_AEADTWTDWVSA02].
              INFO : LM_36330 [Thu Apr 26 16:31:47 2012] : (4412|10872) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive]: Execution started.
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6793 Fetching initialization properties from the Integration Service. : (Thu Apr 26 16:31:47 2012)]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [DISP_20305 The [Preparer] DTM with process id [11208] is running on node [node01_AEADTWTDWVSA02].
              : (Thu Apr 26 16:31:47 2012)]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [PETL_24036 Beginning the prepare phase for the session.]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6721 Started [Connect to Repository].]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6722 Finished [Connect to Repository]. It took [0.639579] seconds.]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6794 Connected to repository [CRP_REP] in domain [Domain_AEADTWTDWVSA02] as user [Administrator] in security domain [Native].]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6721 Started [Fetch Session from Repository].]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6722 Finished [Fetch Session from Repository]. It took [0.187194] seconds.]
              INFO : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].]
              ERROR : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [CMN_1761 Timestamp Event: [Thu Apr 26 16:31:48 2012]]
              ERROR : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [VAR_27026 Error: Missing initial value for session parameter:[$DBConnection_OLTP].]
              ERROR : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [CMN_1761 Timestamp Event: [Thu Apr 26 16:31:48 2012]]
              ERROR : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6270 Error: Variable parameter expansion error.]
              ERROR : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [CMN_1761 Timestamp Event: [Thu Apr 26 16:31:48 2012]]
              ERROR : LM_36488 [Thu Apr 26 16:31:48 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] : [TM_6163 An error occurred initializing variables and parameters for the partition.]
              ERROR : LM_36320 [Thu Apr 26 16:31:50 2012] : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive]: Execution failed.
              WARNING : LM_36331 : (4412|10552) Session task instance [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_Stage_ARTransactionFact_DiffManDerive] will be failed.
              ERROR : LM_36320 [Thu Apr 26 16:31:50 2012] : (4412|10552) Workflow [SDE_ORA_Stage_ARTransactionFact_DiffManDerive]: Execution failed.

              Regards,
              Rama
              • 4. Re: VAR_27026 Error:Missing intial Value for Session Parameter
                KBabu
                Hi

                There should be some typo in the Parameter file. Please check the following:
                1)The Folder name should be exactly the same where this workflow/Session is
                lying.
                2)Check the authenticity of the Value that you are passing for the Parameter
                in the Parameter file.
                3)The most important, please check the trailing spaces of the Value,
                Foldername,Workflow/Session name. Most of the times, because of these
                spaces, you will get this error.

                Please mark helpful if its clear
                • 5. Re: VAR_27026 Error:Missing intial Value for Session Parameter
                  Ahsan Shah
                  Check to make sure this specific Mapping/Session/Workflow has the right relational connection defined in informatica (e.g. $$DBConnection_OLTP, etc).