What are the challenges you face when working across database platforms? Take the survey
Options

Unable to refresh or cache database item has already been ad

dlydly Posts: 2
edited October 31, 2007 2:31PM in SQL Prompt Previous Versions
SQL 2000 - 8.00.2039
SQL Prompt 3.6.0.109
SQL Management Studio - 9.00.3042.00

Getting the following error on one of my databases when I try to refresh cache:

Unable to refresh or cache database [siebel].[KIDSPROD] due to the following error: Item has already been added. Key in dictionary: 'cmeyer' Key being added: 'cmeyer'.

RedGate.SqlPrompt.Engine.Cache.DatabaseRefreshException: Unable to refresh or cache database [siebel].[KIDSPROD] due to the following error: Item has already been added. Key in dictionary: 'cmeyer' Key being added: 'cmeyer'. ---> System.ArgumentException: Item has already been added. Key in dictionary: 'cmeyer' Key being added: 'cmeyer'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at System.Collections.Specialized.HybridDictionary.Add(Object key, Object value)
at RedGate.SQLCompare.Engine.SerializableCollection.Add(Object value)
at _12._25(SqlConnection )
at _12._1(_11 )
at RedGate.SQLCompare.Engine.Database.RegisterForSqlPrompt(ConnectionProperties connectionProperties, Options options, Boolean includeSystemObjects)
at _181._2(IAuthenticationTokenProvider )
--- End of inner exception stack trace ---
at _181._2(IAuthenticationTokenProvider )
at _181.Refresh(IAuthenticationTokenProvider provider)
at _35.DoTask()

I have dropped and re-added the user account but still getting the same error.
Sign In or Register to comment.