TOAD Data Point 3.3 Email automation error

mark.oliver · December 6, 2016, 6:46am

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

Martin.Holkovic · December 6, 2016, 7:05am

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

mark.oliver · December 9, 2016, 2:36am

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, From: Dominic.Cox@arqiva.com, cc: 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

Martin.Holkovic · December 14, 2016, 1:43am

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

Martin

mark.oliver · December 14, 2016, 7:43am

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