SharePoint Views

Tag: sharepoint 2013

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…

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…

Convert path-based site collection to host-named site collection – SharePoint 2013

With SharePoint 2013 and Office 365 Host named site collections have become an instant hit.Microsoft introduced a new Powershell command with February 10, 2015 Cumulative update KB2910928 ¬†to convert path-based site collections to host-named site collections. First of all,a host named site collection is something which has its own DNS entry and looks like http://host.mycompany.com.…

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…

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…

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…