Reflection fails with "An item with the same key has already been added"

The failing code could be one of two things:

1. Duplicate entity id's
2. Duplicate container dn's

We can rule them out with the following:

1.

SELECT EntityId, COUNT(*)
FROM Entity
WHERE PartitionId = 'connector partition id'
GROUP BY EntityId
HAVING COUNT(*) > 1

2.

SELECT DistinguishedName, COUNT(*)
FROM Container
GROUP BY DistinguishedName
HAVING COUNT(*) > 1

One (or both) of those should bring something back as that's what's being checked in this method. However, it shouldn't actually be possible.

Neither of these queries returned any rows. 

That's interesting, as that's the two possibilities.

I can give some additional logging shortly if required. However, we should rule out the data first. Try using the Identity Broker id for the dn and see if it gets further.

Thanks.

Appears to have completed successfully.

Request to reflect change entities of the SharePoint Profiles (4e96758c-06c5-44dd-9f32-557b3e75d16f) adapter started.",Verbose
20170605,22:31:03,UNIFY Identity Broker,Changes register engine,Information,"Request to retrieve changes register context.
Request to retrieve changes register context started.",Verbose
20170605,22:31:03,UNIFY Identity Broker,Changes register engine,Information,"Request to retrieve changes register context.
Request to retrieve changes register context completed. Duration: 00:00:00",Verbose
20170605,22:31:03,UNIFY Identity Broker,Change log engine,Information,"Request to retrieve change log context.
Request to retrieve change log context started.",Verbose
20170605,22:31:03,UNIFY Identity Broker,Change log engine,Information,"Request to retrieve change log context.
Request to retrieve change log context completed. Duration: 00:00:00",Verbose
20170605,22:31:03,UNIFY Identity Broker,Adapter,Information,"Request to reflect change entities of the adapter.
Request to reflect change entities of the SharePoint Profiles (4e96758c-06c5-44dd-9f32-557b3e75d16f) adapter completed with 0 adds, 0 updates and 0 deletes across 0 pages. Duration: 00:00:00.0156221",Verbose

Is the adapter now populated with the correct number of entities?

I switched it back to how it's supposed to be configured and the error has returned. 

20170606,01:51:08,UNIFY Identity Broker,Adapter,Error,"Adapter
Adapter 4e96758c-06c5-44dd-9f32-557b3e75d16f page errored on page reflection. Duration: 00:00:00.8593748. Error: 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.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at Unify.Product.IdentityBroker.Adapter.ConvertPageAndUpdateContainers(IEntity[] entities, Boolean updateContainers)
   at Unify.Product.IdentityBroker.Adapter.ReflectChangesInner()
   at Unify.Product.IdentityBroker.Adapter.ReflectChanges()
   at Unify.Product.IdentityBroker.AdapterAuditingDecorator.ReflectChanges()
   at Unify.Product.IdentityBroker.AdapterNotifierDecorator.ReflectChanges()
   at Unify.Product.IdentityBroker.ReflectAdapterOnChangeDueJob.<RunBase>b__9_0(IOperationalAdapter adapter).
Error details:

What do you mean "how it's supposed to be configured"? When it was working was that with a different configuration? What's wrong with using the different configuration, is there a particular reason that you need the dn as the account name?

I'm performing a migration.  Not sure if it has to be configured this way. I don't understand everything that's happening in this solution as it's using Codeless framework which I know next to nothing about.  Using the AccountName as the DN is how it was configured and I am replicating that as closely as possible as I can.