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

Decorum

Hello,

I am using the latest version 8.1.0.360. When comparing two databases, an error occurs during the step "Comparing". The error message displayed in the bottom of the dialog is "The given key was not present in the dictionary."

Tried the same comparison in older version 7.1.0.197 and it works without problems there.

Best regards,
Daniel Stolt

Chris.Allen

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?

Decorum

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...

Chris.Allen

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.

Decorum

Ran the query, but it returns nothing.

Decorum

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...

Brian Donahue

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.

Chris.Allen

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.

Decorum

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()

Brian Donahue

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!

anildas

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?

Brian Donahue

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.

jg4smile

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

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