Error message when you try to provision a language in Microsoft Dynamics CRM 4.0: "Cannot insert duplicate key row in object 'dbo.LocalizedLabel' with unique index 'ndx_LocalizedLabel_ForSingleSelect'"
This article has been archived. It is offered "as is" and will no longer be updated.
Consider the following scenario in Microsoft Dynamics CRM 4.0. In system customization, you remove some labels that contain a formXml string. You publish the customizations in Microsoft CRM 4.0. Next, you install a language pack. Then, you try to provision the language. In this scenario, you receive the following error message:
System.Web.Services.Protocols.SoapException: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.LocalizedLabel' with unique index 'ndx_LocalizedLabel_ForSingleSelect'. The statement has been terminated.
Note This problem is independent of the base language that you use and of the language that you want to provision.
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
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards