-
Title
ExceptionTrace.log file grows to gigabytes with error: "Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation" -
Description
My ExceptionTrace.log file is in gigabytes size with the following error repeating over and over again:
System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
Stack trace:at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at Quest.Toad.Util.Global.Invoke(Delegate handler, Object[] args)
at Quest.Toad.Gui.Confirmations.ConfirmationForm.Show(String text, ConfParam[] parameters)
at Quest.Toad.Gui.Confirmations.ConfirmationForm.Show(ConfirmationButtons buttons, Icon icon, String caption, String text)
at Quest.Toad.Db.Connection.AddStartupScript(String filename) -
Cause
Overlapping scheduled jobs not handled properly in older versions of Toad Data Point (formally known as Toad for Data Analysts). -
Resolution
RESOLUTION:
1. Save a backup copy of the automation script (.tas) and delete any and all scheduled tasks in the Job Manager within Toad.
2. Ensure that the jobs no longer appear in Windows Task Scheduler.
3. Download and install the latest version of Toad Data Point here.
4. When Toad is installed, it will automatically convert the automation scripts to be compatible with newer version of Toad; then create a new schedule task within the latest version of Toad Data Point.
-
Additional Information
If multiple task are being run, try scheduling so that there is no overlap, especially if the tasks take a while to run.