Skip to content
+1-888-319-3663

COMMUNITY FORUM

A fault occurred when processing Create request, at index '#' in the request collection with a fault message: Cannot insert duplicate key

Alberto asked 6 years ago
I have created a Map that have the ODBC Connection data source and the Destination Type is Microsoft Dynamics CRM Bulk. When I process the data SmartConnect shows some errors like this: “A fault occurred when processing Create request, at index ‘#’ in the request collection with a fault message: Cannot insert duplicate key”. In addition, I have checked the “Ignore Duplicate Detection Rules” check box and into the SmartConnect Mapping I have checked the “Update existing” check box. Do you have any idea about how to troubleshooting this issue? Thanks!
Chris replied 6 years ago

Alberto,

I would change the destination type to just the regular Dynamics CRM destination in place of the Bulk option. That will at least give you slightly better messaging on the failure – as the regular option will send each record as a separate call to the web service,

Doing it that way, you should be able to see specifically what records failed and look at the data in those to see what might be causing it. That should get you closer to solving the issue by being able to isolate the failed records, but I haven’t received that message before so I am not sure what is causing it exactly.

H


If you would like to submit an answer or comment, please sign in to the eOne portal.