Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

A session with "On Failure E-mail" does not send emails when the execution fails
Problem Description

A reusable session has configured the On Failure E-mail and On Success email tasks. When the session execution succeeds, the proper email is sent. However, when the session fails, the On Failure E-mail task is expected to send an email, but it does not.

Cause

​This issue occurs if the session fails during initialization. 

 

The Integration Service sends post-session email at the end of a session after executing post-session shell commands or stored procedures. However, in a scenario where the session has started but it fails during the initialization process (e.g. reading parameter files) the On Failure E-mail are not sent. 

 

Errors during the session initialization are not written in the session logs, but in the workflow logs. Nevertheless, any error message related to email sending is written on them.

Solution
 
This is the expected behavior and works as designed. ​Check the workflow logs and correct the issues with the session initialization.

Workaround

 
Add an e-mail task in the workflow sending email based on the success/failure of the session.
More Information

​INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_36435 : Starting execution of workflow [wf_NEWMAPPING189] in folder [NEWFOLDER0] last saved by user [Administrator].
INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_44206 : Workflow wf_NEWMAPPING189 started with run id [55], run instance name [], run type [Concurrent Run Disabled].
INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_44195 : Workflow [wf_NEWMAPPING189] service level [SLPriority:5,SLDispatchWaitTime:1800].
INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_44253 : Workflow started. Clients will be notified
INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_36330 : Start task instance [Start]: Execution started.
INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_36318 : Start task instance [Start]: Execution succeeded.
INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_36505 : Link [Start --> s_NEWMAPPING189]: empty expression string, evaluated to TRUE.
INFO : (13538 | 36) : (IS | ISM) : N_01717967 : LM_36388 : Session task instance [s_NEWMAPPING189] is waiting to be started.
INFO : (13538 | 37) : (IS | ISM) : N_01717967 : LM_36682 : Session task instance [s_NEWMAPPING189]: started a process with pid [26995] on node [N_01717967].
INFO : (13538 | 37) : (IS | ISM) : N_01717967 : LM_36330 : Session task instance [s_NEWMAPPING189]: Execution started.
ERROR : (13538 | 37) : (IS | ISM) : N_01717967 : VAR_27086 : Cannot find specified parameter file [/home//param123.txt] for [session [wf_NEWMAPPING189.s_NEWMAPPING189]].
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [TM_6793 Fetching initialization properties from the Integration Service. : (Tue Jul 14 15:05:36 2015)]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [DISP_20305 The [Preparer] DTM with process id [26995] is running on node [N_01717967]. : (Tue Jul 14 15:05:36 2015)]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [PETL_24036 Beginning the prepare phase for the session.]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [TM_6721 Started [Connect to Repository].]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [TM_6722 Finished [Connect to Repository].  It took [0.235259] seconds.]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [TM_6794 Connected to repository [RSMAIF] in domain [D_01717967] as user [Administrator] in security domain [Native].]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [TM_6721 Started [Fetch Session from Repository].]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [TM_6722 Finished [Fetch Session from Repository].  It took [0.19452] seconds.]
INFO : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [TM_6793 Fetching initialization properties from the Integration Service. : (Tue Jul 14 15:05:36 2015)]
ERROR : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [CMN_1761 Timestamp Event: [Tue Jul 14 15:05:36 2015]]
ERROR : (13538 | 33) : (IS | ISM) : N_01717967 : LM_36488 : Session task instance [s_NEWMAPPING189] : [PETL_24049 Failed to get the initialization properties from the master service process for the prepare phase [Session task instance [s_NEWMAPPING189]: Unable to read variable definition from parameter file [/home/param123.txt].] with error code [1049600].]
ERROR : (13538 | 32) : (IS | ISM) : N_01717967 : LM_36320 : Session task instance [s_NEWMAPPING189]: Execution failed.
WARNING : (13538 | 32) : (IS | ISM) : N_01717967 : LM_36331 : Session task instance [s_NEWMAPPING189] failed and its "fail parent if this task fails" setting is turned on.  So, Workflow [wf_NEWMAPPING189] will be failed.
ERROR : (13538 | 32) : (IS | ISM) : N_01717967 : LM_36320 : Workflow [wf_NEWMAPPING189]: Execution failed.

Applies To
Product: PowerCenter
Problem Type: Product Feature
User Type: Developer; Administrator
Project Phase: Implement; Onboard
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference

For more information, see ​Workflow Basics Guide > "Sending Email" > "Working with Post-Session Email"

Attachments
Last Modified Date:8/13/2019 3:45 PMID:340417
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)