Select the product you need help with

Error message when you create multiple users at the same time by using the Service.Create(user) method in Microsoft Dynamics CRM 4.0: "Cannot insert duplicate key"

Article ID: 971353 - View products that this article applies to.

SYMPTOMS

You want to create multiple Microsoft Dynamics CRM users at the same time. Therefore, you create multiple worker threads, and each worker thread uses the service.Create(user) method, as shown in the following example.

systemuser user = new systemuser();
service.Create(user);

However, if you run these threads on a computer that has multiple CPUs, you may receive the following error message:

0x80040237
Cannot insert duplicate key.

If you enable the Platform tracing function, you receive an error message that resembles the following:

CrmService.Create failed with an error "Restraint 'AKI_UserSettinsBase_TrackingTokenId' Unique KEY violation. Cannot import duplicate key.

RESOLUTION

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

949256

(http://support.microsoft.com/kb/949256/ )

Microsoft Dynamics CRM 4.0 updates and hotfixes