Set up of the SMTP output adapter

[Former Member]

Hi Colleagues,

I'm trying to use the SMTP Output adapter in order to send email on a certain event. This is setup of the adapter:

smtpHost = 'mail.sap.corp' ,
addressColumn = '<email>@sap.com' ,
subjectColumn = '<Subj>' ,
importanceColumn = 'IMPORTANCE' ,
fromAddress = '<user>@<server>' ;

The event occurs but email doesn't send by server. SMPT on the machine set up and it's possible to send a test email from the FS using mailx utility.

Does someone have any idea of what might be wrong here? Uh, one more thing - I tried to find out any error messages in log and trc files of the system - nothing.

Thanks in advance.

Best regards,

Andy.

[former_member217348 · Accepted solution]

Hi Andy,

What version of ESP (the full version string) are you using? To find that out, please follow the instructions here: Locating the ESP Version Information - SAP Event Stream Processor: Troubleshooting Guide - SAP Libra...

Thank you,

Alice

[Former Member · Accepted solution]

Hi Alice,

Here's the version:

SAP HANA smart data streaming Cluster Admin 1.0.101.00/20150623.1/SP10 Rev101/linux/x86_64/64-bit/OPT/Tue Jun 23 16:19:10 PDT 2015

Thanks and best regards,

Andy.

[former_member217348 · Accepted solution]

Hi Andrey,

To fix this, change the addressColumn, subjectColumn, importanceColumn values to be the column names of the stream or window to which the adapter is attached. The stream provides the strings that get used for creating the email message's address, subject and importance fields.

Here's a simple example:

CREATE INPUT STREAM NEWSTREAM SCHEMA (Column1 INTEGER ,

  recipAddr string ,

  subj string ,

  importance string );

ATTACH OUTPUT ADAPTER SMTP_Output1 TYPE smtp_out

TO NEWSTREAM

PROPERTIES

  smtpHost = 'mail.sap.corp' ,

  addressColumn = 'recipAddr' ,

  subjectColumn = 'subj' ,

  importanceColumn = 'importance' ,

  fromAddress = 'espuser@myserver.com' ,

  resendAttempts = 3 ;

Then, input a row of data: 500, <email>@sap.com, sub, normal

The email will show up in the email inbox (<email>@sap.com) as:

From: espuser@myserver.com

Sent: <date and time stamp of email>

To: <email>@sap.com

Subject: sub

===NEWSTREAM===

Column1=500

recipAddr=<email>@sap.com

subj=sub

importance=normal