A file is exclusively locked by a desktop application in a SharePoint document library

Have you ever had an issue where a user opened a file in an Office application and went on holiday? Since the file was locked on the client side nobody could check it out or edit it. Well one of my users had this issue. SharePoint calls it ShortTerm lock. You can check it using the below PowerShell code:

$l = $w.Lists["Documents"]
$i = $l.GetItemById(1)
Write-Host $i.File.CheckOutStatus

If the status is ShortTerm you can lift the lock with

[string]$url = "Site URL"
[string]$list = "Library name"
[string]$item = "Document ID"

$w = get-spweb $url
$l = $w.lists[$list]
$i = $l.GetItemById($item)
$s = New-Object Microsoft.SharePoint.SPSite($w.site.id, $i.File.LockedByUser.UserToken)
$w = $s.OpenWeb($w.id)
$l = $w.lists[$list]
$i = $l.GetItemById($item)

Thanks to http://sharepointobservations.wordpress.com/2013/09/10/remove-sharepoint-client-side-file-lock/

When entering edit mode page hangs on Loading...; Edit mode never appears


If the page originally contained Excel Web App webparts that were referencing Excel documents that have been removed from SharePoint.


When the user attempts to edit the page the WebParts will be unable to open the .xlsx spreadsheets, but no high-level warning or exception gets generated in the ULS, and no feedback is provided for the user.


The solution is to either edit the webpart to point to a different (existing) document, or to enter Maintenance Mode on the Page Properties and remove the faulting webparts through there. After the webParts are removed edit mode starts working again.

Sitepages redirects to default.aspx

​Its because the Home.aspx (may be another page in your case) is set as a welcome page for the library root folder. Below should fix it

$web = Get-SPWeb "http://site"
$list = $web.Lists["Site Pages"]
$rootfolder = $list.RootFolder
$rootfolder.WelcomePage = "Forms/AllPages.aspx"
Write-Host $list.RootFolder.WelcomePage

Project site associations do not appear after Project instance migration

Thi issue is caused by the database restore. When restoring the database the associated server for the project site does not get rewritten. Due to the query SharePoint performs only sites with the correct server UID will be associated to projects.

To fix this the Server UID will have to be updated in the [MSP_PROJECTS] table.

To update the project site associations run the following query on the database:

update  [!!INSTANCENAME!!_Published].[dbo].[MSP_PROJECTS] SET wsts_server_uid = 'UID'

SSRS report subscriptions disappear

We noticed a strange behavior today. We set subscriptions on a SQL Server 2008 R2 SSRS report and when we later tried to add new subscriptions to the report we noticed that the previously created subscriptions are missing from the list although sending regular updates. A few days later the missing subscriptions re-appeared magically. After some investigation it turned out that the subscriptions are stored in the SSRS using the SPUrlZone method which explicitly returns the URL of the report in the exact way it's accessed. This URL is than written into SSRS. The problem is with Alternate Access Mapping which enables you to access the same report using different URLs. When the subscriptions were missing we simply used a different URL and for that URL SSRS could not find any subscriptions. This issue is present in both SQL Server 2008 R2 and SQL Server 2012. I heard from Microsoft that they are working on a fix. Until it's released the only workaround is to use the same AAM every time.

SharePoint 2010 related service gets disabled every hour

Today I was facing several PowerPivot workbooks that could not refresh data in a virtualized environment. After checking the database hosting the data and couldn't find any permission or connectivity issues I turned to Analysis Services. I checked and the SQL Server Analysis Services service was disabled. No problem. I set it to Automatic startup and started the service. It was working like a charm but after a while I got the same error as before. I went back and noticed that the service is disabled again. I enabled it again but after a while it was disabled again. What I noticed was that it got disabled every hour. I googled for the problem and found an article here, where the same thing happened with the Project Server Queue Service. It turned out that the SP Health rule "One or more services have started or stopped unexpectedly" due to a bug disables random services at the hourly run. The only fix for this issue is to disable the automatic repair functionality of this rule.

For me it solved the issue.

Document Library throwing System.Runtime.InteropServices.COMException error when trying to open files.

Recently I came across an Image Library on a SharePoint 2010 farm where the thumbnails were visible but opening the images threw a correlation ID. The error message behind the ID was a System.Runtime.InteropServices.COMException which is an ACL related issue. The library inherited permissions from its parent so to solve this issue I broke inheritance and re-established inheritance again. When I re-established inheritance the system refreshed the ACL from the parent and fixed the issue.

Web part error on Project Detail Pages after a 5 database Project Server instance restore from a different environment

 You may encounter web part issues on various Project Detail Pages after a 5 database restore from another environment on Project Server 2010. If you look at the ULS logs you may find the below entries:

Web Part Exception Unique ID: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.GatherAndLoadCFList(Boolean bForceRefresh)     at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.RebindGrid(Boolean forceRefresh)     at Microsoft.Office.Project.PWA.WebParts.ProjectFieldPartBase.PWA_OnLoad(EventArgs e)     at Microsoft.Office.Project.PWA.WebParts.PWAResiliencyPart.OnLoad(EventArgs e)

In various cases it means that during the provisioning of the databases the Project Server Service Application failed to update the value of the PWAURL. Below you can find the steps to check and update the value:

$Web = get-SPWeb http://<servername>/<PWAInstance>

$Web.AllProperties | Format-Table

Check the PWAURL variable. If the returned value is too long and the result is trimmed run the below command:

$Props = $Web.AllProperties


Check the results. If the result is not the URL of the new instance you can change it using:
$Web.AllProperties[“PWAURL”]=”NEW PWAInstance URL


Task ‘SharePoint’ reported error (0x800004005) : This SharePoint List (xxxxxxxx Site - Team Calendar) is blocked from download to offline clients.’

If you press the "Connect to Outlook" button on the ribbon of a calendar in SharePoint 2010 the server creates a URL similar to the following: stssync://sts/?ver=1.1&type=calendar&cmd=add-folder&base-url=http%3A%2F%2FSITEURL&list-url=%2FLists%2FTeam%2520Calendar%2F&guid=%7Ba0b6a3dc%2D8416%2D48bf%2D9fa1%2D1f2c45fb3fb3%7D&site-name=SITENAME&list-name=Team%20Calendar. If you go to Outlook you may see a Send-Receive error stating: Task ‘SharePoint’ reported error (0x800004005) : This SharePoint List (xxxxxxxx Site - Team Calendar) is blocked from download to offline clients.’ . There are two possible reasons for this error.

  1. Under Site Settings - Site Administration - Search and Offline Availability - Offline Client Availability check that yes is selected.
  2. Under List Settings - Advanced Settings - Offline Client Availability check that yes is selected.

SharePoint 2010 gives you the ability to disallow offline client availability on both site and list level.

Additions to this Web site have been blocked - error message when you check user permissions

I came across this issue a few days ago where all users with Full Control privileges seemed to have lost their elevated privileges on a specific site collection in a SharePoint 2010 farm. They were unable to add users to a group or make any kind of changes. It turned out that a site collection backup failed and it set a read-only lock on the site collection. After removing the lock everything went back to normal.

About the author

Hi! I'm Marcell Mikolcsó, SharePoint and Enterprise Administrator, System Architect.

Month List

Page List