User receives this error message when launching Toad for SQL Server:
Exception: System.ArgumentException
Message : Item has already been added. Key in dictionary:
'sqlserver://user@databasename/TABLE/xxxxxxx' Key being added:
'sqlserver://user@databasename/TABLE/xxxxxxx'
Stack Trace:
at System.Collections.Hashtable.Insert(Object key, Object nvalue,
Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Quest.Toad.Cache.LiveCache.Initialize()
at Quest.Toad.Cache.FilterLiveCache..ctor(ITrl trl, Object data)
at Quest.Toad.SqlServer.Trl.TableListTrl.EncapsulateData(Object data)
at Quest.Toad.Trl.CachedTrl.FindLiveCache()
at Quest.Toad.Trl.CachedTrl..ctor(String trl)
at Quest.Toad.Trl.BackgroundCachedTrl..ctor(String trl, Connection
conn)
at Quest.Toad.SqlServer.Trl.BaseObjectModelTrl..ctor(String trl,
Connection conn, String name, ControlCreationCallback
ctrlCreationCallback, Object parentObjectRef)
at Quest.Toad.SqlServer.SqlServerScheme.GetITrlForTable(TrlParser
parser, String trl, Connection connection)
at Quest.Toad.SqlServer.SqlServerScheme.ImplementTrl(String trl,
Connection connection)
at Quest.Toad.Trl.TrlScheme.CreateTrl(String trl, Connection conn)
at
Quest.Toad.DatabaseBrowser.ObjectPaletteControl.CreateTypeTrl(String
type, Boolean activeType)
at
Quest.Toad.DatabaseBrowser.ObjectPaletteControl.set_CurrentSchema(String
value)
at
Quest.Toad.DatabaseBrowser.ObjectPaletteControl.schemaList_SelectedIndex
Changed(Object sender, EventArgs e)
at
DevExpress.XtraEditors.Repository.RepositoryItemComboBox.RaiseSelectedIn
dexChanged(EventArgs e)
at
DevExpress.XtraEditors.ComboBoxEdit.UpdatePopupEditValueIndex(Int32
prevIndex)
at DevExpress.XtraEditors.ComboBoxEdit.set_EditValue(Object va
Please follow these steps to resolve the problem:
1. Exit out of Toad.
2. Make sure that your Windows Explorer can view hidden files and folders.
3. Go to this directory C:\Documents and Settings\<user name folder>\Local Settings\Application Data\Quest Software.
4. Locate all of the folders that begin with 'Toad for SQL Server'
5. Rename each of the 'Toad for SQL Server' folders with 'OLD'. (Example 'Toad for SQL Server OLD', 'Toad for SQL Server 2.0 OLD', 'Toad for SQL Server Trial OLD', etc.)
6. Launch the Toad application.
7. When you launch Toad, do not migrate any of your settings. Simply click 'Cancel' and proceed through the initial configuration steps.
