Toad World® Forums

3.8 Automation Email is not working

I have installed TDP 3.8 and now my automation emails do not work. I uninstalled 3.8 and then installed 3.7 and everything works fine. Below are my logs:

– 12/10/2015 6:00:14 AM: DCDM.log: Setting up environment
– 12/10/2015 6:00:14 AM: DCDM.log: Script run by Toad Data Point 3.8.0.575 as paulsm on DBBTBS9768CP1
– 12/10/2015 6:00:14 AM: DCDM.log: Build started
– 12/10/2015 6:00:14 AM: DCDM.log: Compiling script
– 12/10/2015 6:00:15 AM: DCDM.log: Start CompileWorkflow
– 12/10/2015 6:00:15 AM: DCDM.log: Before Compile
– 12/10/2015 6:00:21 AM: DCDM.log: Return from CompileWorkflow
– 12/10/2015 6:00:21 AM: DCDM.log: Workflow Compiled without Errors
– 12/10/2015 6:00:21 AM: DCDM.log: Build completed
– 12/10/2015 6:00:21 AM: DCDM.log: Create Workflow instance
– 12/10/2015 6:00:21 AM: DCDM.log: Started workflow instance
– 12/10/2015 6:00:23 AM: DCDM.log: Begin execution script activities
– 12/10/2015 6:00:23 AM: DCDM.log: Destination file name: C:\Documents and Settings\paulsm\My Documents\Jobs\Daily Reports\Daily CDM\remove\DCDM.accdb
– 12/10/2015 6:00:23 AM: DCDM.log: Destination folder name: C:\Documents and Settings\paulsm\My Documents\Jobs\Daily Reports\Daily CDM\remove
– 12/10/2015 6:00:24 AM: DCDM.log: File will be copied and not moved
– 12/10/2015 6:00:43 AM: DCDM.log: Copied file C:\Documents and Settings\paulsm\My Documents\Jobs\Daily Reports\Daily CDM\DCDM.accdb to C:\Documents and Settings\paulsm\My Documents\Jobs\Daily Reports\Daily CDM\remove\DCDM2015-12-10.accdb
– 12/10/2015 6:00:44 AM: DCDM.log: Copy File finished, click DCDM2015-12-10.accdb to view file.
– 12/10/2015 6:00:44 AM: DCDM.log: Start run program Run_1
– 12/10/2015 6:00:45 AM: DCDM.log: Run_1 did not respond to idle. Unable to change window state.
– 12/10/2015 6:00:45 AM: DCDM.log: Return Code variable “Run_1_RCODE” set to 0 (00000000)
– 12/10/2015 6:00:45 AM: DCDM.log: Run_1 finished execution with return code 0 (00000000)
– 12/10/2015 6:00:46 AM: DCDM.log: Pausing for 600 seconds
– 12/10/2015 6:10:46 AM: DCDM.log: Done pausing
– 12/10/2015 6:10:46 AM: DCDM.log: Send email
– 12/10/2015 6:10:46 AM: DCDM.log: Email To: MaryNet@BaylorHealth.edu;donnak@BaylorHealth.edu;Jennifer.Carter@baylorhealth.edu;Casin.Hiller@baylorhealth.edu;Chianti.Moore@baylorhealth.edu; Casey.Chimento@baylorhealth.edu, From: PaulSm@BaylorHealth.edu, cc: PaulSm@BaylorHealth.edu;Jessica.Harrod@baylorhealth.edu; Sarah.Carrell@baylorhealth.edu
– 12/10/2015 6:10:46 AM: DCDM.log: Email Subject: Daily CDM Change and Validation Report
– 12/10/2015 6:10:47 AM: DCDM.log: Email message:

Hi everyone, please find the new daily CDM change and validation report at the following link:

 

Daily CDM Change Reports

 

Thanks,

Paul

 

Paul T. Smith, MBA, CPA

Senior Financial Analyst, Revenue Cycle Analytics � NTX | Strategic Financial Services

2001 Bryan Street, Suite 2700 | Dallas, TX 75201

214-820-3243 Office | 214-820-8245 Fax

paulsm@baylorhealth.edu

 

