Fix “This page is not using a valid page layout. To correct the problem, edit page settings and select a valid page layout.” Error

Problem:We had a requirement to copy a few web part pages from the staging environment to production. Achieved it with the “Content Deployment Wizard” tool. However, copied pages gave this error message:“This page is not using a valid page layout. To correct the problem, edit page settings and select a valid page…

Read more

Fix “Could not find stored procedure ‘Search_GetRepositoryTimePerCrawl'” Error

Problem:When trying to navigate to a content source or crawl history in SharePoint 2013 search service application, I received this error message “Could not find stored procedure ‘Search_GetRepositoryTimePerCrawl’” Solution: Enable and run the timer job “Search Health Monitoring – Trace Events”! Here is the step-by-step solution: Navigate to SharePoint 2013 Central Administration…

Read more

How to Create a Web Part Page in SharePoint 2013 / 2016?

To create a web part page in SharePoint, follow these steps: Go to your SharePoint site >> Click on “Site Contents” link from Left navigation >> Click on “Site Pages” library.  Go to the “Files” tab, expand the New Document drop-down list and click on the “Web Part Page” Enter the Name…

Read more

Cannot navigate to the requested page while user profile synchronization is running. Please wait for the current synchronization run to finish.

Problem: When you try to start the Profile synchronization or try to create a new connection in the User Profile service application in SharePoint 2013, It gives this error message: “Cannot navigate to the requested page while user profile synchronization is running. Please wait for the current synchronization run to finish.” Solution:…

Read more

Sorry, we couldn’t find your license to use this feature. If you know who manages the licenses for your organization, tell them you’d like a license to use ‘Excel Services’.

Problem:  SharePoint Excel Services failed with an error message: “Sorry, we couldn’t find your license to use this feature. If you know who manages the licenses for your organization, tell them you’d like a license to use ‘Excel Services’.” Solutions: Make Sure SharePoint Enterprise Feature is enabled: Excel Services is part of…

Read more

How to Configure Excel Services in SharePoint? – Step by Step

SharePoint 2013 enterprise edition offers Excel Services service application that enables the browser-based rendering of Excel workbooks. Not just for rendering, but it’s primarily used in business intelligence scenarios for its excel calculation & analysis capabilities, ability to query external data sources, etc. Let’s walk through the steps of configuring Excel Services…

Read more

How to Remove a Column from SharePoint List using PowerShell?

Problem: The user has created a calculated column with an error in its formula! That caused the list view web part to crash! Couldn’t remove the column from the SharePoint list using web UI. How to delete a Column from SharePoint List? Do you need to delete a column in a SharePoint…

Read more

Get All Site Collections Size (Storage Used, Allocated), Owners, Database Details with STSADM

Do you know the STSADM command-line tool can do this, still in SharePoint 2013? Yes! It can get you a quick peek view of all site collections in the given web application. It gets you details such as: Storage space allocated – Storage used, warning and maximum levels Site collection GUIDs Site…

Read more