Dynamics Community Forum Thread Details

econnect exception:"an item with same key has been already added"

We are using GP 2010 sp2/r2(11.00.1752) version.When I am processing below xml(project accounting) to econnect.

</eConnectProcessInfo>

<taPAEmpExpenseLineInsert_Items>

<PAPROJNUMBER>CAG-REGEXP-ZU</PAPROJNUMBER>

<PAitemnumber>Lokales</PAitemnumber>

</taPAEmpExpenseLineInsert>

<PAPROJNUMBER>CAG-REGEXP-ZU</PAPROJNUMBER>

<PAitemnumber>Lokales</PAitemnumber>

</taPAEmpExpenseLineInsert>

- <taPAEmpExpenseLineInsert>

<PAPROJNUMBER>CAG-REGEXP-ZU</PAPROJNUMBER>

<PAitemnumber>Lokales</PAitemnumber>

</taPAEmpExpenseLineInsert>

</taPAEmpExpenseLineInsert_Items>

<BACHNUMB>PADBASICS101811</BACHNUMB>

</taPAEmpExpenseHdrInsert>

</PAProjectsType>

</eConnect>

I am getting the econnect exception as below:

Exception Message: " An item with the same key has already been added".

Stack Trace:

at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)
   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String connectionString, String sXML)

Can any one help me to troubleshoot this issue.

Hello,

I am having the same issue. When I use the functional currency the transaction integrates fine, when I use a non functional currency I receive this issue. The funny thing is, the only difference is the currency. I literally change my the currency column in my data source from one currency to another and i get the message, when I change it back the transaction is successful.

Have you tried executing the SQL stored procedures manually and seeing if you are returned any errors. I created an integration which directly executes the stored procedures, with identical values and I am able to integrate both functional and non functional currency transactions fine. I believe the problem is with the eConnect API.

Thanks

Kemal

Quick Links

Leaderboard