This electronic transmission contains information that should be considered confidential and privileged.  The information is intended only for the use of the individual (s) named above.  If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of this information is prohibited.  If you have received this transmission in error, please notify Paul T. Smith, MBA, CPA, Strategic Financial Services, Baylor Scott & White Health, by telephone at (214) 820-3243 or e-mail (paulsm@baylorhealth.edu).  Baylor Scott & White Health, its subsidiaries and affiliates, hereby claim all applicable privileges related to the transmission of this communication.

– 12/10/2015 6:10:47 AM: DCDM.log: Setting up SMTP email
– 12/10/2015 6:10:47 AM: DCDM.log: Smtp Server: mailrelay.bhcs.pvt
– 12/10/2015 6:10:47 AM: DCDM.log: Smtp Port: 25
– 12/10/2015 6:10:48 AM: DCDM.log: UserName: paulsm
– 12/10/2015 6:10:48 AM: DCDM.log: Begin email send
– 12/10/2015 6:10:48 AM: DCDM.log: None of the specified authentication methods is supported by the server.
– 12/10/2015 6:10:48 AM: DCDM.log: at a.a5.a(AuthenticationMethods A_0, AuthenticationMethods A_1, SaslMethod A_2, AuthenticationOptions A_3, String A_4, String A_5, String A_6, String A_7)
at a.m.a(AuthenticationMethods A_0, AuthenticationMethods A_1, SaslMethod A_2, AuthenticationOptions A_3, String A_4, String A_5, String A_6, String A_7)
at a.m.b()
at a.f.l.b()
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)
– 12/10/2015 6:10:49 AM: DCDM.log: Email_1 - There were errors encountered sending the message. See the log file for details.

– 12/10/2015 6:10:49 AM: DCDM.log: Start error email
– 12/10/2015 6:10:49 AM: DCDM.log: Email To: PaulSm@BaylorHealth.edu, From: PaulSm@BaylorHealth.edu, cc:
– 12/10/2015 6:10:50 AM: DCDM.log: Email Subject: Automation Script Error
– 12/10/2015 6:10:50 AM: DCDM.log: Generating exception Email
– 12/10/2015 6:10:50 AM: DCDM.log: Email message: The CDM change report had an error.

Automation script “DCDM” had errors while executing. The exception messages are listed below and the log file is attached.

Exception Messages:
None of the specified authentication methods is supported by the server.
Email_1 - There were errors encountered sending the message. See the log file for details.

– 12/10/2015 6:10:50 AM: DCDM.log: Setting up SMTP email

