Facing this problem in Datastage 5.2 on the Unix AIX,when calling then DSSendMail function to send the mail. During execution, it has created "sendmail_TestMail.sh" under project directory (.../ds_projects/cust), but it couldn't trigger the shell script.I could receive the mail when I run this shell script manually.
Follwoing is the error message from the ETL job:
=================================================================
TestMail1..JobControl (DSSendMail): Error when executing command: "sendmail_TestMail.sh"
*** Output from command was: ***
SH: sendmail_TestMail1.sh: not found.
=================================================================
Please let me know if anyone has the solution for this.Thxs.
Problem in Sending Mail using DSSendMail
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The error message is returned from the operating system, and is very clear; the shell script could not be found. This is most likely because the directory in which it occurs is not one of the directories listed in the PATH environment variable.
Possible solutions include:
invoking the shell script using its full pathname (recommended)
placing the pathname of current directory (.) in PATH
placing the pathname of project directory in PATH
Possible solutions include:
invoking the shell script using its full pathname (recommended)
placing the pathname of current directory (.) in PATH
placing the pathname of project directory in PATH
Hi Ray,
Thanks for your reply.
Checked the PATH variable and is having the current dir (".") in its path reference.
The problem is, while execution, the DSSendMail function creates the shell scripts in the proper directory, but failes to fire it.
Actually, it suppose to do these two actions when it was executed. But, it has done the first action properly, but failed in the second action.
If there is a problem in the PATH variable setup as you said, then how it has created the shell scripts in the proper directory during execution?!
Thanks for your reply.
Checked the PATH variable and is having the current dir (".") in its path reference.
The problem is, while execution, the DSSendMail function creates the shell scripts in the proper directory, but failes to fire it.
Actually, it suppose to do these two actions when it was executed. But, it has done the first action properly, but failed in the second action.
If there is a problem in the PATH variable setup as you said, then how it has created the shell scripts in the proper directory during execution?!