Error in Using DSSendMail

nilotpalr · Post by **nilotpalr** » Tue Dec 17, 2002 9:36 pm

Hi All,
I am using DSSendMail on unix. When i try to execute the command from a routine, I get the following error:

Arg1 = nroy@abc.com - ** This is my To Address
Arg2 = paritosh@xyz.com - ** this is my From Address
Arg3 = Testing from Xavient - ** THis is my Subject
Arg4 = Testing - ** this is the mail body.

All these 4 arguments are passed as parameters to a routine, from which i call DSSendMail. On NT i do not get any problem. But on Unix it gives the following error:

Test completed.

DSLogWarn called from : DSSendMail
Message to be logged is...
> Error when executing command: "sendmail_77405.sh"
> *** Output from command was: ***
> Warning: .cf file is out of date: sendmail 8.11.6+Sun supports version 9, .cf file is version 8
> No recipient addresses found in header
> sendmail_77405.sh: From:: execute permission denied
> sendmail_77405.sh: To:: execute permission denied
> sendmail_77405.sh: Subject:: execute permission denied
> sendmail_77405.sh: Testing: execute permission denied
> sendmail_77405.sh: ////: cannot execute
>
>
> Contents of command file:
> #! /usr/bin/sh
> /usr/sbin/sendmail -t -v From: paritosh@xyz.com
> To: nroy@abc.com
> Subject: Testing from Xavient
>
> Testing
> ////

Result = -21
Can any one help me in this..
Thanks in advance,
Nilotpal.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 18, 2002 3:50 pm

The error message tells you that you have a version 8 .cf file for sendmail, but version 9 is required by the sendmail program that ships with your version of Solaris.
You should get the same error trying to use the same sendmail script from the UNIX level, which shows that it's not a DataStage problem. The fact that it works on the Windows platform also suggests that it's not a DataStage problem.
Solution is to get a version 9 .cf file from your Solaris vendor.

Edited by - ray.wurlod on 12/18/2002 15:51:51

ray.wurlod · Post by **ray.wurlod** » Wed Dec 18, 2002 11:28 pm

nilotpalr sent mail to my private email address, which I prefer not to happen.
In it, he (?) asserts that there is no problem using sendmail from the UNIX prompt. I asked whether the problem occurs if sourcing the sendmail.sh script from the UNIX prompt.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 19, 2002 5:19 am

(Sent to private email address):
Hi Ray,
The sendmail.sh generated by DataStage gives the same error as I
reported on the forum. But the SendMAil on unix prompt works fine.
Thanks,
Nilotpal.

Then it's something in the script, and presumably in the sendmail template file that you have set up for DataStage to use. Change things (one at a time) until it works.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518