I've been a SE read-only user for several years, but today I'm facing a problem I can't resolve nor find any help so I created my account. (... well actually I created it to answer to a since on-hold Star Wars question, but that's off-topic...)
I have a SPListItem which had its permissions programmatically updated. For an unknown reason, this update failed (really badly) and its permissions are now corrupted. Here are the symptoms (with sitecoll + farm admin account) :
- Checking permissions via GUI throws the error : Cannot complete this action. Please try again.
- Checking permissions (RoleAssignments) via PowerShell returns null.
- $item.ResetRoleInheritance() throws "Cannot complete this action..."
- Editing/Deleting the item via GUI throws an access denied.
- Editing/Deleting the item via PowerShell throws a 0x80070005, which is also an access denied.
Actually, my problem is exactly as described in this article. Unfortunately, the author's solution is to run a stored procedure, which AFAIK, is forbidden by Microsoft as any direct SQL operation in SharePoint.
Does anyone know a way to run this store procedure "legally" (= through GUI or object model) or any other way to repair or delete this item ?
Thank you for your help.
PS : BTW, if you know what could have been the cause of this failure, I'm interested too thanks !