With all the new products and updates in Office 365 Microsoft 365, I’ve not been able to write many real SharePains articles anymore. But today I had a real pain with SharePoint.
I noticed that my search web parts were all returning the following error
Then I got my ULS Viewer tools out again (gosh , that has been a long time ago). I haven’t done much on-premises SharePoint recently, but this tool still really helps identifying the real issues.
Ok, so a stored procedure is missing. proc_MSS_GetURlMapping. The Could not find stored procedure proc_MSS_GetURlMapping message couldn’t be any clearer.
Then when I checked I noticed that my SharePoint farm was mid upgrade.
So I then ran the configuration wizard and ran into the upgrade errors. The upgraded database schema doesn’t match the TargetSchema.
So now I ran the Upgrade-SPContentDatabase powershell commands for each of my content databases before running my SharePoint Configuration Wizard again.
Now my SharePoint farm upgraded fine and my search web parts lived happily ever after!
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com