Notification Activity - Return Code -21
Posted: Wed Oct 22, 2008 7:02 pm
Hi
We're using DataStage 8.0.1 on Windows 2003.
I try to trigger a Notification Activity if a Job fails with anything other than 'OK'. I have created a test node that executes one child sequence and then triggers the Notification Activity, it works fine.
In my main Sequence, I get the following message in the log: "seqMain..JobControl (@emailODS): Routine DSSendMail did not finish OK, return code = '-21'"
and
seqMain..JobControl (DSSendMail): Error when executing command: E:\BUSI_DATA\Projects\BUSI_DEV\sendmail_seqMain_25291166_10644.bat
*** Output from command was: ***
SMTPMail Looking up server...
SMTPMail Opening connection to ...
SMTPMail RCV: 220 <server name removed> Microsoft ESMTP MAIL Service, Version: 6.0.3790.1830 ready at Thu, 23 Oct 2008 07:01:31 +1000
SMTPMail RCV: 250 <server name removed> Hello [147.209.182.123]
SMTPMail RCV: 250 2.1.0 <server name removed>....Sender OK
SMTPMail RCV: 221 2.0.0 <server name removed> Service closing transmission channel
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:
D:\IBM\InformationServer\Server\DSEngine\bin\dssmtpmail.exe -file sendmail_seqMain_25291166_10644_file.tmp
I have searched here and cannot find any clue as to what a Return Code -21 maybe. Could someone please point me in the direction of Return Codes and their meaning so I can continue my investigation.
thanks
Derek
We're using DataStage 8.0.1 on Windows 2003.
I try to trigger a Notification Activity if a Job fails with anything other than 'OK'. I have created a test node that executes one child sequence and then triggers the Notification Activity, it works fine.
In my main Sequence, I get the following message in the log: "seqMain..JobControl (@emailODS): Routine DSSendMail did not finish OK, return code = '-21'"
and
seqMain..JobControl (DSSendMail): Error when executing command: E:\BUSI_DATA\Projects\BUSI_DEV\sendmail_seqMain_25291166_10644.bat
*** Output from command was: ***
SMTPMail Looking up server...
SMTPMail Opening connection to ...
SMTPMail RCV: 220 <server name removed> Microsoft ESMTP MAIL Service, Version: 6.0.3790.1830 ready at Thu, 23 Oct 2008 07:01:31 +1000
SMTPMail RCV: 250 <server name removed> Hello [147.209.182.123]
SMTPMail RCV: 250 2.1.0 <server name removed>....Sender OK
SMTPMail RCV: 221 2.0.0 <server name removed> Service closing transmission channel
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:
D:\IBM\InformationServer\Server\DSEngine\bin\dssmtpmail.exe -file sendmail_seqMain_25291166_10644_file.tmp
I have searched here and cannot find any clue as to what a Return Code -21 maybe. Could someone please point me in the direction of Return Codes and their meaning so I can continue my investigation.
thanks
Derek