An Automation task, which was created with Toad for Data Analysis 1.0.1, does not work in v2.0 resulting in "Object reference not set to an instance of an object" error.
**********************************************************************
Exception Information
**********************************************************************
Exception: System.NullReferenceException
Message : Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.Automation.AutomationForm.CheckforEmailOnErrorWarning()
at Quest.Toad.Automation.AutomationForm.Engine_BuildCompleted(EngineEventArgs e)
at Quest.Toad.Workflow.Engine.Run(String fileName, WorkflowService[] services)
at Quest.Toad.Automation.AutomationForm.Test()
at Quest.Toad.Automation.AutomationForm.TestAutomationScript()
**********************************************************************
WORKAROUND:
Steps:
1) Open script in Toad for Data Analysis 2.0
2) Click on the database connection activity and right click.
3) Choose "Save as template" and give it a name. this will save the connection data and all activities associated to that connection in a template.
4) Close the automation script and shut down toad.
5) Open up Toad again and open a blank Automation window.
6) Add the template saved in step 3.
7) Save and run the new automation script.
This should correct things for all prior scripts. Toad may need to be shutdown and restart.
Note: The template does not save your unique names but will generate new defaults.
STATUS:
Waiting for fix in a future release of Toad for Data Analysis
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center