Email sending Error using DSSendMail

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
fk4u
Participant
Posts: 30
Joined: Fri May 12, 2006 12:38 am

Email sending Error using DSSendMail

Post by fk4u »

Hello,

We are using the NotificationActivity plugin to send email after completion of specific job. We have windows client and Datastage server is on AIX ver5. We have filled all the entires correctly like smtp server name, sender email address and receiver email address.
Our job executed successfuly and director shows following Messege.
18:43:02: Notification_Activity_1 (ROUTINE DSSendMail) started
18:44:03: Notification_Activity_1 finished, reply=0
18:44:03: Sequence finished OK


But the end result is no email is being sent.
We received returned email on AIX in /var/spool/mail/ dir with following Messege::
-------------------------------------------------------
This is a MIME-encapsulated message

--k6UNi2R295382.1154303043/DWH_ETL2_standby1

The original message was received at Sun, 30 Jul 2006 18:44:02 -0500
from dsadm@localhost

----- The following addresses had permanent fatal errors -----
farooq.khalid@d-p-s.com
(reason: 550 Host unknown)

----- Transcript of session follows -----
550 5.1.2 farooq.khalid@d-p-s.com... Host unknown (Name server: d-p-s.com: host not found)

--k6UNi2R295382.1154303043/DWH_ETL2_standby1
Content-Type: message/delivery-status

Reporting-MTA: dns; DWH_ETL2_standby1
Arrival-Date: Sun, 30 Jul 2006 18:44:02 -0500

Final-Recipient: RFC822; farooq.khalid@d-p-s.com
Action: failed
Status: 5.1.2
Remote-MTA: DNS; d-p-s.com
Diagnostic-Code: SMTP; 550 Host unknown
Last-Attempt-Date: Sun, 30 Jul 2006 18:44:02 -0500

--k6UNi2R295382.1154303043/DWH_ETL2_standby1
Content-Type: message/rfc822

Return-Path: <dsadm>
Received: (from dsadm@localhost)
by DWH_ETL2_standby1 (AIX5.3/8.11.6p2/8.11.0) id k6UNi2S147456;
Sun, 30 Jul 2006 18:44:02 -0500
Date: Sun, 30 Jul 2006 18:44:02 -0500
Message-Id: <200607302344.k6UNi2S147456@DWH_ETL2_standby1>
From: asad@d-p-s.com
To: farooq@d-p-s.com
Subject: TESTMAIL
MIME-Version: 1.0
----------------------------------------------------------
Note::
dsadm is osuser
smtp address is mail.d-p-s.com
These settings works OK for windows Outlook

Can any one help us in this regard.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
The notification activity has no success indicator.
Like you've seen you can't expect rejected mail notifications either.
In short your safest bet would be implementing a ussage of the organization's notification mechanism or anything similar.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
fk4u
Participant
Posts: 30
Joined: Fri May 12, 2006 12:38 am

Post by fk4u »

Hi Roy,
Can you please explain me little more how to send email notification successfuly. I have tried but couldn't find the solution.
In error messege it shows that email address and smtp name is incorrect
Why this occur as every thing is correct.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Email sending Error using DSSendMail

Post by chulett »

fk4u wrote:Note:: These settings works OK for windows Outlook
Doesn't matter. Your UNIX server is doing the mail sending here, not Windows nor Outlook.

I'd suggest you talk to your SAs. Let them know what you are doing and what errors you are getting. Getting email to send out successfully from that AIX box falls into their domain.
-craig

"You can never have too many knives" -- Logan Nine Fingers
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Ask your sysadmins to configure your send-mail on the ds server box to be anabled and working, once you have it working so will your mail notification activities and ussage of the DSSendMail routine will work as well.
Plus you can leave the smtp entry empty.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
fk4u
Participant
Posts: 30
Joined: Fri May 12, 2006 12:38 am

Post by fk4u »

Thanks a lot for handy sugestions.
Post Reply