Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
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?