The given key was not present in the dictionary.

• 
  Thank you for your post into the forum.
  
  I am unable to reproduce the reported problem. So a support call has been created for you, the call reference is F0024450.
  
  If possible, can you please export a SQL Compare snapshot of each data source and send a copies of the snapshot files to support@red-gate.com, quoting your call reference? (File Menu ->Create Snapshot)
  
  This will help to investigate your problem.
  
  Many Thanks
  Eddie

  Eddie D July 21, 2009 12:08

  - 0 +
• 
  Hi Eddie,
  
  Any updates on the cause of this problem?
  
  Thanks,
  Ondrej

  ondrej August 04, 2009 03:02

  - 0 +
• 
  This has happened one other time in this version of the software, and the cause of the problem was that the VIEW CHANGE TRACKING permission is not yet supported by SQL Compare. If you are using SQL 2008, this may be the problem if you have granted this permission to one of your database users or schemas.

  Brian Donahue August 04, 2009 10:49

  - 0 +
• 
  Brian,
  
  I've run a number of variations of "select * from fn_my_permissions(NULL, 'server') order by permission_name asc;" and the VIEW CHANGE TRACKING permission never came up. While I don't think we've explicitly granted this permission to anyone or anything, is there a foolproof way to find out?
  
  Can I download a previous version of SQL Compare that may not have this issue?
  
  Thanks,
  Ondrej

  ondrej August 11, 2009 15:33

  - 0 +
• 

  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
  

  Brian Donahue August 12, 2009 04:41

  - 0 +
• 
  Thanks, Brian. 0 rows are returned.

  ondrej August 12, 2009 12:14

  - 0 +
• 
  View Change Tracking must not be the problem then. I take it you have sent snapshot files to Eddie by email?

  Brian Donahue August 13, 2009 13:19

  - 0 +
• 
  I have. Eddie suspected my account was missing the VIEW SERVER STATE permission, but it wasn't. That's where we are now.

  ondrej August 13, 2009 13:23

  - 0 +
• 
  I wanted to update thread this in case anybody else gets this error.
  
  In this particular case, it seems that it was down to one of the database roles being corrupt.
  
  Dropping and recreating the role fixed the issue.

  Chris Auckland August 19, 2009 07:28

  - 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:17

  - 0 +
• 
  I'm having the same problem now, but with 8.50.25.11. Please advise!

  aspnerd May 04, 2011 12:04

  - 0 +
• 
  This error, like "object reference" errors, is generic and almost always caused by an environment-specific issue with the database. I'll have someone get in touch with you via email with troubleshooting steps.

  Brian Donahue May 04, 2011 12:38

  - 0 +

Add comment

Please sign in to leave a comment.