Issue with UtilitySeqEmailAndAbort
Posted: Mon Jul 24, 2006 11:22 am
Hello,
In an effort to add additional event notification to production support for our ETL processes, I added calls to the Utility routine UtilitySeqEmailAndAbort in our sequencers. It was working fine and then a few days ago quit. When I look at the log for the sequencer UtilityEmailMsgsSeq and for a particular invocation, the following warning messages is listed:
******************************************************
UtilityEmailMsgsSeq.J_FAA_Xcheck_Keys.JobControl (DSSendMail): Error when executing command: /dwtest/ads/US_DEV/sendmail_UtilityEmailMsgsSeq34402_12642.sh
*** Output from command was: ***
/home/batch/dead.letter... Saved message in /home/batch/dead.letter
The following parameters in the call to DSSendMail were not mentioned in the file 'dssendmail_template.txt': server
Please check any paths in the following command file are correct, and if necessary adjust the 'dssendmail_template.txt' file in the project directory.
Contents of command file:
#! /bin/sh
/usr/lib/sendmail -t <<////
From: '':AbortingJob:''
To: '':SupportEmail:''
Subject: '':SubjectLine:''
'':RoutGetMessages.$ReturnValue:''
////
******************************************************
dssendmail_template.txt:
#! /bin/sh
/usr/lib/sendmail -t <<////
From: %from%
To: %to%
Subject: %subject%
%body%
////
******************************************************
When I initially added the calls to UtilitySeqEmailAndAbort, I did not modify dssendmail_template.txt, and everything was working fine. My questions are:
1) What could cause the above error to suddenly start appearing when the process worked successfully before without the server token being defined?
2) If I do need to define the server token, how is this done? What would dssendmail_template.txt look like if one had to use it?
Any help is appreciated,
In an effort to add additional event notification to production support for our ETL processes, I added calls to the Utility routine UtilitySeqEmailAndAbort in our sequencers. It was working fine and then a few days ago quit. When I look at the log for the sequencer UtilityEmailMsgsSeq and for a particular invocation, the following warning messages is listed:
******************************************************
UtilityEmailMsgsSeq.J_FAA_Xcheck_Keys.JobControl (DSSendMail): Error when executing command: /dwtest/ads/US_DEV/sendmail_UtilityEmailMsgsSeq34402_12642.sh
*** Output from command was: ***
/home/batch/dead.letter... Saved message in /home/batch/dead.letter
The following parameters in the call to DSSendMail were not mentioned in the file 'dssendmail_template.txt': server
Please check any paths in the following command file are correct, and if necessary adjust the 'dssendmail_template.txt' file in the project directory.
Contents of command file:
#! /bin/sh
/usr/lib/sendmail -t <<////
From: '':AbortingJob:''
To: '':SupportEmail:''
Subject: '':SubjectLine:''
'':RoutGetMessages.$ReturnValue:''
////
******************************************************
dssendmail_template.txt:
#! /bin/sh
/usr/lib/sendmail -t <<////
From: %from%
To: %to%
Subject: %subject%
%body%
////
******************************************************
When I initially added the calls to UtilitySeqEmailAndAbort, I did not modify dssendmail_template.txt, and everything was working fine. My questions are:
1) What could cause the above error to suddenly start appearing when the process worked successfully before without the server token being defined?
2) If I do need to define the server token, how is this done? What would dssendmail_template.txt look like if one had to use it?
Any help is appreciated,