Share via

"Cannot insert duplicate key row in object 'dbo.LocalizedLabel' with unique index ... ", when the clients try to go offline.

  • Article

Frequently in support, we are confronted with the following situation:

When the clients try to go offline, you get an error message:

"Cannot insert duplicate key row in object 'dbo.LocalizedLabel' with unique index 'ndx_LocalizedLabel_ForSingleSelect'"

This happens, because the base language of the server (CRM 4.0) is not the same as the base language of the client.

Note:

The language of Microsoft Dynamics CRM for Outlook must match the base language for the Microsoft Dynamics CRM implementation.

This is documented in the Microsoft Dynamics CRM 4.0 Language Pack Readme:

https://download.microsoft.com/download/2/0/6/206eba30-9eba-44a7-bcce-ea76f7845262/Microsoft_Dynamics_CRM_4.0_Language_Pack_Readme.htm

 

We can solve this issue, by following these steps:

  1. Uninstall both Microsoft Dynamics CRM for Outlook and the local instance of Microsoft SQL Server 2005.
  2. Then reinstall Microsoft Dynamics CRM for Outlook using the base language.
  3. After you install Microsoft Dynamics CRM for Outlook in the base language, you can install Language Packs on the computer that is running Microsoft Dynamics CRM for Outlook to enable additional languages for the user interface and Help.

Note:

Installing a Microsoft Dynamics CRM Language Pack on the computer that is running Microsoft Dynamics CRM for Outlook does not change the language settings for the Office Outlook user interface or Help - only for labels, controls, and Help unique to Microsoft Dynamics CRM.

For more information about how to enable additional languages in Outlook, refer to the Outlook documentation.

 

Greetings from the CRM team.