kwizcom banner advertisement

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

April 30, 2015    ,
Problem: We had a requirement to copy few web part pages from Staging environment to production. Achieved it with "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 layout." Solution: Root cause of the problem is: Page layout URLs are hard-coded in the publishing/web part pages. When you copy/move them from one site to another (or during export-import). Solution is: You'll have to update it. Here is the easiest way: Open you site in SharePoint designer, Navigate to the library (usually: Pages), Right click on your copied page, choose "Detach from page layout" Now, again right click on the page and choose "Reattach to Page Layout". Ignore any error it throws. This should fix your problem. If you have a bunch of files to update page layout, You can use PowerShell. Here is my PowerShell scr
This page is not using a valid page layout. To correct the problem, edit page settings and select a valid page layout. This page is not using a valid page layout. To correct the problem, edit page settings and select a valid page layout. Reviewed by Salaudeen Rajack on April 30, 2015 Rating: 5

Fix for "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'"

April 25, 2015    ,
Problem: When trying to navigate to a content source or crawl history in SharePoint 2013 search service application, received this error message "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'" Solution: Enable and run the timer job "Search Health Monitoring - Trace Events" once! Here is the step by step solution : Navigate to SharePoint 2013 Central Administration Click on "Monitoring" >> Review Timer job definitions Pick ""Search Health Monitoring - Trace Events" timer job by navigating to the next page in the list. Click on "Enable" button if its not enabled already. Once enabled, Click on "Run Now" button for the same timer job. Give it a minute to run. Once Ran, This issue should be gone away!
Fix for "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'" Fix for "Could not find stored procedure 'Search_GetRepositoryTimePerCrawl'" Reviewed by Salaudeen Rajack on April 25, 2015 Rating: 5

Add a Link to SharePoint Top Navigation Menu or Quick Launch using PowerShell

April 25, 2015    , ,
Requirement: Add a new link to SharePoint Global Navigation (Top Link Bar) or Quick Launch using PowerShell. Add link to SharePoint Top Navigation using PowerShell: Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue #Variables for processing $WebURL="http://sharepoint.crescent.com/teams/marketing" $NavigationTitle="Employee Profile" $NavigationLink="https://peoplesoft.crescent.com/employee/profile.aspx" #Get the Web $Web= Get-SPWeb $WebURL #Get Top Navigation $TopNavigation = $Web.Navigation.TopNavigationBar #For Quick Launch, Use: Navigation.QuickLaunch #Create a New Top Navigation Node $node = New-Object Microsoft.SharePoint.Navigation.SPNavigationNode($NavigationTitle, $NavigationLink, $true) #Add the Node $TopNavigation.AddAsLast($node) #Set the Target Property - Will work only when Publishing features is enabled $node.Properties["Target"] = "_blank" $node.Update You can alter the script to add ne
Add a Link to SharePoint Top Navigation Menu or Quick Launch using PowerShell Add a Link to SharePoint Top Navigation Menu or Quick Launch using PowerShell Reviewed by Salaudeen Rajack on April 25, 2015 Rating: 5

How to Create a Web Part Page in SharePoint 2013?

April 25, 2015    , , ,
To create a web part page in SharePoint 2013, Follow these steps: Go to your SharePoint site, Navigate to "Site Pages" library - 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 for your new web part page, select the page Layout and Save Location, and then click on Create button. This creates a blank web part page in SharePoint 2013 as shown below. Now, We'll have to add some relevant web part to this web part page. Click on "Add a web Part" link shown in web part zones Select the relevant Web part to insert and click on "Add" button. I've added "Excel Web Access" web part. Configure web part properties. In my case, I've specified the excel sheet to display in the Excel web access web part. Click on "Stop Editing" button from
How to Create a Web Part Page in SharePoint 2013? How to Create a Web Part Page in SharePoint 2013? Reviewed by Salaudeen Rajack on April 25, 2015 Rating: 5

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

April 24, 2015    ,
Problem: When you try to start the Profile synchronization or try to create a new connection in 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: Generally, when a profile synchronizing is running, You may get this error message. If you find its running for long time, simply use the "Stop" link to stop the current synchronization job. Here is how: Open the SharePoint 2013 Central Administration >> Manage Service applications Open User Profile Service application Click the "Stop" link under "Profile Synchronization Settings" section.  What if you don't find "Stop" link? Well, that's because you don't have any user profile synchronization job running! So, what is the fix? Stop and Start the "User Profile Synchroniz
Cannot navigate to the requested page while user profile synchronization is running. Please wait for the current synchronization run to finish. Cannot navigate to the requested page while user profile synchronization is running. Please wait for the current synchronization run to finish. Reviewed by Salaudeen Rajack on April 24, 2015 Rating: 5

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'.

April 23, 2015    ,
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 SharePoint Enterprise feature in SharePoint 2013. So, Make sure "SharePoint Server Enterprise Site Collection features" is enabled both at site level and Site collection levels. If activated already, Try Deactivate-Activate again! Have you upgraded from Standard to Enterprise? Enable Features on Existing sites! When SharePoint Server license is upgraded from Standard to Enterprise, it applies only to new sites we are going to create. For existing sites, we must use "Enable Features on Existing Sites" feature once, under "Upgrade and Migration" in SharePoint 2013 Central Administration site. Sha
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'. 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'. Reviewed by Salaudeen Rajack on April 23, 2015 Rating: 5

How to Configure Excel Services in SharePoint 2013 - Step by Step

April 23, 2015    , , , ,
SharePoint 2013 enterprise edition offers Excel Services service application that enables browser-based rendering of Excel workbooks. Not just for rendering, but its primary used in business intelligence scenarios for its excel calculation & analysis capabilities, ability to query external data sources, etc. Lets walk-through the steps of configuring Excel Services to SharePoint Server 2013 farm. How to Configure Excel Services in SharePoint 2013: Here are the steps in high-level to configure Excel Services Start Excel Calculation Services Service Instance Create Excel Services Service Application Grant Database Access to Excel services service Account  Suppress Office Web Apps to enable Excel services  Configure trusted file location. Prerequisites - We need a managed account for Excel Services service application. Create a new managed account if you don't have one configured already!. Configuring Managed Accounts in SharePoint 2013 Step 1: Start Excel Calculat
How to Configure Excel Services in SharePoint 2013 - Step by Step How to Configure Excel Services in SharePoint 2013 - Step by Step Reviewed by Salaudeen Rajack on April 23, 2015 Rating: 5

How to Remove a Column from SharePoint List using PowerShell?

April 19, 2015    , , , , ,
Requirement: User created a calculated column with error in its formula! That caused the list view web part to crash! couldn't remove the column from SharePoint list using web UI. How to delete a Column from SharePoint List? From SharePoint Web UI, to remove a field from list or library, follow these steps: Browse to the List or Library in which you want to remove column. click on List or Library tab. Click on List Settings / Library Settings from the Ribbon.  From the List Settings page, Under Columns section, click on the name of the column that you wish to delete. Scroll down to the bottom and then click on "Delete" button. Confirm the prompt. PowerShell script to delete the column from SharePoint list Here is the PowerShell to remove a column from list. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Variables $SiteURL="http://intranet.crescent.com/" $ListName="Change Request" $ColumnName="Activi
How to Remove a Column from SharePoint List using PowerShell? How to Remove a Column from SharePoint List using PowerShell? Reviewed by Salaudeen Rajack on April 19, 2015 Rating: 5

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

April 17, 2015    , , , ,
Do you know the STSADM command line tool can do this still in SharePoint 2013? Yes! it can get you the 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 collection database names Primary and Secondary Owners Simply trigger command line and run:  Stsadm -o EnumSites -url http://Sharepoint-web-app-URL This command line retrieves all details as listed above in XML format. Lets export that XML to a file and get it in Excel for better analysis. Run: Stsadm -o EnumSites -url http://Sharepoint-web-app-URL > SitesInfo.xml Once completed, Open the XML file in Microsoft Excel, choose "As an XML Table" and you should get the table as below: PowerShell script to get site collection size: How to check site collection size in SharePoint 2013 with PowerShell
Get All Site Collections Size (Storage Used, Allocated), Owners, Database Details with STSADM Get All Site Collections Size (Storage Used, Allocated), Owners, Database Details with STSADM Reviewed by Salaudeen Rajack on April 17, 2015 Rating: 5

Reset SharePoint List View Filters with PowerShell

April 16, 2015    , ,
Requirement: Reset SharePoint view filters. Solution: To reset SharePoint view in bulk, we can use this PowerShell script. PowerShell script to reset SharePoint view. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $WebURL = "http://sales.crescent.com" $ListName = "Proposal Documents" $ViewName = "All Proposals" #Get the Site, List and View objects $web = Get-SPWeb $WebURL $List = $Web.Lists[$ListName] $View = $List.Views | ? {$_.title -eq $ViewName} #Reset SharePoint View - By default sort by Name $View.Query = "<OrderBy><FieldRef Name='FileLeafRef' /></OrderBy>" $View.Update() $List.Update() This script removes Sorting and Filters applied to the given SharePoint list view.
Reset SharePoint List View Filters with PowerShell Reset SharePoint List View Filters with PowerShell Reviewed by Salaudeen Rajack on April 16, 2015 Rating: 5

Fix "We're having a problem opening this location in file explorer. Add this web site to your Trusted Sites list and try again" Error in SharePoint

