Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • DJ 3 posts 74 karma points
    6 days ago
    DJ
    0

    Duplicate Key Violation - IX_umbracoExternalLogin_LoginProvider index on umbracoExternalLogin table

    Hi there,

    I am trying to test Azure AD integration. I have setup the App Registration and that obtained the Client Id, Secret Value and Authority. I am redirected back to Umbraco after authenticating. But I receive a 500 response error.

    The underpinning exception is below:

    An unhandled exception was thrown by the application.","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.umbracoExternalLogin' with unique index 'IXumbracoExternalLoginLoginProvider'. The duplicate key value is (Umbraco.oidc, 0000000c-0000-0000-0000-000000000000).\r\nThe statement has been terminated.

    IXumbracoExternalLoginLoginProvider index references the loginProvider and userOrMemberKey fields.

    How do I resolve the duplicate key error? I tried removing the existing record from the umbracoExternalLogin table, but that resulted in another error that I can't resolve. I created another post about that.

    Help on this would be appreciated.

    Thanks,

    DJ

Please Sign in or register to post replies

Write your reply to:

Draft