# TOAD Data Point 3.3 Email automation error **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [December 6, 2016, 6:46am UTC](https://forums.toadworld.com/t/toad-data-point-3-3-email-automation-error/38770 "2016-12-06T06:46:19Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![mark.oliver](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mark.oliver](https://forums.toadworld.com/u/mark.oliver)\ **Post date:** [December 6, 2016, 6:46am UTC](https://forums.toadworld.com/t/toad-data-point-3-3-email-automation-error/38770/1 "2016-12-06T06:46:19Z")
A user is having an issue with sending an automated email from TOAD. We’ve configured SMTP and allowed his laptop access through port 25. Everything seems to be set up OK, but we’re getting errors. Could you advise what it means please? – 06/12/2016 14:32:37: Migrated projects list.log: Setting up environment – 06/12/2016 14:32:37: Migrated projects list.log: Script run by Toad Data Point 3.3.0.1526 – 06/12/2016 14:32:37: Migrated projects list.log: Build started – 06/12/2016 14:32:37: Migrated projects list.log: Compiling Script – 06/12/2016 14:32:39: Migrated projects list.log: Build Completed – 06/12/2016 14:32:39: Migrated projects list.log: Begin execution script activities – 06/12/2016 14:32:39: Migrated projects list.log: Begin Export of File\_Export\_MigratedProjects – 06/12/2016 14:32:40: Migrated projects list.log: Connection to: KEEPPRD3.WORLD (EDQ), KEEP – 06/12/2016 14:32:40: Migrated projects list.log: Begin Export – 06/12/2016 14:32:40: Migrated projects list.log: SQL to execute: /_Migrated Projects_/ SELECT a.projectid AS project\_id, pt1.description AS type\_from, pt2.description AS type\_to, bt.description AS baseline\_template\_applied, pp.forename || ’ ’ || pp.surname AS migrated\_by, a.datemigrated AS date\_migrated, decode(a.result, 1, ‘OK’, ‘FAILED’) AS RESULT FROM migratedprojectaudit a INNER JOIN project\_type pt1 ON pt1.id = a.typeid\_from INNER JOIN project\_type pt2 ON pt2.id = a.typeid\_to INNER JOIN cti\_person pp ON pp.id = a.ctipersonid INNER JOIN Project p ON p.id = a.projectid LEFT OUTER JOIN baseline\_template bt ON bt.id = p.baseline\_template\_id ORDER BY datemigrated DESC, a.id DESC; – 06/12/2016 14:32:40: Migrated projects list.log: Beginning export – 06/12/2016 14:32:41: Migrated projects list.log: Attempted to export 609 rows – 06/12/2016 14:32:41: Migrated projects list.log: Successfully exported 609 rows – 06/12/2016 14:32:41: Migrated projects list.log: Export Finished, click Migrated projects2016-12-06.xlsx to view file – 06/12/2016 14:32:41: Migrated projects list.log: Row count variable File\_Export\_Migrated\_RCOUNT set to 609 rows – 06/12/2016 14:32:41: Migrated projects list.log: Send email – 06/12/2016 14:32:41: Migrated projects list.log: SocketException occurred. InnerException message follows: The requested name is valid, but no data of the requested type was found – 06/12/2016 14:32:41: Migrated projects list.log: The requested name is valid, but no data of the requested type was found – 06/12/2016 14:32:41: Migrated projects list.log: at a.ae.a(String A\_0) at a.ai.a(String A\_0) at a.m.a(String A\_0, Int32 A\_1, Boolean A\_2, Socket A\_3, EndPoint A\_4) at a.m.x() at a.f.l.x() at a.f.m.x() at a.f.l.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 a.f.m.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 a.f.e.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, aw A\_8, Boolean A\_9, DataTable A\_10, Int32 A\_11, String A\_12) at a.f.n.a(String A\_0, EmailAddressCollection A\_1) at a.f.n.a(Boolean A\_0, String A\_1, EmailAddressCollection A\_2) at a.f.n.a(Boolean A\_0) at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email) – 06/12/2016 14:32:41: Migrated projects list.log: Email successfully sent – 06/12/2016 14:32:41: Migrated projects list.log: Send\_Email\_1 - There were errors encountered sending the message. See the log file for details. – 06/12/2016 14:32:41: Migrated projects list.log: Continuing after error – 06/12/2016 14:32:41: Migrated projects list.log: Begin Export of File\_Exp\_NewProjOnISDelTempl – 06/12/2016 14:32:42: Migrated projects list.log: Connection to: KEEPPRD3.WORLD (EDQ), KEEP – 06/12/2016 14:32:42: Migrated projects list.log: Begin Export – 06/12/2016 14:32:42: Migrated projects list.log: SQL to execute: /_New Projects_/ SELECT p.id AS project\_id, pt.description AS project\_type, bt.description AS baseline\_template\_applied, pp.forename || ’ ’ || pp.surname AS created\_by, p.createdon AS created\_on FROM project p INNER JOIN project\_type pt ON pt.id = p.typeid INNER JOIN cti\_person pp ON pp.id = p.createdby LEFT OUTER JOIN baseline\_template bt ON bt.id = p.baseline\_template\_id WHERE pt.description = ‘IS Delivery’ AND p.id NOT IN (SELECT m.projectid FROM migratedprojectaudit m) ORDER BY p.id; – 06/12/2016 14:32:42: Migrated projects list.log: Beginning export – 06/12/2016 14:32:42: Migrated projects list.log: Attempted to export 36 rows – 06/12/2016 14:32:42: Migrated projects list.log: Successfully exported 36 rows – 06/12/2016 14:32:43: Migrated projects list.log: Export Finished, click NewISDelProjects-2016-12-06.xlsx to view file – 06/12/2016 14:32:43: Migrated projects list.log: Row count variable File\_Export\_New\_RCOUNT set to 36 rows – 06/12/2016 14:32:43: Migrated projects list.log: SocketException occurred. InnerException message follows: The requested name is valid, but no data of the requested type was found – 06/12/2016 14:32:43: Migrated projects list.log: The requested name is valid, but no data of the requested type was found – 06/12/2016 14:32:43: Migrated projects list.log: at a.ae.a(String A\_0) at a.ai.a(String A\_0) at a.m.a(String A\_0, Int32 A\_1, Boolean A\_2, Socket A\_3, EndPoint A\_4) at a.m.x() at a.f.l.x() at a.f.m.x() at a.f.l.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 a.f.m.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 a.f.e.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, aw A\_8, Boolean A\_9, DataTable A\_10, Int32 A\_11, String A\_12) at a.f.n.a(String A\_0, EmailAddressCollection A\_1) at a.f.n.a(Boolean A\_0, String A\_1, EmailAddressCollection A\_2) at a.f.n.a(Boolean A\_0) at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email) – 06/12/2016 14:32:43: Migrated projects list.log: Exception Email successfully sent Thank you ---
**Author:** ![Martin.Holkovic](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin.holkovic/32/318_2.png) [@Martin.Holkovic](https://forums.toadworld.com/u/Martin.Holkovic)\ **Post date:** [December 6, 2016, 7:05am UTC](https://forums.toadworld.com/t/toad-data-point-3-3-email-automation-error/38770/2 "2016-12-06T07:05:40Z")
Hello mark.oliver, I see that the user is running TDP v3.3 - is it possible for him/her to upgrade to the latest version and try it there? Could you please make a copy of the automation script (.tas file) and remove all activities but the send mail activity (to isolate it), then go to the Settings activity, enable “Verbose” log level and rerun and send us the execution log? Martin ---
**Author:** ![mark.oliver](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mark.oliver](https://forums.toadworld.com/u/mark.oliver)\ **Post date:** [December 9, 2016, 2:36am UTC](https://forums.toadworld.com/t/toad-data-point-3-3-email-automation-error/38770/3 "2016-12-09T02:36:20Z")
Thanks for the reply. I am sure I replied to this already! Obviously pressed the wrong button somewhere. I’m not upgrading his version as the user is on leave. I’ll ask him on his return. Our network team have confirmed that no SMTP traffic is coming from the laptop despite us having port 25 opened for the laptop. Here is the verbose log: – 06/12/2016 15:13:09: Migrated projects list.log: Setting up environment – 06/12/2016 15:13:09: Migrated projects list.log: Script run by Toad Data Point 3.3.0.1526 – 06/12/2016 15:13:09: Migrated projects list.log: Build started – 06/12/2016 15:13:09: Migrated projects list.log: Compiling Script – 06/12/2016 15:13:10: Migrated projects list.log: Build Completed – 06/12/2016 15:13:10: Migrated projects list.log: Begin execution script activities – 06/12/2016 15:13:10: Migrated projects list.log: Send email – 06/12/2016 15:13:10: Migrated projects list.log: Email To: [dominic.cox@arqiva.com](mailto:dominic.cox@arqiva.com), From: [Dominic.Cox@arqiva.com](mailto:Dominic.Cox@arqiva.com), cc: [Dominic.Cox@arqiva.com](mailto:Dominic.Cox@arqiva.com) – 06/12/2016 15:13:10: Migrated projects list.log: Email Subject: Migrated projects – 06/12/2016 15:13:10: Migrated projects list.log: Email message: PFA the current migrated projects list. – 06/12/2016 15:13:10: Migrated projects list.log: Setting up SMTP email – 06/12/2016 15:13:10: Migrated projects list.log: Smtp Server: smtp.arqiva.local – 06/12/2016 15:13:10: Migrated projects list.log: Smtp Port: 25 – 06/12/2016 15:13:10: Migrated projects list.log: Begin email send – 06/12/2016 15:13:10: Migrated projects list.log: SocketException occurred. InnerException message follows: The requested name is valid, but no data of the requested type was found – 06/12/2016 15:13:10: Migrated projects list.log: The requested name is valid, but no data of the requested type was found – 06/12/2016 15:13:10: Migrated projects list.log: at a.ae.a(String A\_0) at a.ai.a(String A\_0) at a.m.a(String A\_0, Int32 A\_1, Boolean A\_2, Socket A\_3, EndPoint A\_4) at a.m.x() at a.f.l.x() at a.f.m.x() at a.f.l.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 a.f.m.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 a.f.e.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, aw A\_8, Boolean A\_9, DataTable A\_10, Int32 A\_11, String A\_12) at a.f.n.a(String A\_0, EmailAddressCollection A\_1) at a.f.n.a(Boolean A\_0, String A\_1, EmailAddressCollection A\_2) at a.f.n.a(Boolean A\_0) at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email) – 06/12/2016 15:13:10: Migrated projects list.log: Email successfully sent – 06/12/2016 15:13:10: Migrated projects list.log: Send\_Email\_1 - There were errors encountered sending the message. See the log file for details. – 06/12/2016 15:13:10: Migrated projects list.log: Continuing after error – 06/12/2016 15:13:10: Migrated projects list.log: Generating exception Email – 06/12/2016 15:13:10: Migrated projects list.log: Email message: Script Error Automation script “Migrated projects list” had errors while executing. The exception messages are listed below and the log file is attached. Continue on Error Exception Messages: Send\_Email\_1 - There were errors encountered sending the message. See the log file for details. Exception Messages: SocketException occurred. InnerException message follows: The requested name is valid, but no data of the requested type was found The requested name is valid, but no data of the requested type was found – 06/12/2016 15:13:10: Migrated projects list.log: Setting up SMTP email – 06/12/2016 15:13:10: Migrated projects list.log: Email Attachment: C:\Users\dominic.cox\AppData\Roaming\Quest Software\Toad Data Point 3.3\Automation\Migrated projects list.log – 06/12/2016 15:13:10: Migrated projects list.log: Smtp Server: smtp.arqiva.local – 06/12/2016 15:13:10: Migrated projects list.log: Smtp Port: 25 – 06/12/2016 15:13:10: Migrated projects list.log: Begin email send – 06/12/2016 15:13:10: Migrated projects list.log: SocketException occurred. InnerException message follows: The requested name is valid, but no data of the requested type was found – 06/12/2016 15:13:10: Migrated projects list.log: The requested name is valid, but no data of the requested type was found – 06/12/2016 15:13:10: Migrated projects list.log: at a.ae.a(String A\_0) at a.ai.a(String A\_0) at a.m.a(String A\_0, Int32 A\_1, Boolean A\_2, Socket A\_3, EndPoint A\_4) at a.m.x() at a.f.l.x() at a.f.m.x() at a.f.l.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 a.f.m.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 a.f.e.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, aw A\_8, Boolean A\_9, DataTable A\_10, Int32 A\_11, String A\_12) at a.f.n.a(String A\_0, EmailAddressCollection A\_1) at a.f.n.a(Boolean A\_0, String A\_1, EmailAddressCollection A\_2) at a.f.n.a(Boolean A\_0) at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email) – 06/12/2016 15:13:10: Migrated projects list.log: Exception Email successfully sent ---
**Author:** ![Martin.Holkovic](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin.holkovic/32/318_2.png) [@Martin.Holkovic](https://forums.toadworld.com/u/Martin.Holkovic)\ **Post date:** [December 14, 2016, 1:43am UTC](https://forums.toadworld.com/t/toad-data-point-3-3-email-automation-error/38770/4 "2016-12-14T01:43:17Z")
Hi mark, Sorry for later response, I just now realized you’ve responded… Not sure why I didn’t receive notification of it. I’ve tried to search for this error message: “The requested name is valid, but no data of the requested type was found” and it seems the error is not related to the mail functionality itself but with invalid DNS settings - or at least the users on the internet say so. In order to narrow the problem further could you please confirm whether the user is able to send emails using the same credentials and smtp connection details in some other tool? For example Outlook? If yes then let him try this free portable “SMTP tester” app: [http://www.softpedia.com/get/PORTABLE-SOFTWARE/Internet/Servers/Portable-SMTP-Tester.shtml](http://www.softpedia.com/get/PORTABLE-SOFTWARE/Internet/Servers/Portable-SMTP-Tester.shtml) Martin ---
**Author:** ![mark.oliver](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mark.oliver](https://forums.toadworld.com/u/mark.oliver)\ **Post date:** [December 14, 2016, 7:43am UTC](https://forums.toadworld.com/t/toad-data-point-3-3-email-automation-error/38770/5 "2016-12-14T07:43:47Z")
Hi Martin, Our network team confirmed that SMTP traffic was not leaving his laptop, but we have been able to test that the port is open using the Telnet client. Outlook works fine for him. The user is back from leave and we are going to look at upgrading him as he would like the upgrade anyway. I can troubleshoot further once we’ve done that. Thanks for your help and suggestions. Cheers Mark