We were upgrading Dynamics CRM 2011 On-Premises to CRM 2013 On-Premises. As every CRM developer would be aware that CRM upgrades are never a smooth sailing ride.<\/p>\n
We stumbled upon an error while importing organization in Deployment Manager.<\/p>\n
The error we came across was,<\/p>\n
Violation of UNIQUE KEY constraint ‘UQ_LocalizedLabelCheck’. Cannot insert duplicate key in object ‘MetadataSchema.LocalizedLabel’. The duplicate key value is (e23fb506-2341-db11-898a-0007e9e17ebd, DisplayName, 1033, Jan\u00a0 1 1900 12:00AM, 0).<\/strong><\/p>\n Initially, we thought it would be the case of multiple languages in CRM 2011, but after investigating CRM 2011, it was not the case.<\/p>\n Once of the articles suggested this was planned to be addressed in an upcoming rollup. We decided to upgrade our CRM 2013 to the latest Rollup available i.e., Update Rollup 3.<\/p>\n Once it was upgraded to the latest rollup, importing the organization through the deployment manager, we still came across the same error.<\/p>\n The next step was to then upgrade CRM 2013 to SP1 and then retried the importing process.<\/p>\n BINGO<\/strong>!!! it worked.<\/p>\n Conclusion:<\/strong><\/p>\n Before upgrades, ensure that you have the latest rollup installed for the intermediary CRM versions to ensure the upgrade goes through smoothly.<\/p>\n You may also like to see :\u00a0User Adoption Metrics<\/a> that matter in your Dynamics CRM<\/span><\/em><\/p>\n","protected":false},"excerpt":{"rendered":" We were upgrading Dynamics CRM 2011 On-Premises to CRM 2013 On-Premises. As every CRM developer would be aware that CRM upgrades are never a smooth sailing ride. We stumbled upon an error while importing organization in Deployment Manager. The error we came across was, Violation of UNIQUE KEY constraint ‘UQ_LocalizedLabelCheck’. Cannot insert duplicate key in\u2026 Read More: Error Upgrading CRM 2011 On-Premises to CRM 2013 On-Premises »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,21,22,24,61],"tags":[243,702,1093,1791],"class_list":["post-2133","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm-2011","category-dynamics-crm-2013","category-dynamics-crm-2015","category-dynamics-crm-2016","category-upgrade","tag-cannot-insert-duplicate-key-in-object","tag-dynamics-crm-upgrade-error","tag-metadataschema-localizedlabel","tag-violation-of-unique-key-constraint"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t