Categories
Informatica Powercenter Workflow Execution Failed.
HI,
I am using Powercenter 9.6.1. I added the Oracle VIEW to the Source Designer. Mapped the fields to the Expression Transmation (no rules was added). Dragged a few fields from the Expression Transformation to the Target File. Created the work flow.
I got it to work from file to file, but I am having issues from Oracle Database VIEW to file. I only dragged 4 columns and still getting this error. The two SEVERE ERROR are vague and it is hard for me to pinpoint the error source.
Any guru help is greatly appreciated from this newbie.
Is there steps for debugging? I restarted a new mapping with simple mapping but it is not working.
I specified in the Session Properties that the output directory is my local desktop folder.
Got the following errors in the log
Severity Timestamp Node Thread Message Code Message
ERROR 7/7/2016 8:12:01 AM node01_infa 47527262980416 LM_36320 Session task instance [s_Telestaff_Mapping]: Execution failed.
ERROR 7/7/2016 8:12:02 AM node01_infa 47527231510848 LM_36320 Workflow [wf_Telestaff_Mapping]: Execution failed.
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_36435 Starting execution of workflow [wf_Telestaff_Mapping] in folder [USSS_UDRMS] last saved by user [jyee].
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_44206 Workflow wf_Telestaff_Mapping started with run id [154031], run instance name [], run type [Concurrent Run Disabled].
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_44195 Workflow [wf_Telestaff_Mapping] service level [SLPriority:5,SLDispatchWaitTime:1800].
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_44253 Workflow started. Clients will be notified
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_36330 Start task instance [Start]: Execution started.
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_36318 Start task instance [Start]: Execution succeeded.
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_36505 Link [Start --> s_Telestaff_Mapping]: empty expression string, evaluated to TRUE.
INFO 7/7/2016 8:11:58 AM node01_infa 47527231510848 LM_36388 Session task instance [s_Telestaff_Mapping] is waiting to be started.
INFO 7/7/2016 8:11:58 AM node01_infa 47527221020992 LM_36330 Session task instance [s_Telestaff_Mapping]: Execution started.
INFO 7/7/2016 8:11:58 AM node01_infa 47527221020992 LM_36682 Session task instance [s_Telestaff_Mapping]: started a process with pid [21134] on node [node01_infa].
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6793 Fetching initialization properties from the Integration Service. : (Thu Jul 07 08:11:59 2016)]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [DISP_20305 The [Preparer] DTM with process id [21134] is running on node [node01_infa].
: (Thu Jul 07 08:11:59 2016)]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6722 Finished [Connect to Repository]. It took [0.14189] seconds.]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6794 Connected to repository [dev_hrt1_pc_rep] in domain [dev_infa] as user [jyee] in security domain [Native].]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6721 Started [Fetch Session from Repository].]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6722 Finished [Fetch Session from Repository]. It took [0.0344312] seconds.]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6721 Started [Partition Group Formation].]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6722 Finished [Partition Group Formation]. It took [0.0263729] seconds.]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [PETL_24037 Finished the prepare phase for the session.]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6792 Notifying the Integration Service that the prepare phase has been completed. : (Thu Jul 07 08:12:00 2016)]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [TM_6721 Started [Connect to Repository].]
INFO 7/7/2016 8:12:00 AM node01_infa 47527252490560 LM_36488 Session task instance [s_Telestaff_Mapping] : [PETL_24036 Beginning the prepare phase for the session.]
WARNING 7/7/2016 8:12:01 AM node01_infa 47527262980416 LM_36331 Session task instance [s_Telestaff_Mapping] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [wf_Telestaff_Mapping] will be failed.
Answers
-
Looks like what you shared is Workflow log! Session log file might help to address the issue.
FYI: Check the source and target connection settings in session properties.
0 -
Hi,
In the Workflow manager,
For the source connection, I specified Relational and picked the Oracle connection that was provided to me. I verified that my username was added to this connection object.
For the target connection, it is None. I assume that was okay since it is a flat file.
Is that current?
0 -
share screenshot
0