Toad data point send email activity malfunction

Toad Data Point & Toad Intelligence Central
1

Hi folks ,

I am facing a problem with toad data point that when i add to automation script the (send email) activity and i set server settings to my email provider for example gmail smtp server it shows these errors

10/26/2016 10:09:18 AM Send email
10/26/2016 10:09:40 AM Socket connection has timed out. InnerException message follows: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.123.96.139:25
10/26/2016 10:09:40 AM A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.123.96.139:25
10/26/2016 10:09:40 AM at dr.a(Exception A_0)
at dr.a(IPEndPoint A_0)
at dx.a(IPEndPoint A_0)
at b7.a(IPHostEntry A_0, Int32 A_1)
at bb.a(String A_0, Int32 A_1, Boolean A_2, EndPoint A_3)
at bb.y()
at go.y()
at g5.y()
at go.a(MailMessage A_0, String A_1, EmailAddressCollection A_2, DeliveryNotificationOptions A_3, Smtp8bitDataConversion A_4, Boolean A_5, SendFailureThreshold A_6, Boolean A_7, DataTable A_8, Int32 A_9, String A_10)
at g5.a(MailMessage A_0, String A_1, EmailAddressCollection A_2, DeliveryNotificationOptions A_3, Smtp8bitDataConversion A_4, Boolean A_5, SendFailureThreshold A_6, Boolean A_7, DataTable A_8, Int32 A_9, String A_10)
at bj.a(MailMessage A_0, String A_1, EmailAddressCollection A_2, DeliveryNotificationOptions A_3, Smtp8bitDataConversion A_4, Boolean A_5, SendFailureThreshold A_6, Int32 A_7, fp A_8, Boolean A_9, DataTable A_10, Int32 A_11, String A_12)
at g7.a(String A_0, EmailAddressCollection A_1)
at g7.a(Boolean A_0, String A_1, EmailAddressCollection A_2)
at g7.a(Boolean A_0)
at MailBee.SmtpMail.Smtp.Send()
at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email)
10/26/2016 10:09:40 AM Email successfully sent
10/26/2016 10:09:40 AM There were errors encountered sending the message. See the log file for details.
10/26/2016 10:09:40 AM at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email)
at Quest.Toad.Workflow.Activities.SendEmailActivity.Execute(ActivityExecutionContext executionContext)
10/26/2016 10:09:40 AM Failed

*** Notice that when i use Restricted Gmail SMTP server version setting without ticking ssl secure option it sends the email into only gmail users and puts the mail in junk.

i hope anyone has any hints can help me with this problem

2

hi Joecohlber-DE145,

The error says there was a time out and it looks like your network is restricted to use SSL. Which port did you use? 465? Because that is the port you should use… Either than or 587 which stands for TLS (both supported by gmail). Also please clarify which port did you use before enabling SSL (the default 25?).

Could you please tell me what smtp server address did you enter for gmail? Is it smtp.gmail.com?

Could you please open cmd from start menu and run “telnet smtp.gmail.com 465” to see if you get error?

Have you consulted this with your network administrator?

Martin