6 Replies Latest reply: Nov 25, 2010 3:49 AM by 568202 RSS

    Task failed with unknow error

    568202
      Hi all,

      I made some changes in a mapping. I validated it and checked it in succesfully. When running the task in the dac, it gives me a unknow error. So i ran the workflow in the workflowmanager to see wich errors and warning he come up with. The mapping still fails. See the error log below.


      I have bold 5 lines wich i think are important.

      The first bold line is a little bit strange, cause a few rows below you see that he can find the parameters from the parameterfile

      Anyone have a clue why the task failed? Hope someone can help... tnx in advanced.


      -----
      Severity     Message
      INFO     Starting execution of workflow [SDE_ORA_ProjectCostLine] in folder [Custom_SDE] last saved by user [Edm].
      INFO     Workflow SDE_ORA_ProjectCostLine started with run id [135969], run instance name [], run type [Concurrent Run Disabled].
      INFO     Workflow [SDE_ORA_ProjectCostLine] service level [SLPriority:5,SLDispatchWaitTime:1800].
      INFO     Workflow started. Clients will be notified
      INFO     Start task instance [Start]: Execution started.
      INFO     Start task instance [Start]: Execution succeeded.
      INFO     Link [Start --> SDE_ORA_ProjectCostLine]: empty expression string, evaluated to TRUE.
      INFO     Session task instance [SDE_ORA_ProjectCostLine] is waiting to be started.
      INFO     Session task instance [SDE_ORA_ProjectCostLine]: started a process with pid [30721] on node [node_ontwikkel].
      INFO     Session task instance [SDE_ORA_ProjectCostLine]: Execution started.
      INFO     Parameter file [ora0/app/ipc860/server/infa_shared/SrcFiles/Custom_SDE.SDE_ORA_ProjectCostLine.txt] is opened for [session [SDE_ORA_ProjectCostLine.SDE_ORA_ProjectCostLine]].
      INFO     *Warning! Cannot find section for workflow [SDE_ORA_ProjectCostLine] and folder [Custom_SDE] in parameter file [ora0/app/ipc860/server/infa_shared/SrcFiles/Custom_SDE.SDE_ORA_ProjectCostLine.txt].*
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6793 Fetching initialization properties from the Integration Service. : (Wed Nov 17 11:49:58 2010)]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [DISP_20305 The [Preparer] DTM with process id [30721] is running on node [node_ontwikkel].
      : (Wed Nov 17 11:49:58 2010)]     
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [PETL_24036 Beginning the prepare phase for the session.]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6721 Started [Connect to Repository].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6722 Finished [Connect to Repository]. It took [0.214831] seconds.]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6794 Connected to repository [ontwikkel_repo] in domain [ontwikkel] as user [Administrator] in security domain [Native].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6721 Started [Fetch Session from Repository].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6722 Finished [Fetch Session from Repository]. It took [0.084069] seconds.]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6793 Fetching initialization properties from the Integration Service. : (Wed Nov 17 11:49:58 2010)]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [ORA_R12] for session parameter:[$DBConnection_OLTP].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [Custom_SDE.SDE_ORA_ProjectCostLine.log] for session parameter:[$PMSessionLogFile].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [9] for mapping parameter:[$$DATASOURCE_NUM_ID].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27027 Use default value [0] for mapping parameter:[mplt_BC_ORA_ProjectCostLine.$$EBS_REQUEST_ID_1].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [] for mapping parameter:[mplt_BC_ORA_ProjectCostLine.$$HINT1].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [01/01/1970] for mapping parameter:[mplt_BC_ORA_ProjectCostLine.$$INITIAL_EXTRACT_DATE].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [06/26/2010] for mapping parameter:[mplt_BC_ORA_ProjectCostLine.$$LAST_EXTRACT_DATE].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [VAR_27028 Use override value [DEFAULT] for mapping parameter:[$$TENANT_ID].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6721 Started [Partition Group Formation].]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6722 Finished [Partition Group Formation]. It took [0.01092] seconds.]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [PETL_24037 Finished the prepare phase for the session.]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6792 Notifying the Integration Service that the prepare phase has been completed. : (Wed Nov 17 11:49:58 2010)]
      INFO     Session task instance [SDE_ORA_ProjectCostLine] : [TM_6228 Writing session output to log file [/ora0/app/ipc860/server/infa_shared/SessLogs/Custom_SDE.SDE_ORA_ProjectCostLine.log].]
      *ERROR     Session task instance [SDE_ORA_ProjectCostLine]: Execution failed.*
      *WARNING     Session task instance [SDE_ORA_ProjectCostLine] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_ProjectCostLine] will be failed.*
      *WARNING     Workflow [SDE_ORA_ProjectCostLine]: Unable to unlink temporary parameter file [] with error [2] [No such file or directory]*
      *ERROR     Workflow [SDE_ORA_ProjectCostLine]: Execution failed.*
      -----
        • 1. Re: Task failed with unknow error
          568202
          anyone who can help?
          • 2. Re: Task failed with unknow error
            816162
            did you check your parameter file?
            You may need to change the name of the session it is looking for.
            • 3. Re: Task failed with unknow error
              816279
              Do you have errors in session log for this?

              I have seen this warning message for parameter file though it can find it. When it cannot really find file, it will show as error, not warning.
              • 4. Re: Task failed with unknow error
                coolmesh84
                It is erroring out because the parameter file that you supplied does not have the portion for workflow and probably folder. Check your parameter file.
                • 5. Re: Task failed with unknow error
                  568202
                  Tnx for helping all... you all think is must be something with the parameter file?? This was what i did...

                  The parameter file was copied from the parameter files the dac has generated. This was from the folder: /ora0/app/dac1013/bifoundation/dac/informatica/parameters

                  The original file name was: ORA_R12.DataWarehouse.Custom_SDE.SDE_ORA_ProjectCostLine.txt (<connection_source>.<Connection_taget>.<informaticafolder>.<workflowname>)

                  I changed it to Custom_SDE.SDE_ORA_ProjectCostLine.txt (<informaticafolder>.<workflowname> )and copied it to the folder /ora0/app/ipc861/server/infa_shared/SrcFiles

                  The file i'm using is posted below.

                  -----

                  [Custom_SDE.SDE_ORA_ProjectCostLine]
                  $$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=08/18/2010
                  $$CURRENT_DATE_IN_SQL_FORMAT=TO_DATE('2010-08-18', 'YYYY-MM-DD')
                  $$CURRENT_DATE_WID=20100818
                  $$DATASOURCE_NUM_ID=9
                  $$DEFAULT_LOC_RATE_TYPE=Corporate
                  $$DFLT_LANG=NL
                  $$EBS_REQUEST_ID_1=0
                  $$ETL_PROC_WID=21369196
                  $$FILTER_BY_LEDGER_ID='Y'
                  $$FILTER_BY_LEDGER_TYPE='N'
                  $$GBL_CALENDAR_ID=EMC_kalender~21
                  $$GBL_DATASOURCE_NUM_ID=9
                  $$GLOBAL1_CURR_CODE=EUR
                  $$GLOBAL1_RATE_TYPE=Corporate
                  $$GLOBAL2_CURR_CODE=EUR
                  $$GLOBAL2_RATE_TYPE=Corporate
                  $$GLOBAL3_CURR_CODE=EUR
                  $$GLOBAL3_RATE_TYPE=Corporate
                  $$HEADCOUNT=In Dienst
                  $$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=TO_DATE('1980-01-01 08:19:00', 'YYYY-MM-DD HH24:MI:SS')
                  $$HR_WRKFC_ADJ_SERVICE_DATE='N'
                  $$HR_WRKFC_EXTRACT_DATE=01/01/1970
                  $$HR_WRKFC_SNAPSHOT_DT=TO_DATE('2004-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
                  $$HR_WRKFC_SNAPSHOT_TO_WID=20100818
                  $$Hint1=
                  $$Hint_Tera_Post_Cast=
                  $$Hint_Tera_Pre_Cast=
                  $$INITIAL_EXTRACT_DATE=01/01/1970
                  $$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=06/29/2010
                  $$LAST_EXTRACT_DATE_IN_SQL_FORMAT=TO_DATE('2010-06-29 00:49:21', 'YYYY-MM-DD HH24:MI:SS')
                  $$LAST_EXTRACT_DATE_WID=20100629
                  $$LAST_TARGET_EXTRACT_DATE_IN_SQL_FORMAT=TO_DATE('2010-06-29 00:49:21', 'YYYY-MM-DD HH24:MI:SS')
                  $$LEDGER_ID_LIST=2022
                  $$LEDGER_TYPE_LIST='NONE'
                  $$LOAD_DT=TO_DATE('2010-08-18 19:15:04', '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=1100000061
                  $$PROD_CAT_SET_ID2=1100000041
                  $$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
                  $DBConnection_OLAP=DataWarehouse
                  $DBConnection_OLTP=ORA_R12
                  $PMSessionLogFile=Custom_SDE.SDE_ORA_ProjectCostLine.log

                  -----

                  Edited by: user565199 on 22-nov-2010 3:50

                  Edited by: user565199 on 22-nov-2010 3:51
                  • 6. Re: Task failed with unknow error
                    568202
                    anyone?