-
Title
System.NullReferenceException”when viewing object in new window -
Description
Using SQL Query, viewing the object detail/data in another window generates error.
Created a SQL query and selected table to view details.
On the "data" tab trying to filter by the table columns returned error:
“Object reference not set to an instance of an object”.**********************************************************************
Exception Information
**********************************************************************
Exception: System.NullReferenceException
Message : Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.FilterContext_ContextChanging(Object sender, TrlContextChangedArgs args)
at Quest.Toad.Settings.TrlContextCollection.TrlContextChangedHandler.Invoke(Object sender, TrlContextChangedArgs args)
at Quest.Toad.Settings.TrlContextCollection.OnContextChanging(Object sender, TrlContextChangedArgs args)
at Quest.Toad.Settings.TrlContextCollection.set_Item(ITrl trl, Object value)
at Quest.Toad.Settings.FilterContextCollection.set_Item(ITrl trl, FilterInfo value)
at Quest.Toad.Filter.FilterEditor.ShowDialog(ITrl trl)
at Quest.Toad.Dov.TableDataViewControl.DefineFilter(Object sender, ItemClickEventArgs e) -
Cause
Corrupt file(s) in Application Data Directory.
-
Resolution
Do the following test to localize the problem. It may workaround the problem.
This will reset the Application Data Directory in Toad Data Point.
1. Go to Help | About …
2. In the lower right corner, click on the link: Application Data Directory. This will launch a Windows Explorer. Click OK to close this window.
3. Exit and close Toad Data Point.
4. In Windows Explorer, go up one folder to the Quest Software folder.
5. Rename the Toad Data Point <version> folder to Toad Data Point <version> BACKUP.
6. Launch Toad Data Point again.
7. A new Toad Data Point Application Data Directory default folder will be created.
8. Returning back to Toad Data Point, if applicable, you may be prompted with the Toad for Oracle Connections screen.
9. If you having a Toad for Oracle connection issues do NOT bring over your connections until the problem can be localized.
10. Select Do Not Import Legacy settings on start up.
11. Manually reconnect with Toad Data Point and determine if the problem still persists.