Analytics Software

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.*
-----