I am running a Parallel job that contains a Basic Transformer. This basic transformer is calling DSSendMail.
I have observed several strange situations when using this as a multi-Instance job:
1. The emails sometimes fail to be sent out. A network error appears consistent with the send mail routine not being able to connect to the smtp server. When this error occurs, it consistently re-occurs when rerun until the job is run without invocation Id. Error Message Below:
2. The body of the email received contains a mixture of content from the current execution and the last execution of the job without invocation Id. Specifically, the email body portions derived from job parameters contain values from the execution of the last time the job was run without providing an invocation Id, and the portions of the body derived from stage variables are from the current execution. Even when I check the datastage job log for the current execution I can see that the job parameters are being passed correctly, but they are different from the values received in email.SMTPMail Looking up server...
SMTPMail Opening connection to ...
SMTPMail Unknown failure!
SMTPMail Error in trying to connect
SMTPMail Network error 10061
I found the above errors very odd, and have not been able to repeat them in some projects.
I have a default send mail template.
I have checked into the DSSendmail documentation and it seems that both the .bat and the .tmp generated are using the job name without invocation Id included. The %file% token manipulation doesn't seem to affect this naming.
Questions:
1. Anybody know anyway to change the naming of the .bat and .tmp files to help eliminate one possible source of contention?
2. Any other ideas to help explain the anomalies above?
Thanks,
Greg