Base solution for your next web application
Open Closed

Duplicate key values on AbpUserLogins table #11999


User avatar
0
wilson.wong created

What is your product version? 12.4

What is your product type (Angular or MVC)? Angular

What is product framework type (.net framework or .net core)? .Net Core

We are having an issue with duplicate records being created on the AbpUserLogins table with the same ProviderKey. We have users who are using our application that undergo a change in their user information (be it an email address that changes or their surname changes). We delete their existing record in the AbpUsers table and have a new record created with their new information. When they go back in to login to the application, a new record is created in the AbpUserLogins table with the same the ProviderKey that was used by their previous user account.

As a result of these duplicate records, we have run into a few issues.

  1. These users cannot login to the application until we delete the duplicate entry in the AbpUserLogins table

  2. When we run new migrations, they will fail until we delete all duplicate records in the AbpUserLogins table (e.g. An example error message - "Microsoft.Data.SqlClient.SqlException (0x80131904): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.AbpUserLogins' and the index name 'IX_AbpUserLogins_ProviderKey_TenantId'. The duplicate key value is ......"


1 Answer(s)