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 translations Article translations
Article ID: 971353 - View products that this article applies to.
Expand all | Collapse all

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 Microsoft Dynamics CRM 4.0 updates and hotfixes

Properties

Article ID: 971353 - Last Review: July 2, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft CRM Software Development Kit, when used with:
    • Microsoft Dynamics CRM 4.0
Keywords: 
kbfix kbexpertiseinter kbsurveynew kbmbsmigrate kbqfe KB971353

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com