Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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'"
Article ID: 948604 - View products that this article applies to.
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:
Note This problem is independent of the base language that you use and of the language that you want to provision.
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.
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:
(http://support.microsoft.com/kb/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:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
(http://support.microsoft.com/kb/887283/ )Microsoft Business Solutions CRM software hotfix and update package naming standards