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.
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
is working on a reply...