Problem in sending Email

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Manu1
Participant
Posts: 36
Joined: Mon Aug 31, 2009 5:51 am
Location: Hyderabad

Problem in sending Email

Post 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
Manu
Datastage Devoloper
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Manu1
Participant
Posts: 36
Joined: Mon Aug 31, 2009 5:51 am
Location: Hyderabad

Post 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 :(
Manu
Datastage Devoloper
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
hiral.chauhan
Premium Member
Premium Member
Posts: 45
Joined: Fri Nov 07, 2008 12:22 pm

Post 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
Thanks,
Hiral Chauhan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
hiral.chauhan
Premium Member
Premium Member
Posts: 45
Joined: Fri Nov 07, 2008 12:22 pm

Post 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.
Thanks,
Hiral Chauhan
deepu09
Participant
Posts: 15
Joined: Sat Nov 03, 2012 11:16 pm

are you able to resolve this?

Post 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?
|
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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)?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply