Friday, October 10, 2014
The file exists. (Exception from HRESULT: 0x80070050): Adding users to SharePoint
Issue: When adding a user to the site we are getting error The file exists.
Error: The file exists. (Exception from HRESULT: 0x80070050)
Background: We had some users migrated from one domain to another and this is an issue with one of those users.
Site admin confirmed that user is migrated correctly and getting above error once adding user to the site.
We tried to add the user from our side and we were also getting the issue.
Tried to add the user on another side and was having the issue.
Checked in Active directory if user had valid account created.
Checked in User profile if user account entry exists.
Able to find the user in People picker and working fine.
The moment we click Ok, we get the error message.
Tried to delete the user site using PowerShell and re-added him, did not help.
It seems to be an orphan entry of the user old account exist on the site
Started looking at content DB with SQL queries.
select s.Id, w.FullUrl from Sites s inner join Webs w on
s.RootWebId = w.Id
select * from UserInfo where tp_Login='domain\username' and
Deleted user entry form UserInfo table in SP content db.
delete from UserInfo where tp_Login= 'domain\login'
Create account again using standard SP actions or just login to portal using this account. It did helped to resolve the issue.
Alternative approach can also be acquired to clear the user SID history.
Applies to: SharePoint server 2010, Windows Server 2008.
Location: Birmingham, West Midlands, UK