This discussion is archived
3 Replies Latest reply: Mar 14, 2013 3:43 AM by 635583 RSS

Informatica Workflow Error

Raghu Nagadasari Newbie
Currently Being Moderated
Hi All,

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/

Thanks in advance.

Raghu Nagadasari
  • 1. Re: Informatica Workflow Error
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Make sure you got the parameter file at Dac's folder or the below and see how it works
    /d02/informatica/server/infa_shared/SrcFiles//ORA_R1213.DataWarehouse.SDE_ORAR1213_Adaptor.SDE_ORA_ExchangeRateGeneral_Full.txt SDE_ORA_ExchangeRateGeneral_Full

    If helps mark
  • 2. Re: Informatica Workflow Error
    Raghu Nagadasari Newbie
    Currently Being Moderated
    Hi Srini,

    Thanks for ur detailed response here. 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

    ****************************************************************
    Please guide me.

    Regards,
    Raghu Nagadasari
  • 3. Re: Informatica Workflow Error
    635583 Newbie
    Currently Being Moderated
    As per your DAC log, you are trying to run wf-SDE_ORA_ExchangeRateGeneral_Full. But in informatica, you are referring wf-SDE_ORA_ExchangeRateGeneral. Am I right? If yes, try to post correct wf log.

Legend

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