3 Replies Latest reply: Mar 14, 2013 5:43 AM by 635583 RSS

    Informatica Workflow Error

    Raghu Nagadasari
      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
          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
            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
              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.