System Activity "Send Email" TDP 5.06.97 crash

Toad Data Point & Toad Intelligence Central
1

hi all,

this new topic on "send email" activity because i 've found the reason why it crash :

-- 31/07/2019 19:41:19: Extraction_Cabinet_Full.log: Setting up SMTP email
-- 31/07/2019 19:41:19: Extraction_Cabinet_Full.log: Email Attachment: D:\Toad_Log\Extraction_Cabinet_Full.log
-- 31/07/2019 19:41:19: Extraction_Cabinet_Full.log: Smtp Server: smtp.f*****.com
-- 31/07/2019 19:41:20: Extraction_Cabinet_Full.log: Smtp Port: 25
-- 31/07/2019 19:41:20: Extraction_Cabinet_Full.log: Begin email send
-- 31/07/2019 19:41:20: Extraction_Cabinet_Full.log: IOException occurred. InnerException message follows: Could not find a part of the path 'C:\Users\admintask_toad\AppData\Roaming\Quest Software\Toad Data Point 5.0\Automation\MailBee_637001988802551651.txt'.
-- 31/07/2019 19:41:21: Extraction_Cabinet_Full.log: Could not find a part of the path 'C:\Users\admintask_toad\AppData\Roaming\Quest Software\Toad Data Point 5.0\Automation\MailBee_637001988802551651.txt'.
-- 31/07/2019 19:41:21: Extraction_Cabinet_Full.log: MailBee.MailBeeIOException - IOException occurred. InnerException message follows: Could not find a part of the path 'C:\Users\admintask_toad\AppData\Roaming\Quest Software\Toad Data Point 5.0\Automation\MailBee_637001988802551651.txt'.
at MailBee.Logger.b(Boolean A_0)
at MailBee.Logger.b(String A_0, String A_1, LogMessageType A_2, bc A_3)
at a.d.f.a(MailMessage A_0, String A_1, EmailAddressCollection A_2, DeliveryNotificationOptions A_3, Smtp8bitDataConversion A_4, Boolean A_5, Boolean A_6, Boolean A_7, SendFailureThreshold A_8, Int32 A_9, ae A_10, Boolean A_11, k A_12, String A_13, a A_14)
at a.d.n.b(String A_0, EmailAddressCollection A_1)
at a.d.n.a(Boolean A_0, String A_1, EmailAddressCollection A_2)
at Quest.Toad.Workflow.Activities.SendEmailActivity.SendMail(SmtpServer server, MailMessage email)

Inner exception:
stem.IO.DirectoryNotFoundException - **Could not find a part of the path 'C:\Users\admintask_toad\AppData\Roaming\Quest Software\Toad Data Point 5.0\Automation\MailBee_637001988802551651.txt'.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.StreamWriter.CreateFile(String path, Boolean append, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding)
at MailBee.Logger.b(Boolean A_0)

-- 31/07/2019 19:41:21: Extraction_Cabinet_Full.log: ExceptionEmail - There were errors encountered sending the message. See the log file for details.

To schedule scripts, for security reason, i must use a specific batch user, not the one who made Toad install.

After manually create "C:\Users\admintask_toad\AppData\Roaming\Quest Software\Toad Data Point 5.0\Automation" problem was solved...

Is it possible, for next release, to be able to set working temp directories for activities ?

Regards
Franck

2

All programs have to rely on a place to write to files. The users profile AppData directory has been established by the operating system for this use. Why does your environment disallow this? Is "admintask_toad" configured as a normal domain user?

We do have an option for changing the default directory for some of the larger files we write to disk. But the file you are referring to is just a log file generate by email only when you have verbose logging on in Automation. And even if you have regular automation logging on we still need to write to that directory.

3

Hi Debbie.

I know appdata directory, and no, the admintask_toad is not a normal user...
This specific user has only required rights to execute Toad automation scripts in restricted network area, can't create folders, and can't open user sessions in normal conditions... I understand now that i must set it like a normal user before use it with Toad...
I've already set specific directory in "Options", "script results" "Serialization Temp folder", but i didn't know that appdata folder was used for generate mails...
I've manually created missing folders and problem solved...
Anyway, i really love working with Data point, my favorite for many years ! I use to try a lot of things, sometimes working well, sometimes not.
Thanks again for reply !

Regards.

Franck