topic Re: Email error - SAS Visual Analytics in SAS Visual Analytics

Email error - SAS Visual Analytics

avinashaecwb — Fri, 23 Dec 2016 10:03:39 GMT

I am getting "E-mail could not be sent because: E-mail service error" while trying to send an email from Report Designer window. I did the following based on other posts in the community and google results:

1) SAS Management Console: set email.host and email.port in Application Management -> Configuration Manager -> Application Infrastructure.

2) Put system options as below in sasv9_usermods.cfg file:

-emailsys smtp
-emailhost mailer4.xxxxx.com.au
-emailport=587
-emailauthprotocol = login
-emailid=xxxxx@xxxxxx.com.au
-emailpw = xxxxxxx

3) Added below line in server.sml file:

4) Did Object Spawner and Server restart.

I still am getting same error. What am I doing wrong ?

I am providing userid value as my outlook email id.

Thanks

Re: Email error - SAS Visual Analytics

ballardw — Fri, 23 Dec 2016 15:19:12 GMT

It really helps when receiving errors to post both the code and the entire error from the log window. Amazingly compared to some products many SAS error messages are actually descriptive. Also, sometimes the reported error is related to a warning received earlier.

Is the first time you are attempting to send emails or did this work in the past and has stopped working? If previously working code has stopped it often means that something has changed in your system. For instance, my IT organization is notorious for changing security settings without notifying users and processes failing is the first clue.

You may need to check with your IT staff about things related to smtp mail server, correct name, port and if you even have smtp running.

Re: Email error - SAS Visual Analytics

avinashaecwb — Sat, 24 Dec 2016 17:38:54 GMT

@ballardw the error message actually is only "E-mail could not be sent because: E-mail service error". There is no Show Details or Log generated with error description. This is the first time I am trying to send out email from SAS VA Report Designer window. Also, there's no coding involved for this. I actually am able to send email successfully if I write a code using FILENAME statement and DATA Steps. However, I get the error if i use "Email" option from the menu "File".

Re: Email error - SAS Visual Analytics

kaushalsolanki — Tue, 27 Dec 2016 10:28:52 GMT

Hi,

I would like to suggest you that first try to send an e-mail through your server command prompt and after that try to send an email through SAS EG, For your reference has attached the link below.

http://support.sas.com/kb/18/363.html

After doing above two step you can go to SAS Visual Analytics for sending email.

Regards,

Kaushal Solanki

Re: Email error - SAS Visual Analytics

avinashaecwb — Wed, 28 Dec 2016 11:16:02 GMT

The issue has been fixed. Google at rescue !!

Re: Email error - SAS Visual Analytics

sandeep_reddy — Tue, 20 Jun 2017 04:53:24 GMT

Hello Avinash,
Could you please let me know how you resolved this. I am experiencing the same issue even after doing all the configurations and restarts.
Best Regards,
Sandeep.

Re: Email error - SAS Visual Analytics

sas_admin — Sun, 03 Sep 2017 13:52:44 GMT

I know this is an old thread. I had issues finding an answer and the SAS Intelligence Platform Middle Tier Administration isn't 100% on my specific case. Below is specific to the AWS SMTP server that uses TLS.

Environment:

Windows 2008 R2

SAS 9.4 M3

1) SAS Management Console: set email.host and email.port in Application Management -> Configuration Manager -> Application Infrastructure.

email.host = email-smtp.us-east-1.amazonaws.com

email.port = 587

2) Put system options as below in sasv9_usermods.cfg file: Note AWS SES credentials must be obtained

-emailsys SMTP
-emailport 587
-emailhost ("email-smtp.us-east-1.amazonaws.com" STARTTLS id=AWS_SES_Credential_ID pw=AWS_SES_Credential_Key auth=LOGIN port=587)

3) Added below line in server.sml file: Note the 'mail.smtp.starttls.enable="true"'

4) Performed full SAS services restart, mainly for peice of mind. At minimum, the WebAppServer(s) needs to be restarted. In my case this is only SASServer1_1.