November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Duplicate users in CMS possible causing exception
Hi Tim,
Could I ask which membership provider you are using? SQL, AspNetIdentity, AAD, etc?
Thanks
Paul
Jul 17, 2023 16:18
Tim Schmelter
- Jul 17, 2023 18:18
We're using AspNet Identity with OpenIdConnect and ForgeRock. So the users are in the table AspNetUsers. It's working without issues since december 2021.
I thought it would be enough to delete them there with;
DELETE FROM AspNetUsers WHERE UserName = 'username'
Now i have used the sql profiler to see what Epi does when i delete a user. Maybe this should work?
DECLARE @username NVARCHAR(4000) = N'username';
exec netContentAclDeleteEntity @Name=@username,@IsRole=0
exec netPermissionDeleteMembership @Name=@username,@IsRole=0
DELETE [dbo].[AspNetUsers] WHERE LOWER(UserName)=@username
DELETE [dbo].[Profiles] WHERE UserId = (SELECT UserId FROM [dbo].[Users] WHERE LOWER(UserName)=@username)
DELETE [dbo].[Users] WHERE LOWER(UserName)=@username
DELETE FROM [dbo].[tblBigTableIdentity] WHERE PkId=(SELECT pkId FROM dbo.tblSystemBigTable WHERE LOWER(String01)=@username)
DELETE FROM [dbo].[tblSystemBigTable] WHERE LOWER(String01)=@username
I thought it would be enough to delete them there with;
DELETE FROM AspNetUsers WHERE UserName = 'username'
Now i have used the sql profiler to see what Epi does when i delete a user. Maybe this should work?
DECLARE @username NVARCHAR(4000) = N'username';
exec netContentAclDeleteEntity @Name=@username,@IsRole=0
exec netPermissionDeleteMembership @Name=@username,@IsRole=0
DELETE [dbo].[AspNetUsers] WHERE LOWER(UserName)=@username
DELETE [dbo].[Profiles] WHERE UserId = (SELECT UserId FROM [dbo].[Users] WHERE LOWER(UserName)=@username)
DELETE [dbo].[Users] WHERE LOWER(UserName)=@username
DELETE FROM [dbo].[tblBigTableIdentity] WHERE PkId=(SELECT pkId FROM dbo.tblSystemBigTable WHERE LOWER(String01)=@username)
DELETE FROM [dbo].[tblSystemBigTable] WHERE LOWER(String01)=@username
have you established if there's duplicate entries in the database?
Is the issue occuring for one of your users or all your users?
Jul 17, 2023 17:01
Tim Schmelter
- Jul 17, 2023 18:20
There is no duplicate user(in AspNetUsers) but there is a duplicate key in an Epi dictionary if i call the user's profile page in CMS. So you cannot edit or delete these users(2 had the issue). So some´where the profile data is corrupt.
Surjit Bharath
- Jul 19, 2023 20:18
Since forgerock is a federated authentication provider...by any chance has the customer registered twice through two different IDPs? I don't know what the key dictionary is using (I'm assuming its email or maybe a composite) but maybe that's what's knocking it out?
It seems to be possible to create duplicate users. We have 2 users which cause a 500 if you try to look at their user-profile(Admin>Search user/group>click):
I have tried to delete these users:
But the customer reported the same issue again after he re-created that user later.
What is causing this issue and how to prevent it? It's obvious that Epi tries to add a key twice to the dictionary, but what key and where is it stored?