Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Email error - SAS Visual Analytics

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Email error - SAS Visual Analytics

Hi

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:

 

<Resource auth="Container" mail.smtp.host="mailer4.xxxxx.com.au" mail.smtp.port="587" name="sas/mail/Session" type="javax.mail.Session" mail.smtp.auth="true" mail.smtp.user="xxxxxx@ticgroup.com.au" password="xxxxxxx" mail.smtp.ssl.enable="true"/>

 

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


Accepted Solutions
Solution
‎12-28-2016 06:16 AM
Occasional Contributor
Posts: 13

Re: Email error - SAS Visual Analytics

Posted in reply to avinashaecwb

The issue has been fixed. Google at rescue !!

View solution in original post


All Replies
Super User
Posts: 11,578

Re: Email error - SAS Visual Analytics

Posted in reply to avinashaecwb

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.

Occasional Contributor
Posts: 13

Re: Email error - SAS Visual Analytics

@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".

 

 

Contributor
Posts: 63

Re: Email error - SAS Visual Analytics

Posted in reply to avinashaecwb

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

Solution
‎12-28-2016 06:16 AM
Occasional Contributor
Posts: 13

Re: Email error - SAS Visual Analytics

Posted in reply to avinashaecwb

The issue has been fixed. Google at rescue !!

Contributor
Posts: 61

Re: Email error - SAS Visual Analytics

Posted in reply to avinashaecwb
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.
New User
Posts: 1

Re: Email error - SAS Visual Analytics

Posted in reply to avinashaecwb

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"'

 

<Resource auth="Container" name="sas/mail/Session" type="javax.mail.Session" mail.smtp.starttls.enable="true" mail.smtp.auth="true" mail.smtp.host="email-smtp.us-east-1.amazonaws.com" mail.smtp.port="587" mail.smtp.user="AWS_SES_Credential_ID" password="AWS_SES_Credential_Key"/>

 

 

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.

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 888 views
  • 0 likes
  • 5 in conversation