SharePoint 2013: User Information List Corrupted

Question

Hi,

i have a huge problem with the UserInformation-List.

When i query the UIL for a certain person, i get multiple entries:

$i = $list.Items | where {$_["Account"] -eq "i:0#.w|knapp_logistik\xxx"} -> Count = 14

The first entry ( $i[0] ) is the correct account.

The others are all something else (same accountname, same email, ...) but with a weird ID like "1073741843":

I cannot delete this entries (Remove-SPUser), because SP cannot find this accounts. Also, if the SP wants to read from the UIL, the SQL-Server gets stuck in a transaction.
Only by killing this transaction, the SP will work again. I think the SP gets confused with these duplicates and got into an endless loop.

Does anybody have any clue, how to solve this problem (remove duplicates)?

Answer 1

Hi @TomasStessl-3946,

I suggest you can access the User Information List UI directly in browser by accessing this url to see if there are real duplicated account existed:

http://sitecollection/_catalogs/users/detail.aspx

Then click specific duplicated account and it should redirect to the page which can manage to delete this account like this:

And here is a blog which specify the cause of duplicated accounts in User Information List and the solution, you could refer it for more detailed information:

Find Duplicate Users in SharePoint User Information List