Options
An item with the same key has already been added
whatdoctorsknow
Posts: 4
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
An item with the same key has already been added
How do I fix the error.
Cheers
Luke
Comments
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,,
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,,
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?
Redgate Software