Sorry, something went wrong - The file FILENAME is locked for exclusive use by USER
Problem: End-Users receives error when trying to edit a file. "Sorry, something went wrong - The file FILE-URL is locked for exclusive use by USER-NAME"
Root Cause:
When users edit the document in client applications such as Microsoft Office, SharePoint places a locks and renews it for every 10 minutes to prevent other users from modifying it. This lock is released automatically when the client application is closed, or after 10 minutes.
Solution:
But in some scenarios, lock retains due to reasons like: Client application crash, Network connectivity issues, etc. So, the simplest solution would be wait for 10 minutes for the lock to expire. But if you want the lock to be released immediately, You can unlock it programmatically!
There is no UI to unlock the locked files - as we do have for Check-in Checked-out files. So, Here is my solution to unlock the locked files using PowerShell.
Root Cause:
When users edit the document in client applications such as Microsoft Office, SharePoint places a locks and renews it for every 10 minutes to prevent other users from modifying it. This lock is released automatically when the client application is closed, or after 10 minutes.
Solution:
But in some scenarios, lock retains due to reasons like: Client application crash, Network connectivity issues, etc. So, the simplest solution would be wait for 10 minutes for the lock to expire. But if you want the lock to be released immediately, You can unlock it programmatically!
There is no UI to unlock the locked files - as we do have for Check-in Checked-out files. So, Here is my solution to unlock the locked files using PowerShell.
Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue #Variables for Web and File URLs $WebURL ="http://intranet.crescent.com/support/" $FileURL ="http://intranet.crescent.com/support/T1Support/Reports/ServiceTickets.xlsx" #Get Web and File Objects $web = Get-SPWeb $WebURL $File = $web.GetFile($FileURL) #Check if File is Checked-out if ($File.CheckOutType -ne "None") { Write-host "File is Checked Out to user: " $File.CheckedOutByUser.LoginName Write-host "Checked Out Type: " $File.CheckOutType Write-host "Checked Out On: " $File.CheckedOutDate #To Release from Checkout, Ask the checked out user to Checkin #$File.Checkin("Checked in by Administrator") #Write-host "File has been Checked-In" } #Check if File is locked if ($File.LockId -ne $null) { Write-host "File is Loked out by:" $File.LockedByUser.LoginName Write-host "File Lock Type: "$file.LockType Write-host "File Locked On: "$file.LockedDate Write-host "File Lock Expires on: "$file.LockExpires #To Release the lock, use: #$File.ReleaseLock($File.LockId) #Write-host "Released the lock!" }Don't forget to un-comment the lines 32-33 if you find your files are locked out.
Thanks man you are a life saver!!!
ReplyDeleteWhere/how do I input this code?
ReplyDeleteUse either PowerShell ISE or Save this script as a .ps1 file and run from PowerShell console. Don't forget to change WebURL and FileURL variables.
DeleteVery nice
ReplyDeleteExcellent! thanks dude!
ReplyDeleteDoes it work for SharePoint online?
ReplyDeleteDo you run this script on the server? Where is the setting for the 10 minute lockout. Our network does not have a 10 minute lockout. Is this done manually?
ReplyDeleteI now get the following error: Exception calling "ReleaseLock" with "1" argument(s)."
ReplyDeleteCan I add impersonation to this script?
Thanks for the script. Can impersonation be added to this?
ReplyDeleteI now get the following error message"Exception calling 'ReleaseLock' with '1' argument(s)"
Run the script from Farm Admin account or any account which has "Full Control" Web application user policy granted.
DeleteGetting same issue ,error message"Exception calling 'ReleaseLock' with '1' argument(s)"
ReplyDeleteHi,
ReplyDeleteIs there any script for SharePoint online as well?
Thanks,
SV
Looks like this script has impersonation built in, for unlocking the file: https://gallery.technet.microsoft.com/office/locked-for-exclusive-use-28b8bbf3
ReplyDeletehow it is possible to unlock files regularly ? Does Office Online also lock file ? I have observed the same.
ReplyDelete