When switching from Tables to Views section in object explorer, the Exception error appear:
"System.IndexOutOfRangeException
Index was outside the bounds of the array.
Stack Trace:
Server stack trace:
at Quest.Toad.Tri.SimpleExtraColumn.GetColumnValue(ITrl trl, FastRow row, Int32 currentExtraColumnIndex)
at Quest.Toad.Trl.BaseSqlTrl.AssignExtraColumn(FastRow row, ITrl trl)
at Quest.Toad.Trl.SqlTrl.FilterToTrls(FilterInfo info, FastTable table, Boolean bSorted, Int32 offset, Int32 maxCount)
at Quest.Toad.Trl.SqlTrl.GetFilteredTrls(FilterInfo info)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.ReadTrl(ITrl trl, Boolean& displayExpandIndicator)
Exception rethrown at [0]:
at Quest.Toad.Util.Global.RethrowKeepingStackTrace(Exception e)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.ReadTrl(ITrl trl, Boolean& displayExpandIndicator)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.updateContentTimer_Tick(Object sender, EventArgs e)
at System.Windows.Form.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
"
The error appears also when switching from TREELIST to DROPDOWN in Explorer option.
not enough cache memory
A corrupt file on User Settings Folder.
WORKAROUND:
1) Increase Volatile Memory
- Open Toad for SQL Server (TSS)
- Tool Menu | Options | Database | Cache
- On Volatile Cache section, select Clear Cache
- Increase the Maximum Volatile in-memory size (MB) to 50 MB.
2) Reset Toad for SQL Server (TSS) to the initial default clean settings with connection info
- Close TSS
- Browse to default folder C:\Users\<<User_Name>>\AppData\Roaming\Quest Software\Toad for SQL Server X.X where X.X is the version.
- Rename the folder to X.X to X.X_OLD, for example: Toad for SQL Server 6.7 to Toad for SQL Server 6.7.OLD
- Re-launch TSS
To manually migrate the connection history, bring the Connections.xml file from Toad for SQL Server X.X.OLD to the new Toad for SQL Server X.X folder.