April 13, 2015    ,
Problem:  SharePoint 2010 explorer view gives this error message: "We're having a problem opening this location in file explorer. Add this web site to your Trusted Sites list and try again" Solution: Most of the time, simply adding your SharePoint site URL to the Trusted Sites zone doesn’t solve the problem! Try these solutions instead: Check whether web client service is in started state under services console (services.msc). If its Windows Server, You'll have to install "Desktop Experience" from Add Roles and Features. (Open Server Manager >> Manage >> Add Roles and Features >> Select Features >> User Interfaces and Infrastructure >> Desktop Experience >> Install) If you are in IE10, Try this hot fix: https://support.microsoft.com/en-us/kb/2846960
Fix "We're having a problem opening this location in file explorer. Add this web site to your Trusted Sites list and try again" Error in SharePoint Fix "We're having a problem opening this location in file explorer. Add this web site to your Trusted Sites list and try again" Error in SharePoint Reviewed by Salaudeen Rajack on April 13, 2015 Rating: 5

How to Deploy Multiple WSP Solutions using PowerShell in SharePoint

April 10, 2015    , , ,
Requirement: Have a bunch of WSP solution packages and had to add and deploy all of them to a cloned SharePoint environment. Solution: Lets bulk deploy all WSP solutions from a folder to SharePoint using PowerShell. PowerShell script to bulk add Multiple solutions: Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue Function WaitForInsallation([string] $SolutionName) { Write-Host -NoNewline "Waiting for deployment job to complete" $SolutionName "." $WSPSol = Get-SPSolution $SolutionName while($wspSol.JobExists) { sleep 2 Write-Host -NoNewline "." $wspSol = Get-SPSolution $SolutionName } Write-Host "job Completed" -ForegroundColor green } Function Deploy-SPSolution ($WSPFolderPath) { #Get all wsp files from the given folder $WSPFiles = Get-childitem $WspFolderPath | where {$_.Name -like "*.wsp"} #Iterate throug
How to Deploy Multiple WSP Solutions using PowerShell in SharePoint How to Deploy Multiple WSP Solutions using PowerShell in SharePoint Reviewed by Salaudeen Rajack on April 10, 2015 Rating: 5

Change Log Files Location for ULS, Usage and Health Data Collection

April 10, 2015    , , , , ,
No doubts, diagnostic logs and "Usage and health data" logs are extremely helpful. However, it could cause performance issues and slow down SharePoint if not managed properly. These logs can use large amounts of drive space and can affect server performance. Also can quickly fill the system disk which could potentially bringing the entire system down! So, it is recommended to change the location of these log files to a different drive. How to change ULS Log location in SharePoint 2013? By default, logging is configured to write logs to the drive and partition where SharePoint 2013 is installed at "C:\Program Files\Common Files\Microsoft shared\Web Server Extensions\15\LOGS". Changing the SharePoint 2013 log settings can be done using PowerShell or Central Admin. Go to Share 2013 Central Administration >> Monitoring  Click "Configure diagnostic logging" Under Reporting group Scroll down and set location for diagnostic log files. E.g. Se
Change Log Files Location for ULS, Usage and Health Data Collection Change Log Files Location for ULS, Usage and Health Data Collection Reviewed by Salaudeen Rajack on April 10, 2015 Rating: 5

Load SharePoint Snapin to Powershell ISE by Default

April 04, 2015    ,
Problem:  If you use the PowerShell ISE to edit your SharePoint-PowerShell scripts, you may noticed that SharePoint cmdlets are not available by default until you explicitly load them with "Add-PSSnapin" cmdlet. This is because the ISE doesn't load SharePoint PowerShell Snap-ins by default. Solution: Here is the nifty trick to load SharePoint snap-in in PowerShell ISE by default! All you have to do is: Add the SharePoint snap-in to your PowerShell ISE profile file, which is getting executed each time you fire PowerShell ISE! Here is how: To make sure that the profile file is created, run: #Check if the profile file exists already if (test-path $profile) { write-host "profile file already exists at: $profile" } else { #Create the profile file New-Item -type file -path $profile -force write-host "profile file has been created!" } This script will create a new profile file, if it isn't created already! Your output will b
Load SharePoint Snapin to Powershell ISE by Default Load SharePoint Snapin to Powershell ISE by Default Reviewed by Salaudeen Rajack on April 04, 2015 Rating: 5

Co-Authoring Feature in SharePoint 2013 - FAQs

April 02, 2015    , ,
What is co-authoring exactly means? Co-Authoring is an amazing feature in SharePoint - Office Web Apps which allows multiple users to edit and collaborate concurrently in real time. Yes, You heard it right! Multiple authors can edit one document (Word, Excel, PowerPoint, etc) and simultaneously other user's changes will be reflecting to everyone! Its definitely a great productivity boosting feature. Multiple users can work on a same document at the same time while they see each other works in the document, so they don't make any conflicts as they make edits. There is no limit in number of users. Any number of people can work on the same document at the same time. How to use Co-Authoring in SharePoint 2013 with Office Web Apps: Here is how the Co-authoring works in Excel documents with SharePoint 2013 - Office Web Apps: Step 1: Navigate to any document library/folder where your Excel files are stored. Click on the context menu button and click on More options as in the
Co-Authoring Feature in SharePoint 2013 - FAQs Co-Authoring Feature in SharePoint 2013 - FAQs Reviewed by Salaudeen Rajack on April 02, 2015 Rating: 5
Powered by Blogger.