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
  • 15. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    You need not to set anything in the informatica for flat file location.

    I would ask you to carry out following in steps.

    1)Ensure that you have copied paramter file and also setup is done properly btwn Informatica and DAC.

    2)Apply the DAC cummulative patch first(if already applied then it is fine).

    3)Create one new execution plan for HR

    4)Generate the parameters freshly by clicking on the generate button in the bottom pane.

    5)Build the execution plan.

    6)Try running the EP now.Keep your workflow monitor open.

    Let me know your results once you do all these steps.

    Regards,
    Veeresh Rayan
  • 16. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Veeresh,

    We already tried with different new Execution PLan. And all the parameter files also fine between Informatica and DAC.
    But, still we are getting the same error while running the EP in DAC.

    And i m not sure about the DAC cummulative patch, bcoz, another resources are already loded the Finance data in my
    mechine. But, unfortunately, nobody is in contact with us currently... :-)

    Regarding, Informatica Flat File LOcation in DAC, i m not sure, it is not effecting anything in data loading.

    Plzz let us know if there are any other ideas on this.!!

    Regards,

    Raghu Nagadasari
  • 17. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Try applying the cummulative patch..

    It is just copying and pasting one file and bouncing the server..You will have lot of other problems like this if you dont apply the patch.

    Regards,
    Veeresh Rayan
  • 18. Re: ExecutionPlan Error while loading HRMS data through DAC
    Ahsan Shah Expert
    Currently Being Moderated
    Error seems pretty self explanatory to me:

    Var_27026 Error: Missing inital value for session parameters:[$DBConnection_OLAP] .


    Why are you not trying to fix the main issue...this is a definition that is not defined correctly
  • 19. Re: ExecutionPlan Error while loading HRMS data through DAC
    635583 Newbie
    Currently Being Moderated
    Hi, can you confirm the following

    Is - "Var_27026 Error: Missing inital value for session parameters:[$DBConnection_OLAP]" only for all your failures?

    Open the parameter file of the failed task and and verify the presents of this parameter.

    Is failed tasks always have two sessions in the workflow? If yes, then parameter file should also have two sections, one for each session.

    Try run the informatica task manually by setting the parameter file path explicitly.
  • 20. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Can you confirm this?..

    If you have done these things?..
    4.6.6.4 Setting PowerCenter Integration Services Custom Properties

    Ensure this variable is set in integration service

    overrideMpltVarWithMapVar set to Yes

    Sometime mapping variable gets overridden by DAC parameters unless you set this variable..

    Regards,
    Veeresh Rayaan
  • 21. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Veeresh,

    Here, my previous team already loaded data for Finance Module perfectly. But Now, they are not available. So, my assumption is Cumulative patch only, not causing to this error, but i m not sure. Or give me the link to get that patch.
  • 22. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Ahsan,

    Actually, i m a OBI Consultant and new to Informatica. So, please let me know where i need to correct this mistake.

    For better understanding please go through the below link.

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

    And the SrcFile also available below. But, my doubt here is how to findout the exact error through this file.

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

    [SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full]
    $$ANALYSIS_END=01/01/2011 12:59:00
    $$ANALYSIS_END_WID=20110101
    $$ANALYSIS_START=12/31/1979 01:00:00
    $$ANALYSIS_START_WID=19791231
    $$COST_TIME_GRAIN=QUARTER
    $$CURRENT_DATE=03/07/2013
    $$CURRENT_DATE_IN_SQL_FORMAT=TO_DATE('2013-03-07', 'YYYY-MM-DD')
    $$CURRENT_DATE_TIME_IN_SQL_FORMAT=TO_DATE('2013-03-07 01:24:13', 'YYYY-MM-DD HH24:MI:SS')
    $$CURRENT_DATE_WID=20130307
    $$CURRENT_ETL_START_TS=TO_DATE('2013-03-07 01:13:42', 'YYYY-MM-DD HH24:MI:SS')
    $$DATASOURCE_NUM_ID=1000
    $$DEFAULT_LOC_RATE_TYPE=Corporate
    $$DFLT_LANG=US
    $$ETL_PROC_WID=22709984
    $$FILTER_BY_LEDGER_ID='N'
    $$FILTER_BY_LEDGER_TYPE='N'
    $$GBL_CALENDAR_ID=Accounting~Month
    $$GBL_DATASOURCE_NUM_ID=9
    $$GLOBAL1_CURR_CODE=USD
    $$GLOBAL1_RATE_TYPE=Corporate
    $$GLOBAL2_CURR_CODE=USD
    $$GLOBAL2_RATE_TYPE=Corporate
    $$GLOBAL3_CURR_CODE=USD
    $$GLOBAL3_RATE_TYPE=Corporate
    $$HI_DATE=TO_DATE('3714-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HI_DT=01/01/3714 12:00:00
    $$HR_ABSNC_EXTRACT_DATE=1980-01-01
    $$HR_WRKFC_ADJ_SERVICE_DATE='N'
    $$HR_WRKFC_EXTRACT_DATE=TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HR_WRKFC_SNAPSHOT_DT=TO_DATE('2004-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HR_WRKFC_SNAPSHOT_TO_WID=20130307
    $$Hint_Tera_Post_Cast=
    $$Hint_Tera_Pre_Cast=
    $$INITIAL_EXTRACT_DATE=01/01/2007
    $$INVPROD_CAT_SET_ID=27
    $$INV_PROD_CAT_SET_ID10=
    $$INV_PROD_CAT_SET_ID1=27
    $$INV_PROD_CAT_SET_ID2=
    $$INV_PROD_CAT_SET_ID3=
    $$INV_PROD_CAT_SET_ID4=
    $$INV_PROD_CAT_SET_ID5=
    $$INV_PROD_CAT_SET_ID6=
    $$INV_PROD_CAT_SET_ID7=
    $$INV_PROD_CAT_SET_ID8=
    $$INV_PROD_CAT_SET_ID9=
    $$LANGUAGE_CODE=E
    $$LAST_EXTRACT_DATE=03/30/2003
    $$LAST_EXTRACT_DATE_IN_SQL_FORMAT=
    $$LAST_EXTRACT_DATE_WID=
    $$LAST_TARGET_EXTRACT_DATE_IN_SQL_FORMAT=
    $$LEDGER_ID_LIST=1
    $$LEDGER_TYPE_LIST='NONE'
    $$LOAD_DT=TO_DATE('2013-03-07 01:13:43', 'YYYY-MM-DD HH24:MI:SS')
    $$LOW_DATE=TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$LOW_DT=01/01/1899 00:00:00
    $$MASTER_CODE_NOT_FOUND=
    $$ORA_HI_DATE=TO_DATE('4712-12-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$PROD_CAT_SET_ID10=
    $$PROD_CAT_SET_ID1=2
    $$PROD_CAT_SET_ID2=
    $$PROD_CAT_SET_ID3=
    $$PROD_CAT_SET_ID4=
    $$PROD_CAT_SET_ID5=
    $$PROD_CAT_SET_ID6=
    $$PROD_CAT_SET_ID7=
    $$PROD_CAT_SET_ID8=
    $$PROD_CAT_SET_ID9=
    $$PROD_CAT_SET_ID=2
    $$SOURCE_CODE_NOT_SUPPLIED=
    $$TENANT_ID=DEFAULT
    $$WH_DATASOURCE_NUM_ID=999
    $$XRATE_UPD_NUM_DAY=30
    $DBConnection_OLAP=DataWarehouse
    $DBConnection_OLTP=ORA_R1213
    $PMSessionLogFile=ORA_R1213.DATAWAREHOUSE.SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.log
    mplt_BC_ORA_RateGeneral.$$INITIAL_EXTRACT_DATE=01/01/2007
    mplt_BC_ORA_RateGeneral.$$LAST_EXTRACT_DATE=03/30/2003

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

    Thanks in advance.

    Raghu Nagadasari
  • 23. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Check this note and download DAC patch.

    What is the latest Cumulative Patch for DAC 10.1.3.4.1? [ID 1365152.1].

    What you mean data is not available ?..How are you running ETL?.

    Is FULL LOAD ALWAYS option is checked for both FIN and HR Execution plan?..

    Regards,
    Veeresh Rayan
  • 24. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Veeresh,

    I m checking now for Cumulative Patch and let u know once i done with taht patch.

    I said the resources, who worked for Finance are not avalable now, not data..

    We are running Informatica WFs through DAC only. SOmetimes, for the failed task we are doing this manually in Informatica, but getting fails. Even the WFs, which are passed from DAC also, giving failed status if we run them in Informatica lavel. But, no issue with them, becoz, they are already passed and giving data for staging tables.

    We tried with and without FULL LOAD ALWAYS option for HR data ExecutionPlans and for Finance they didn't use this option.

    Thanks for ur responce again..

    Raghu Nagadasari
  • 25. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Veeresh,

    Please go through the below conversion for better understanding..

    We are working on OBIApps 7963 and we are completely new to Informatica. While running the Execution Plans through DAC we are getting the errors. And in Infor matica level also we are getting the below error:

    Restart Workflow: ERROR: Workflow [SDE_ORA_ExchangeRateGeneral]: Execution failed. Please check the workflow log for more information.

    Here , i m unable to post the errors exactly, so please go through the below link, so that you can understand my problem easily. Bcz, even i don't know how to explain my problem in Informatica level, as a new person to Infomatica..:-)

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

    And the SrcFile also available below. But, my doubt here is how to findout the exact error through the file.

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

    [SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full]
    $$ANALYSIS_END=01/01/2011 12:59:00
    $$ANALYSIS_END_WID=20110101
    $$ANALYSIS_START=12/31/1979 01:00:00
    $$ANALYSIS_START_WID=19791231
    $$COST_TIME_GRAIN=QUARTER
    $$CURRENT_DATE=03/07/2013
    $$CURRENT_DATE_IN_SQL_FORMAT=TO_DATE('2013-03-07', 'YYYY-MM-DD')
    $$CURRENT_DATE_TIME_IN_SQL_FORMAT=TO_DATE('2013-03-07 01:24:13', 'YYYY-MM-DD HH24:MI:SS')
    $$CURRENT_DATE_WID=20130307
    $$CURRENT_ETL_START_TS=TO_DATE('2013-03-07 01:13:42', 'YYYY-MM-DD HH24:MI:SS')
    $$DATASOURCE_NUM_ID=1000
    $$DEFAULT_LOC_RATE_TYPE=Corporate
    $$DFLT_LANG=US
    $$ETL_PROC_WID=22709984
    $$FILTER_BY_LEDGER_ID='N'
    $$FILTER_BY_LEDGER_TYPE='N'
    $$GBL_CALENDAR_ID=Accounting~Month
    $$GBL_DATASOURCE_NUM_ID=9
    $$GLOBAL1_CURR_CODE=USD
    $$GLOBAL1_RATE_TYPE=Corporate
    $$GLOBAL2_CURR_CODE=USD
    $$GLOBAL2_RATE_TYPE=Corporate
    $$GLOBAL3_CURR_CODE=USD
    $$GLOBAL3_RATE_TYPE=Corporate
    $$HI_DATE=TO_DATE('3714-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HI_DT=01/01/3714 12:00:00
    $$HR_ABSNC_EXTRACT_DATE=1980-01-01
    $$HR_WRKFC_ADJ_SERVICE_DATE='N'
    $$HR_WRKFC_EXTRACT_DATE=TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HR_WRKFC_SNAPSHOT_DT=TO_DATE('2004-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$HR_WRKFC_SNAPSHOT_TO_WID=20130307
    $$Hint_Tera_Post_Cast=
    $$Hint_Tera_Pre_Cast=
    $$INITIAL_EXTRACT_DATE=01/01/2007
    $$INVPROD_CAT_SET_ID=27
    $$INV_PROD_CAT_SET_ID10=
    $$INV_PROD_CAT_SET_ID1=27
    $$INV_PROD_CAT_SET_ID2=
    $$INV_PROD_CAT_SET_ID3=
    $$INV_PROD_CAT_SET_ID4=
    $$INV_PROD_CAT_SET_ID5=
    $$INV_PROD_CAT_SET_ID6=
    $$INV_PROD_CAT_SET_ID7=
    $$INV_PROD_CAT_SET_ID8=
    $$INV_PROD_CAT_SET_ID9=
    $$LANGUAGE_CODE=E
    $$LAST_EXTRACT_DATE=03/30/2003
    $$LAST_EXTRACT_DATE_IN_SQL_FORMAT=
    $$LAST_EXTRACT_DATE_WID=
    $$LAST_TARGET_EXTRACT_DATE_IN_SQL_FORMAT=
    $$LEDGER_ID_LIST=1
    $$LEDGER_TYPE_LIST='NONE'
    $$LOAD_DT=TO_DATE('2013-03-07 01:13:43', 'YYYY-MM-DD HH24:MI:SS')
    $$LOW_DATE=TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$LOW_DT=01/01/1899 00:00:00
    $$MASTER_CODE_NOT_FOUND=
    $$ORA_HI_DATE=TO_DATE('4712-12-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    $$PROD_CAT_SET_ID10=
    $$PROD_CAT_SET_ID1=2
    $$PROD_CAT_SET_ID2=
    $$PROD_CAT_SET_ID3=
    $$PROD_CAT_SET_ID4=
    $$PROD_CAT_SET_ID5=
    $$PROD_CAT_SET_ID6=
    $$PROD_CAT_SET_ID7=
    $$PROD_CAT_SET_ID8=
    $$PROD_CAT_SET_ID9=
    $$PROD_CAT_SET_ID=2
    $$SOURCE_CODE_NOT_SUPPLIED=
    $$TENANT_ID=DEFAULT
    $$WH_DATASOURCE_NUM_ID=999
    $$XRATE_UPD_NUM_DAY=30
    $DBConnection_OLAP=DataWarehouse
    $DBConnection_OLTP=ORA_R1213
    $PMSessionLogFile=ORA_R1213.DATAWAREHOUSE.SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.log
    mplt_BC_ORA_RateGeneral.$$INITIAL_EXTRACT_DATE=01/01/2007
    mplt_BC_ORA_RateGeneral.$$LAST_EXTRACT_DATE=03/30/2003

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

    Raghu Nagadasari
  • 26. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Do not use FULL LOAD option..Let it be unchecked..

    Let me take a look on the scrrenshot and see If I can help you.

    Regards,
    Veeresh Rayan
  • 27. Re: ExecutionPlan Error while loading HRMS data through DAC
    Veeresh Rayan Journeyer
    Currently Being Moderated
    Hi I checked the ERROR screen in the WF log.

    It says it couldn't locate parameter file in this location.

    /d02/Informatica/Server/Infa_shared/SrcFiles/SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral.txt

    Can you confirm if you have this file in this location in the server side..I mean where the inforamatica server is installed.

    .

    Another check is I want you to paste the log of WF for any other task. Check the WF log file where extream left shows ERROR in the log and highlight that and paste the error by clicking on copy.


    Regards,
    Veeresh Rayan
  • 28. Re: ExecutionPlan Error while loading HRMS data through DAC
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Veeresh,

    Thanks for ur response. We have the Parameter file in the correct location and its in below.

    /d02/Informatica/Server/Infa_shared/SrcFiles/SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral.txt

    This is my failed WF log.

    *********************************
    INFO : LM_36435 [Tue Mar 12 23:04:41 2013] : (9768|-1609614448) Starting execution of workflow [SDE_ORA_ExchangeRateGeneral] in folder [SDE_ORAR1213_Adaptor] last saved by user [Administrator].
    INFO : LM_44206 [Tue Mar 12 23:04:41 2013] : (9768|-1609614448) Workflow SDE_ORA_ExchangeRateGeneral started with run id [11349], run instance name [], run type [Concurrent Run Disabled].
    INFO : LM_44195 [Tue Mar 12 23:04:41 2013] : (9768|-1609614448) Workflow [SDE_ORA_ExchangeRateGeneral] service level [SLPriority:5,SLDispatchWaitTime:1800].
    INFO : LM_44253 : (9768|-1609614448) Workflow started. Clients will be notified
    INFO : LM_36330 [Tue Mar 12 23:04:41 2013] : (9768|-1609614448) Start task instance [Start]: Execution started.
    INFO : LM_36318 [Tue Mar 12 23:04:41 2013] : (9768|-1609614448) Start task instance [Start]: Execution succeeded.
    INFO : LM_36505 : (9768|-1609614448) Link [Start --> SDE_ORA_ExchangeRateGeneral_CleanUp]: empty expression string, evaluated to TRUE.
    INFO : LM_36388 [Tue Mar 12 23:04:41 2013] : (9768|-1609614448) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] is waiting to be started.
    INFO : LM_36682 [Tue Mar 12 23:04:41 2013] : (9768|-1578144880) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp]: started a process with pid [9430] on node [node01_eld17.eistech.com].
    INFO : LM_36330 [Tue Mar 12 23:04:41 2013] : (9768|-1578144880) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp]: Execution started.
    ERROR : VAR_27086 : (9768|-1588634736) Cannot find specified parameter file [d02/informatica/server/infa_shared/SrcFiles/SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral.txt] for [session [SDE_ORA_ExchangeRateGeneral.SDE_ORA_ExchangeRateGeneral_CleanUp]].
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [TM_6793 Fetching initialization properties from the Integration Service. : (Tue Mar 12 23:04:41 2013)]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [DISP_20305 The [Preparer] DTM with process id [9430] is running on node [node01_eld17.eistech.com].
    : (Tue Mar 12 23:04:41 2013)]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [PETL_24036 Beginning the prepare phase for the session.]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [TM_6721 Started [Connect to Repository].]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [TM_6722 Finished [Connect to Repository]. It took [0.394758] seconds.]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [TM_6794 Connected to repository [EISBI_RS] in domain [Domain_eld17.eistech.com] as user [Administrator] in security domain [Native].]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [TM_6721 Started [Fetch Session from Repository].]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [TM_6722 Finished [Fetch Session from Repository]. It took [0.0545111] seconds.]
    INFO : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [TM_6793 Fetching initialization properties from the Integration Service. : (Tue Mar 12 23:04:42 2013)]
    ERROR : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [CMN_1761 Timestamp Event: [Tue Mar 12 23:04:42 2013]]
    ERROR : LM_36488 [Tue Mar 12 23:04:42 2013] : (9768|-1630594160) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] : [PETL_24049 Failed to get the initialization properties from the master service process for the prepare phase [Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp]: Unable to read variable definition from parameter file [d02/informatica/server/infa_shared/SrcFiles/SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral.txt].] with error code [168257360].]
    ERROR : LM_36320 [Tue Mar 12 23:04:42 2013] : (9768|-1609614448) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp]: Execution failed.
    WARNING : LM_36331 : (9768|-1609614448) Session task instance [SDE_ORA_ExchangeRateGeneral_CleanUp] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_ExchangeRateGeneral] will be failed.
    INFO : LM_36507 : (9768|-1609614448) Link [SDE_ORA_ExchangeRateGeneral_CleanUp --> SDE_ORA_ExchangeRateGeneral_Compress]: condition is FALSE for the expression [$SDE_ORA_ExchangeRateGeneral_CleanUp.PrevTaskStatus = SUCCEEDED OR $SDE_ORA_ExchangeRateGeneral_CleanUp.PrevTaskStatus = DISABLED].
    ERROR : LM_36320 [Tue Mar 12 23:04:42 2013] : (9768|-1609614448) Workflow [SDE_ORA_ExchangeRateGeneral]: Execution failed.

    ***********************************
    The below WF log is successful one.

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

    INFO : LM_36435 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Starting execution of workflow [SIL_GeographyDimension] in folder [SILOS] last saved by user [Administrator].
    INFO : LM_44206 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Workflow SIL_GeographyDimension started with run id [2302], run instance name [], run type [Concurrent Run Disabled].
    INFO : LM_44195 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Workflow [SIL_GeographyDimension] service level [SLPriority:5,SLDispatchWaitTime:1800].
    INFO : VAR_27085 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Parameter file [d02/informatica/server/infa_shared/Temp/SIL_GeographyDimension_B0nFjp] is opened for [workflow [SIL_GeographyDimension]].
    INFO : LM_44253 : (4055|-1609630832) Workflow started. Clients will be notified
    INFO : LM_36330 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Start task instance [Start]: Execution started.
    INFO : LM_36318 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Start task instance [Start]: Execution succeeded.
    INFO : LM_36505 : (4055|-1609630832) Link [Start --> SIL_GeographyDimension]: empty expression string, evaluated to TRUE.
    INFO : LM_36388 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Session task instance [SIL_GeographyDimension] is waiting to be started.
    INFO : LM_36682 [Fri Jun 29 08:23:17 2012] : (4055|-1578161264) Session task instance [SIL_GeographyDimension]: started a process with pid [2740] on node [node01_eld17.eistech.com].
    INFO : LM_36330 [Fri Jun 29 08:23:17 2012] : (4055|-1578161264) Session task instance [SIL_GeographyDimension]: Execution started.
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6793 Fetching initialization properties from the Integration Service. : (Fri Jun 29 08:23:17 2012)]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [DISP_20305 The [Preparer] DTM with process id [2740] is running on node [node01_eld17.eistech.com].
    : (Fri Jun 29 08:23:17 2012)]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [PETL_24036 Beginning the prepare phase for the session.]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6721 Started [Connect to Repository].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6722 Finished [Connect to Repository]. It took [0.299487] seconds.]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6794 Connected to repository [EISBI_RS] in domain [Domain_eld17.eistech.com] as user [Administrator] in security domain [Native].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6721 Started [Fetch Session from Repository].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6722 Finished [Fetch Session from Repository]. It took [0.743216] seconds.]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [0] for user-defined workflow/worklet variable:[$$passInStatus].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [DATAWAREHOUSE.DATAWAREHOUSE.SILOS.SIL_GeographyDimension.log] for session parameter:[$PMSessionLogFile].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [999] for mapping parameter:[MPLT_CODES_GeographyDimension.$$DATASOURCE_NUM_ID].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [22348929] for mapping parameter:[MPLT_GET_ETL_PROC_WID.$$ETL_PROC_WID].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [] for mapping parameter:[$$Hint1].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [] for mapping parameter:[$$Hint2].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [E] for mapping parameter:[MPLT_CODES_GeographyDimension.$$LANGUAGE_CODE].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [] for mapping parameter:[MPLT_CODES_GeographyDimension.$$MASTER_CODE_NOT_FOUND].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [] for mapping parameter:[MPLT_CODES_GeographyDimension.$$SOURCE_CODE_NOT_SUPPLIED].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [W_GEO_DS] for mapping parameter:[$$STAGE_TABLE].]
    INFO : LM_36488 [Fri Jun 29 08:23:18 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [W_GEO_D] for mapping parameter:[$$TARGET_TABLE].]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [W_GEO_D] for mapping parameter:[mplt_SIL_GeographyDimension.$$TARGET_TABLE].]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [VAR_27028 Use override value [W_GEO_D] for mapping parameter:[mplt_SIL_GeographyDimension_CodeLookup.$$TARGET_TABLE].]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TT_11094 The Lookup transformation [mplt_CODES_GeographyDimension.LKP_CODES_COUNTRY] requires that a string or binary lookup port and an input port in any lookup condition have the same length. Since lookup port [SOURCE_CODE] had a length of [50] and input port [IN_SOURCE_CODE] had a length of [120], the larger length for both ports is used.]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TT_11094 The Lookup transformation [mplt_CODES_GeographyDimension.LKP_CODES_CITY] requires that a string or binary lookup port and an input port in any lookup condition have the same length. Since lookup port [SOURCE_CODE_1] had a length of [50] and input port [IN_SOURCE_CODE_1] had a length of [120], the larger length for both ports is used.]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TT_11094 The Lookup transformation [mplt_CODES_GeographyDimension.LKP_CODES_CITY] requires that a string or binary lookup port and an input port in any lookup condition have the same length. Since lookup port [SOURCE_CODE_2] had a length of [50] and input port [IN_SOURCE_CODE_2] had a length of [120], the larger length for both ports is used.]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TT_11094 The Lookup transformation [mplt_CODES_GeographyDimension.LKP_CODES_CITY] requires that a string or binary lookup port and an input port in any lookup condition have the same length. Since lookup port [SOURCE_NAME_1] had a length of [80] and input port [IN_SOURCE_NAME_1] had a length of [120], the larger length for both ports is used.]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6721 Started [Partition Group Formation].]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6722 Finished [Partition Group Formation]. It took [0.030993] seconds.]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [PETL_24037 Finished the prepare phase for the session.]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6792 Notifying the Integration Service that the prepare phase has been completed. : (Fri Jun 29 08:23:18 2012)]
    INFO : LM_36488 [Fri Jun 29 08:23:43 2012] : (4055|-1588651120) Session task instance [SIL_GeographyDimension] : [TM_6228 Writing session output to log file [/d02/informatica/server/infa_shared/SessLogs/DATAWAREHOUSE.DATAWAREHOUSE.SILOS.SIL_GeographyDimension.log].]
    INFO : LM_36318 [Fri Jun 29 08:24:12 2012] : (4055|-1630610544) Session task instance [SIL_GeographyDimension]: Execution succeeded.
    INFO : LM_36318 [Fri Jun 29 08:24:13 2012] : (4055|-1599140976) Workflow [SIL_GeographyDimension]: Execution succeeded.
    **************************************

    Ur effort is really helpful here.

    Thanks,

    Raghu Nagadasari
  • 29. Re: ExecutionPlan Error while loading HRMS data through DAC
    635583 Newbie
    Currently Being Moderated
    Note that succefully completed WF log does not give complete/correct path, as pasted below. This is expected behavior
    INFO : VAR_27085 [Fri Jun 29 08:23:17 2012] : (4055|-1609630832) Parameter file [d02/informatica/server/infa_shared/Temp/SIL_GeographyDimension_B0nFjp] is opened for [workflow [SIL_GeographyDimension]].

    However, the failed wf log not seems to have right information. May be you are posting a log of manual exution from Infa.
    ERROR : VAR_27086 : (9768|-1588634736) Cannot find specified parameter file [d02/informatica/server/infa_shared/SrcFiles/SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral.txt] for [session [SDE_ORA_ExchangeRateGeneral.SDE_ORA_ExchangeRateGeneral_CleanUp]].

    Can you also post the log from DAC
    DAC -> Run History -> Select EP -> Tasks -> Select a task -> Details -> Select a name -> Status Description

    As for as my understanding goes, DAC parameter file path and file name should look like as follows
    /d02/informatica/server/infa_shared/SrcFiles/*ORA_R1213.DataWarehouse.*SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral.txt

Legend

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