Page 1 of 1

Problem in sending Email

Posted: Wed Nov 04, 2009 8:15 am
by Manu1
Hi Friends

we are using Email Notification Activity in Job Sequence.
after completing the sequence run we are not getting any mail,
in log files we are getting message like below:
Sent message to 'someone@abc.com'
Executed command: /opt/datastage/Ascential/DataStage/Projects/greyhound_jde_new/sendmail_seq_jde_account_code_combination4973_29374.sh
*** No output from command ***
The following parameters in the call to DSSendMail were not mentioned in the file 'dssendmail_template.txt': server


Can you please help me what is the problem,what we need to do to resolve this.

Thanks&Regards

Manu

Posted: Wed Nov 04, 2009 8:22 am
by chulett
That log message is not a problem and is normal on a UNIX server. Check with your Sysadmin and see if there are any sendmail issues on that box.

Posted: Wed Nov 04, 2009 8:49 am
by Manu1
Same Parameters (server,sender and receiver names) are used in Production job and it is running fine (We are receiving the mail).But not sure why it is giving problem here :(

Posted: Wed Nov 04, 2009 8:54 am
by chulett
That's why you need to check with your Admin... as long as you are certain the email address you are using is valid.

Posted: Wed Nov 04, 2009 10:23 am
by hiral.chauhan
We've been having the same problem and for a long time we could not find out what the problem was. We finally got this figured out a week ago.

Two things you need to do:

1) Make your dssendmail.txt look like:

#! /bin/sh
/usr/sbin/sendmail -t<<////
From: %from%
To: %to%
Subject: %subject%
Server : %server%

%body%
////

So that it gets your "server" parameter which is your smtp server address.


2) There is a config file for postfix on the Unix box (our's is a Suse Linux 10) mostly it should be under /etc/postfix/main.cf

Main.cf is your config file for postfix that sends email. This file has several parameters like smtp server, hostname, domain name, relay host etc. These parameters are defined at the bottom of the file. You need to make two changes:
-Make sure the "relayhost" parameter has your smtp server name (for example mail.abc.com)
-Make sure the "myhostname" parameter = hostname.abc.com

You should be able to send an email notification after these changes, hopefully!

Hiral

Posted: Wed Nov 04, 2009 10:28 am
by chulett
For #1, that is the default so should be fine unless someone messed with it. I suspect your solution was all about #2 as there's no need to include the 'Server' in a UNIX Notification Activity stage.

Posted: Wed Nov 04, 2009 10:34 am
by hiral.chauhan
Thats right! Just checked it, you do not need to include "Server" in the notification Activity stage.

So I guess yes, just add your smtp server name in your relayhost parameter and update your myhostname if it is not already.

are you able to resolve this?

Posted: Tue Nov 27, 2012 4:19 pm
by deepu09
Hi In our system I am facing same issue. We are running DS 8.5 in AIX server 5.3. After running Email Notification Activity in Job Sequence in DS logs it is showing this error:

JobControl (DSSendMail): Sent message to 'someone@xxxxx.com'
Executed command: /d02/IBM/InformationServer/Server/Projects/someProj01/sendmail_NZ_LST_50432453.2209_2129994.sh
*** No output from command ***
The following parameters in the call to DSSendMail were not mentioned in the file 'dssendmail.txt': server,

In project directory I have created dssendmail.txt file and assigned proper permissions too. But still it is showing same error message.

We are receiving emails, but problem is users they see this error message in logs they get confused and will raise tickets. If you know solution for this, can you please help?
|

Posted: Tue Nov 27, 2012 4:31 pm
by chulett
As noted, it is not an error message on a UNIX server. Does it actually get logged as something other than Informational (Green)?