An item with the same key has already been added

Comments

• whatdoctorsknow Posts: 4

  January 7, 2014 2:25PM

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

  0 · Share on Twitter
• whatdoctorsknow Posts: 4

  January 7, 2014 2:40PM

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

  0 · Share on Twitter
• James B Redgate › Posts: 1,124 Silver 4

  January 7, 2014 3:03PM

  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?

  Systems Software Engineer

  Redgate Software

  0 · Share on Twitter
• Arsen01 Posts: 3 New member

  December 25, 2017 1:20PM

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

  0 · Share on Twitter