Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Duplicate Key Exception
Microsoft Dynamics CRM (Archived)

Duplicate Key Exception

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Installed a new server with Dynamics 365 CRM Version 9.0 in English, and installed additional languages.

When i try to enable a language get following error.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Cannot insert duplicate key exception when executing non-query: System.Data.SqlClient.SqlCommand Exception: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'cndx_PrimaryKey_Report'. Cannot insert duplicate key in object 'dbo.ReportBase'. The duplicate key value is (e589370b-4904-e911-a815-000d3a0b39d8, 0, Dec 20 2018 11:19AM).
The statement has been terminated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Duplicate Key Exception

    I have been given language packs for version 9 now, I have German, Spanish and Turkish.

    Let me know if you will like a copy.

  • Evert Jan van den Bosch Profile Picture
    Evert Jan van den B... 5 on at
    RE: Duplicate Key Exception

    Thanks for uploading the hotfix, really helpful!

  • Suggested answer
    SenD Profile Picture
    SenD 5 on at
    RE: Duplicate Key Exception

    This is actually fixed through KB4458112.  Thought their Feb release of v9 in MyVisualStudio had it.  Unfortunately its still not released and the version still says 9.0.2.3034.  This KB is not available publicly yet.  Reuploading if anyone needs it.  Since its not officially release yet, its recommended only for development, testing purposes.

    1drv.ms/.../s!AoNfZgIZgZoUgWBvs37STFNoNtti

  • nickmangioros Profile Picture
    nickmangioros 460 on at
    RE: Duplicate Key Exception

    I have the same issue trying to install the French Language pack 9.0.1.0000.0283

    let me know what Microsoft says.

  • Johnny Gong Profile Picture
    Johnny Gong 6,482 on at
    RE: Duplicate Key Exception

    Hi Whafiz,

    From my point of view, you could show MS ticket follow up engineer about the bug id and my post in the forum which must help you on the case process. We met more than two customers fixed the issue after they installed related hotfix.

    If there's any concern, pls no hesitate to contact me.

    Regards

    Johnny

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Duplicate Key Exception

    Hi Johny,

    Thank you for your email.

    I have a Microsoft ticket open for this issue, they have taken some logs off my server, and i'm waiting for there responce.

    Regards.

  • Suggested answer
    Johnny Gong Profile Picture
    Johnny Gong 6,482 on at
    RE: Duplicate Key Exception

    Dear All，

    This is a know issue that when activate language pack in V9 OP there will pop out the Duplicate Key / Duplicate Record issue.

    Bug: Can't enable language on Onpremise branch: Violation of PRIMARY KEY constraint... Cannot insert duplicate key in object....

    Currently I would suggest you to post a ticket for this issue and support engineer would give you a COD hotfix (must older than V9.0.2.3041) which is based on your D365 Server basic package language. Or you could contact me by private mail while I only have hotfix based on basic English and Chinese package.

    Hope the above info could find you.

    Best Regards

    Johnny

  • Suggested answer
    Rhett Clinton Profile Picture
    Rhett Clinton on at
    RE: Duplicate Key Exception

    Please ensure you have followed these steps.

    Install docs.microsoft.com/.../install-and-enable-a-language-pack

    Enable docs.microsoft.com/.../enable-languages

    If you are certain all steps followed correctly then I recommend opening a support ticket with Microsoft to resolve this.

  • Arun Vinoth Profile Picture
    Arun Vinoth 11,613 on at
    RE: Duplicate Key Exception

    Recommend you to create a MS support ticket.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans