DS 4.2 SP4 - SMTP_TO function

Hi there,

I am using DS 4.2 SP4.

While testing a SMTP_TO fucntion, the email is being sent out without any issues but the message body and trace lines are empty.

smtp_to(‘XX@YY.com’, ‘Test Subject’, ‘Test Message Body’,10, 50);

The ‘Test Message Body’ does not appear in the email.
No Trace lines in the email.

Using get_trace_filename() and get_error_filename() functions I printed the location of the error and trace files and they seem OK. The files are located in the path mentioned in DS_COMMON_DIR…\log<Repo>…

Has anyone encountered a similar issue? Any suggestions?

Thanks


srini_sankar (BOB member since 2015-05-05)

Hi,

We are also facing the same issue. We are getting the email with the subject, but the message body is empty. Anyone else is also facing the same problem?

Version: Data Services 4.2
OS: Windows 2008 R2


dineshku (BOB member since 2008-05-26)

Hi all,

we have the same fastidious problem.
We receive the mail with the Subject but the body is empty!
I have checked the file built by the smpt_to function and it is correct (has the body) but the email arrives without it.

Configuration is:
BODS 4.2 SP5
Windows Server 2012 R2

We use the same SMTP server for event mail on DataIntegrator XI3.2 on Linux and it works perfectly.

Some help? :hb:


Holur (BOB member since 2015-11-05)

Ran into the same problem in BODS 4.2 SP5.

It’s very likely a bug in BODS, where it is not following the SMTP Syntax Rule “SMTP expects there to be a double new line between headers and content”,
resulting in some SMTP servers (Microsoft Exchange, Office365) ignoring/not including the email body!

Workaround:
Add
||chr(13)||chr(10)
at the end of the subject field.

Example:
smtp_to(‘rec1@my.test,rec2@my.test’, 'Error occurred in Load at '|| sysdate() ||chr(13)||chr(10), ’ ',20,50);

Now the received email contains the last 20 lines of the Trace Log and the last 50 lines of the Error Log in its body, as expected.


micham (BOB member since 2014-03-27)

Hi micham,

thx for your post.

It works for me,
DS 14.2.5.800 and Exchange 2012 or 14…

THX
Holger


h.blum :de: (BOB member since 2008-06-16)

GREAT!! IT WORKS!! :+1: :lol:


Holur (BOB member since 2015-11-05)

We also had the same issue, this is not a bug please follow these steps that should resolve your issue.

Go to the DSConfig.txt file under the email section , set these two values to true.

CarriageReturnLineFeed = TRUE
Use_CRLF_For_End_Line=TRUE

That should solve the empty email body issue. We got our issue resolved by following this approach.

Thanks,
Kiran


kirankk4u (BOB member since 2009-10-16)

This did not work for me. Adding CRLF to the subject value in the call to SMTP_TO() did work.


eganjp :us: (BOB member since 2007-09-12)

I change file DSCONFIG.TXT and it worked.
Thanks.


leodduraes (BOB member since 2017-12-13)

Thanks for the DSConfig info - I will give that a try. Of course we’ve already changed all of our calls to smtp_to…

Thanks,
Mark


brudosm (BOB member since 2014-12-12)

Thanks, it also solved my issue with DS 4.5 SP10


ahdaronco (BOB member since 2014-04-10)

we are on SAP DS 4.2 SP08 running on Windows and the email section in the DSConfig.txt file is updated like below and job server has been re-started. But Email is getting triggered successfully with subject only but message/body is empty/blank.
DS Designer is logged on from Citrix Remote Desktop.

Please suggest any clue to resolve this. Of course, I tested emails sending successfully with workaround by adding CHR(13)||CHR(10) to the end of subject line to make it work.

[Email]
mailexe = mailer.exe
messagefile = messagefile.tmp
mailfrom = ActaLink
smtpexe = smtp_mailer.exe
smtpfrom =
smtpserver =
CarriageReturnLineFeed = TRUE
Use_CRLF_For_End_Line = TRUE

[EMailUnix]
mailexe = mailx
messagefile = messagefile.tmp
mailfrom = ActaLink
smtpexe = smtp_mailer
DSConfig.txt (11.0 KB)


navo_11 (BOB member since 2018-11-13)