Set SharePoint Application Pool Recycle Time

By design application pools in IIS are restarted once per every 29 hours to provide best performance and stability. The very first user access SharePoint after app pool recycle will experience considerable delay, as .net assemblies needs to be recompiled to the memory. So, we use Warm-up scripts for SharePoint 2013 to…

Read more

Add-Remove Permissions to SharePoint List using PowerShell

Requirement: Set list permissions using PowerShell PowerShell can be utilized to Add/Remove permission to SharePoint List. Here is my PowerShell script to grant and remove permissions to SharePoint sites, lists, and libraries. Grant Permission to a user or group to SharePoint List PowerShell script to remove permission from the List: Although this…

Read more

Find and Replace URL Links from Hyperlink Columns in SharePoint

Requirement: We had a SharePoint portal site called “Crescent Portal” with URL: http://portal.crescent.com. After migrating from SharePoint 2010 to SharePoint 2013, we made a decision to replace both site name and URL as “Crescent Intranet” with URL “http://intranet.crescent.com”. We understand there are plenty of lists and libraries hard-coded with the old site…

Read more

Copy-SPSite – Clone SharePoint Site Collection using PowerShell

Copy-SPSite is a new feature introduced in SharePoint 2013, allows us to copy an existing site collection into a new site collection. Copy-SPSite cmdlet clones/duplicates existing site collection into a new one. Optionally, You can specify the “Destination Database” parameter to copy the site collection into a new database. Copy-SPSite Example: Syntax: …

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

Check if SharePoint Site Collection, Site, List, Document, Column Exists in PowerShell

Here are my nifty PowerShell scripts to check if a given URL of the Site Collection, Site, List, Document (File) and column objects exists in SharePoint. You can utilize these helper functions wherever required. PowerShell to check if Site Collection Exists: Here is my custom function and function usage with PowerShell to…

Read more

Fix “This page can’t be displayed” “Internet Explorer Cannot Display This Page” Errors when Creating Web Application in SharePoint 2013

Web application creation process through SharePoint 2013 central administration site stopped in middle with error messages “This page can’t be displayed”, “Internet Explorer Cannot Display This Page”!. However, I noticed that the IIS Web Sites, Application Pools, content databases are created! But there is no content inside the virtual directory in IIS….

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