An item with the same key has already been added

• 
  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,,

  whatdoctorsknow January 07, 2014 14:25

  - 0 +
• 
  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,,

  whatdoctorsknow January 07, 2014 14:40

  - 0 +
• 
  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?

  James B January 07, 2014 15:03

  - 0 +
• 
  hi all, my name is Arsen.......)) I am a new member here )) thanks for your post , nice to meet you all here, in this web site.........

  Arsen01 December 25, 2017 13:20

  - 0 +

Add comment

Please sign in to leave a comment.