Error when comparing: "The given key was not present in ..."

• 
  In one similar case, it seems that it was down to one of the database roles being corrupt.
  
  Dropping and recreating the role fixed the issue.
  
  Can you check this out please?

  Chris.Allen August 21, 2009 10:50

  - 0 +
• 
  Yes, I read the other thread and tried that before posting. No luck.
  
  Also, the fact that it works in an older version of SQL Compare to me says it is some form of regression...

  Decorum August 21, 2009 12:43

  - 0 +
• 
  Could you please run:
  
  SELECT CAST(0 AS INT) AS ColumnPermissionID, sp.grantee_principal_id as uid, su.name AS UserName,
  OBJECT_NAME(sp.major_id) AS ObjectName,
  SCHEMA_NAME(so.schema_id) AS ObjectOwner,
  1 AS class, sp.type, sp.state,
  so.type AS ObjectType,
  CONVERT(int, null) as columns
  FROM sys.database_permissions AS sp WITH (NOLOCK) INNER JOIN sys.sysusers su WITH (NOLOCK) ON su.uid=sp.grantee_principal_id INNER JOIN sys.objects so WITH (NOLOCK) ON so.object_id=sp.major_id WHERE sp.major_id>0 AND sp.class = 1 AND sp.minor_id = 0 AND (sp.type in ('IN','DL','EX') OR CHARINDEX(sp.type, 'CRFNCRTBCRDBCRVWCRPRBADBCRDFBALOCRRU')%4 > 0) AND so.schema_id IS NOT NULL AND sp.type='VWCT'
  GROUP BY sp.major_id, sp.grantee_principal_id, sp.grantor_principal_id, sp.type, sp.state, so.type, su.name, so.schema_id
  
  
  
  If anything is returned, the problem is that in SQL 2008, we do not support the View Change Tracking user right.

  Chris.Allen August 24, 2009 13:41

  - 0 +
• 
  Ran the query, but it returns nothing.

  Decorum August 26, 2009 13:25

  - 0 +
• 
  You know, if you provided a way to display a stack trace of that exception, perhaps you could actually track it down instead of trying to guess? Just a thought...

  Decorum August 26, 2009 13:31

  - 0 +
• 
  Yes, that would be nice, for a start. There is no foolproof way of tracking down system-level exceptions in SQL Compare, so we usually start with the known issues.
  
  You can get the stack by looking at the SQL Compare logs using the icon in the upper-left of the window title bar. We probably need the stack, though, because the code is heavily obfuscated and we need to compare the methods on the stack to our obfuscation report.

  Brian Donahue August 27, 2009 04:14

  - 0 +
• 
  Just to say - if you can get that information, please send it to support@red-gate.com (with subject: F0025768). I have opened a support ticket for this already.

  Chris.Allen September 04, 2009 09:47

  - 0 +
• 
  I've sent the log information in an email as requested. Will post it here too for reference:
  
  16:16:02.791|Info |Logging |1 |Current Logging levels enabled: Warning,Fatal,Error
  16:16:29.458|Error |SQL Compare UI |1 |Exception in progress dialog
  System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
  at System.ThrowHelper.ThrowKeyNotFoundException()
  at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
  at S..ctor(Permissions permissions, Permissions targetPermissions, Options options)
  at RedGate.SQLCompare.Engine.Permissions.a(Permissions , Options )
  at RedGate.SQLCompare.Engine.Schema.Equals(IDatabaseObject target, Options options)
  at RedGate.SQLCompare.Engine.Database.a[a](Differences , IDatabaseObjects`1 , IDatabaseObjects`1 , Options , SQLVersion , Int64 , Int64& , Int32& , L )
  at RedGate.SQLCompare.Engine.Database.CompareWith(Database targetDatabase, Options options, SqlCompareOwnerMappings mappings)
  at ap.DoCompareDatabases()
  at RedGate.Shared.Utils.ProgressTasks.ProgressTask.a()
  at RedGate.Shared.Controls.ProgressDialogEx.e()

  Decorum September 04, 2009 10:22

  - 0 +
• 
  Hi,
  
  We have an update to SQL Compare to fix the "key was not present in the dictionary" error when it is caused by a schema or user that has the "View Change Tracking" permission granted or revoked. If you have this problem, please download the updated installation from here:
  http://www.red-gate.com/messageboard/vi ... php?t=9860
  
  Please be aware that this is not an "official" release and may have unintended side-effects, so do not install the update unless you specifically have the issue mentioned above!

  Brian Donahue October 23, 2009 12:16

  - 0 +
• 
  I get the same error as that reported by Decorum.
  I ran the TSQL suggested by Chris.Allen on 24 Aug 2009 17:41; no rows were returned.
  Log follows:
  
  System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
  at System.ThrowHelper.ThrowKeyNotFoundException()
  at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
  at S..ctor(Permissions permissions, Permissions targetPermissions, Options options)
  at RedGate.SQLCompare.Engine.Permissions.a(Permissions , Options )
  at RedGate.SQLCompare.Engine.Schema.Equals(IDatabaseObject target, Options options)
  at RedGate.SQLCompare.Engine.Database.a[a](Differences , IDatabaseObjects`1 , IDatabaseObjects`1 , Options , SQLVersion , Int64 , Int64& , Int32& , L )
  at RedGate.SQLCompare.Engine.Database.CompareWith(Database targetDatabase, Options options, SqlCompareOwnerMappings mappings)
  at ap.DoCompareDatabases()
  at RedGate.Shared.Utils.ProgressTasks.ProgressTask.a()
  at RedGate.Shared.Controls.ProgressDialogEx.e()
  
  Does this indicate that the "key was not present in the dictionary" I am experiencing is caused by a schema or user that has the "View Change Tracking" permission granted or revoked?

  anildas December 08, 2009 15:22

  - 0 +
• 
  Hello,
  
  The stack trace you have posted is identical to the one that you get if you have the "view change tracking" bug. I'd try the update mentioned in the previous post.

  Brian Donahue December 14, 2009 11:18

  - 0 +
• 
  has the patch mentioned a couple of post earlier been removed? if so, where can it be found as i have run across the same error. thx!

  jg4smile January 21, 2010 15:00

  - 0 +
• 
  the latest cummulative patch resolves the issue. thanks red-gate support (eddie).

  jg4smile January 21, 2010 15:27

  - 0 +

Add comment

Please sign in to leave a comment.