“Upgrade Required” Status in SharePoint 2013 Central Administration Servers in Farm

Getting “Upgrade Required” error message in SharePoint 2013? Well, Ideally, We have to run the SharePoint Products Configuration Wizard on the server(s) right after installing the service pack/patches. In Windows Server 2012, SharePoint updates are part of Windows Server Update. It installs patches but never runs the Products configuration wizard automatically! You…

Read more

Configure SharePoint 2013 Object Cache Super User, Super Reader Accounts

SharePoint 2013 object cache stores metadata about SharePoint Server objects like SPSite, SPWeb, SPList, etc. on the Web Front Ends. SharePoint features such as publishing, content query web part, navigation, search query box , metadata navigation, etc fetches data from object cache, instead of hitting SQL Server when data needs to be…

Read more

Fix “This workbook cannot be opened because it is not stored in an excel services application trusted location” Error in SharePoint 2010

Problem: Got this error when trying to open an Excel Sheet stored in a SharePoint 2010 document library: “This workbook cannot be opened because it is not stored in an Excel services application trusted location. To create an Excel Services Application trusted location, contact your system administrator”. Solution: By default, Excel Services…

Read more

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

Problem: “This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.” Root Cause: Usually, You’ll get this error message when your List view has many Lookup fields. The threshold feature is introduced in SharePoint 2010 to avoid performance…

Read more

Fix The website cannot display the page – HTTP 500 Internal Server Error in SharePoint

Problem:  When I opened SharePoint 2013 Central Administration site, it returned an error message: HTTP 500 Internal Server Error: The website cannot display the page error message! Troubleshooting: Check all required ports are open in Firewall in web & database servers. Update passwords on IIS Application Pool identities. Make sure they are…

Read more

Rename SharePoint Service Application, Proxy using PowerShell

If you want to rename a SharePoint service application or Service application proxy, There is now UI available. But PowerShell can help! PowerShell script to rename SharePoint 2013 Service application and Proxy: After the rename: rename SharePoint service application

Read more

Create Usage and Health Data Collection Service Application in SharePoint 2013 using PowerShell

Usage and Health data collection service application in SharePoint collects usage and health data from a variety of sources, including event logs, performance counters, search usage data, site collection and site usage data, and server statistics of the entire farm. There are timer jobs to collect data from log files in 16\LOGS…

Read more