Red Gate forums :: View topic - An item with the same key has already been added
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Data Compare
MySQL Data Compare forum

An item with the same key has already been added

Search in MySQL Data Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
whatdoctorsknow



Joined: 07 Jan 2014
Posts: 3

PostPosted: Tue Jan 07, 2014 7:32 pm    Post subject: An item with the same key has already been added Reply with quote

Trying to use MySQL data compare trial. but when connecting to the source MySQL database, I get the following error.

An item with the same key has already been added

How do I fix the error.

Cheers
Luke
Back to top
View user's profile Send private message
whatdoctorsknow



Joined: 07 Jan 2014
Posts: 3

PostPosted: Tue Jan 07, 2014 8:25 pm    Post subject: Bug Report Reply with quote

This is the bug report

Bug report generated at 1/7/2014 12:14:24 PM

Program version 1.0.0.473


RedGate.Shared.Exceptions.DetailedPopulationException: An item with the same key has already been added. ---> System.ArgumentException: An item with the same key has already been added.

at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)

at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)

at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)

at #Rjmb.#VzD.Add(#NrPb item)

at #Rjmb.#AAD.Add(#NrPb item)

at #Rjmb.#yBD.#8WD()

at #Rjmb.#yBD.#vl()

--- End of inner exception stack trace ---

at #Rjmb.#yBD.#vl()

at #5jmb.#4jmb.#l7B(#yBD databasePopulator)

at #5jmb.#4jmb.#t.#v3.#HIM()

at RedGate.Shared.Controls.ProgressDialogEx.e()


Last field accessed: is_nullable returning a System.String value NO


Last 5 rows retrieved from database:

nmotest,CVX_MAP,cvx_code,,varchar(5),NO,varchar,5,,

nmotest,app_docotr_cpt_rule,cpt_id,,varchar(36),NO,varchar,36,,

nmotest,app_docotr_cpt_rule,clinic_id,,varchar(36),NO,varchar,36,,

nmotest,app_docotr_cpt_rule,modifiedById,,varchar(36),YES,varchar,36,,

nmotest,app_docotr_cpt_rule,createdById,,varchar(36),YES,varchar,36,,
Back to top
View user's profile Send private message
whatdoctorsknow



Joined: 07 Jan 2014
Posts: 3

PostPosted: Tue Jan 07, 2014 8:40 pm    Post subject: Bug Report Reply with quote

Bug report generated at 1/7/2014 12:40:13 PM
Program version 1.0.0.473

RedGate.Shared.Exceptions.DetailedPopulationException: An item with the same key has already been added. ---> System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at #Rjmb.#VzD.Add(#NrPb item)
at #Rjmb.#AAD.Add(#NrPb item)
at #Rjmb.#yBD.#8WD()
at #Rjmb.#yBD.#vl()
--- End of inner exception stack trace ---
at #Rjmb.#yBD.#vl()
at #5jmb.#4jmb.#l7B(#yBD databasePopulator)
at #5jmb.#4jmb.#t.#v3.#HIM()
at RedGate.Shared.Controls.ProgressDialogEx.e()

Last field accessed: is_nullable returning a System.String value NO

Last 5 rows retrieved from database:
nmotest,CVX_MAP,cvx_code,,varchar(5),NO,varchar,5,,
nmotest,app_docotr_cpt_rule,cpt_id,,varchar(36),NO,varchar,36,,
nmotest,app_docotr_cpt_rule,clinic_id,,varchar(36),NO,varchar,36,,
nmotest,app_docotr_cpt_rule,modifiedById,,varchar(36),YES,varchar,36,,
nmotest,app_docotr_cpt_rule,createdById,,varchar(36),YES,varchar,36,,
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1119
Location: My desk.

PostPosted: Tue Jan 07, 2014 9:03 pm    Post subject: Reply with quote

I don't have a MySQL instance handy to test with I'm afraid, but what's the comparison key set up as? I see that some of the columns listed in your "last 5 rows" have similar values.

I'm not familiar with the MySQL version of the tool, but our SQL Server data compare does need to uniquely identify the rows in each table via some sort of PK / Unique Index- perhaps whatever is being picked up as the comparison key in your case is not returning unique values?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group