sharepoint 2010

User with Contribute access gets access denied

Only one user with contribute access gets access denied to SharePoint site collection. Every SharePoint admin might have faced this issue atleast once. In my case, user is added to a SharePoint group with Contribute access. Access shows up as Contribute when verified through site permissions - check permission option. Every other person in the […]

Read More

EventCache Table in SharePoint Content Database

Every SharePoint content database has an EventCache Table. Changes to the SP objects contained in the content database are logged to this EventCache Table. Every change is added as an entry/row to the table. EventCache table is the change log for objects in database. Columns in EventCache Table: Column name Data Type Description EventTime datetime […]

Read More

The upgrade command is invalid or a failure has been encountered - PSConfig error

Running PSConfig after installing updates is a stressful experience(atleast for me). Every time is comes up with a different challenge. But unlike some unfriendly errors, psconfig gives us much more details about the failures in the upgrade logs. Okay then, I was updating SharePoint 2010 with May 2015 CU. Everything goes well until - The […]

Read More

Sorry, we couldn’t open .xlsx file - Excel error

We had one user constantly having issues while opening Office documents stored in SharePoint site. Sorry, we couldn’t open ‘http://sharepointsite/sites/teams/documents/report.xlsx’ file. Even though it is one user, he had issues with multiple office files. We tried with user logging into another machine and try accessing the file. As expected, all the files open fine. This makes […]

Read More

Review Job Definitions page error

When you try to access Review Job Definitions page, through Monitoring under Central Administration, you get an error which says ‘Object reference not set to an instance of an object‘. This error is usually caused by a corrupt or faulty timer job definition or in some cases a missing dll in GAC. Resolution: Find out […]

Read More

SPShellAdmin - Permission to run farm level powershell cmdlets in SharePoint

In order to run PowerShell cmdlets in SharePoint 2010/2013, user should have necessary privileges to SharePoint object model and to SharePoint databases. Even if a user is added as farm admin, he necessarily do not have access to run powershell cmdlets unless user is having SPShellAdmin access. Adding users to this access level, provides the […]

Read More

Microsoft SharePoint Foundation Web Application service stuck on Starting/Stopping

There are situations where you like to start ‘Microsoft SharePoint Foundation Web Application service‘ on one or more of you application servers. Reason can be anything. Any server running ‘Microsoft SharePoint Foundation Web Application service’ is considered as a web server by most of the 3rd party vendor. For some products licensing is based on […]

Read More

Clear configuration cache in SharePoint farm 2010 , 2013

There are many occasions where you need to clear configuration cache in SharePoint farm. Here the steps you need to perform on all the servers in farm 1. Stop the SharePoint Timer service in all the servers.Start with the server running Central Administration website. Start -> Services.msc -> SharePoint Timer Service 2. Browse %SystemDrive%\ProgramData\Microsoft\SharePoint\Config\GUID (Works […]

Read More