An item with the same key has already been added
This error is actually a result of Microsoft eConnect returning the same error multiple times. It usually happens when trying to integrate Analytical Accounting data but can happen on other nodes as well. The only way to find the actual error is to run a trace with Microsoft SQL Profiler to get the stored procedure call that is generating the error. Then execute that stored procedure separately to see if we can determine the actual error being returned.
I’m having my IT guy look into this, unless you could guide me on how to run a trace with SQL and find this error? thanks for the answer!
After testing the heck out of this error. The most common reason that triggers this message with is that the Gl account is not linked in the AA Account Class.
Hi, I have actually solved an issue of this instance after incorrectly assuming the document type node on the taAnalyticsDistribution procedure is the same as the PM Transaction. I changed the Document Type to 0 (PM Voucher for AA), then it worked like a charm.
This is a common error when importing AA dimensions. This has to do with the way eConnect inserts AA documents. It is saying it received the same error multiple times, but does not show you the actual error message.
You will need to run a SQL trace as Lorren outlined above to view the actual error message the eConnect encountered multiple times.
If you would like to submit an answer or comment, please sign in to the eOne portal.