– 12/9/2015 4:11:07 PM: SVC.log: Setting up environment
– 12/9/2015 4:11:07 PM: SVC.log: Script run by Toad Data Point 3.8.0.575 as paulsm on DBBTIS3MBKBZ1
– 12/9/2015 4:11:07 PM: SVC.log: Build started
– 12/9/2015 4:11:07 PM: SVC.log: Compiling script
– 12/9/2015 4:11:07 PM: SVC.log: Start CompileWorkflow
– 12/9/2015 4:11:07 PM: SVC.log: Before Compile
– 12/9/2015 4:11:10 PM: SVC.log: Return from CompileWorkflow
– 12/9/2015 4:11:10 PM: SVC.log: Workflow Compiled without Errors
– 12/9/2015 4:11:10 PM: SVC.log: Build completed
– 12/9/2015 4:11:10 PM: SVC.log: Create Workflow instance
– 12/9/2015 4:11:10 PM: SVC.log: Started workflow instance
– 12/9/2015 4:11:10 PM: SVC.log: Begin execution script activities
– 12/9/2015 4:11:10 PM: SVC.log: Start run program Run_SVC_MACRO
– 12/9/2015 4:11:10 PM: SVC.log: Run_SVC_MACRO did not respond to idle. Unable to change window state.
– 12/9/2015 4:11:10 PM: SVC.log: Return Code variable “Run_SVC_MACRO_RCODE” set to 0 (00000000)
– 12/9/2015 4:11:10 PM: SVC.log: Run_SVC_MACRO finished execution with return code 0 (00000000)
– 12/9/2015 4:11:10 PM: SVC.log: Pausing for 240 seconds
– 12/9/2015 4:15:10 PM: SVC.log: Start run program Run_SVC1
– 12/9/2015 4:15:10 PM: SVC.log: Run_SVC1 did not respond to idle. Unable to change window state.
– 12/9/2015 4:15:10 PM: SVC.log: Run_SVC1 Out Message 2: C:\Users\paulsm\Documents\Jobs\Monthly Reporting\SVC>copy “C:\Documents and Settings\paulsm\My Documents\Jobs\Monthly Reporting\SVC\zTemp*.pdf” “K:\PAULS REPORTS\Service Line Reports”
– 12/9/2015 4:15:10 PM: SVC.log: Run_SVC1 Out Message 3: C:\Documents and Settings\paulsm\My Documents\Jobs\Monthly Reporting\SVC\zTemp\BSW - NTM Service Line Dashboard 201511 Created 20151209.pdf
– 12/9/2015 4:15:11 PM: SVC.log: Run_SVC1 Out Message 4: 1 file(s) copied.
– 12/9/2015 4:15:11 PM: SVC.log: Run_SVC1 Out Message 6: C:\Users\paulsm\Documents\Jobs\Monthly Reporting\SVC>move “C:\Documents and Settings\paulsm\My Documents\Jobs\Monthly Reporting\SVC\zTemp*.pdf” “C:\Documents and Settings\paulsm\My Documents\Jobs\Monthly Reporting\SVC\zReports”
– 12/9/2015 4:15:11 PM: SVC.log: Run_SVC1 Out Message 7: C:\Documents and Settings\paulsm\My Documents\Jobs\Monthly Reporting\SVC\zTemp\BSW - NTM Service Line Dashboard 201511 Created 20151209.pdf
– 12/9/2015 4:15:11 PM: SVC.log: Run_SVC1 Out Message 8: 1 file(s) moved.
– 12/9/2015 4:15:11 PM: SVC.log: Run_SVC1 Out Message 10: C:\Users\paulsm\Documents\Jobs\Monthly Reporting\SVC>taskkill /im excel.exe
– 12/9/2015 4:15:11 PM: SVC.log: Run_SVC1 Out Message 11: SUCCESS: Sent termination signal to the process “EXCEL.EXE” with PID 3724.
– 12/9/2015 4:15:11 PM: SVC.log: Return Code variable “Run_SVC1_RCODE” set to 0 (00000000)
– 12/9/2015 4:15:11 PM: SVC.log: Run_SVC1 finished execution with return code 0 (00000000)
– 12/9/2015 4:15:11 PM: SVC.log: Send email
– 12/9/2015 4:15:11 PM: SVC.log: SocketException occurred. InnerException message follows: An attempt was made to access a socket in a way forbidden by its access permissions 192.168.143.60:25
– 12/9/2015 4:15:11 PM: SVC.log: An attempt was made to access a socket in a way forbidden by its access permissions 192.168.143.60:25
– 12/9/2015 4:15:11 PM: SVC.log: at a.ae.a(Exception A_0)
at a.ae.a(IPEndPoint A_0)
at a.ai.a(IPEndPoint A_0)
at a.p.a(IPHostEntry A_0, Int32 A_1)
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)
– 12/9/2015 4:15:11 PM: SVC.log: SVC_Email_1 - There were errors encountered sending the message. See the log file for details.

– 12/9/2015 4:15:11 PM: SVC.log: Start error email
– 12/9/2015 4:15:11 PM: SVC.log: SocketException occurred. InnerException message follows: An attempt was made to access a socket in a way forbidden by its access permissions 192.168.143.60:25
– 12/9/2015 4:15:11 PM: SVC.log: An attempt was made to access a socket in a way forbidden by its access permissions 192.168.143.60:25
– 12/9/2015 4:15:11 PM: SVC.log: at a.ae.a(Exception A_0)
at a.ae.a(IPEndPoint A_0)
at a.ai.a(IPEndPoint A_0)
at a.p.a(IPHostEntry A_0, Int32 A_1)
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)
– 12/9/2015 4:15:11 PM: SVC.log: ExceptionEmail - There were errors encountered sending the message. See the log file for details.

– 12/9/2015 4:15:11 PM: SVC.log: Failed

I made QAT-6897 for us to look into this. I noticed the logs mentioned the lack of permissions. Were you running as admin in 3.8 and 3.7?

I see this and this in the files.

12/10/2015 6:10:48 AM: DCDM.log: None of the specified authentication methods is supported by the server.

An attempt was made to access a socket in a way forbidden by its access permissions 192.168.143.60:25

You need to get with your IT department and see how SMTP is configured. I will cancel QAT-6897 as this is on your end.