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

SharePoint 2016 - There was an exception in the database. Microsoft SharePoint, SharePoint 2013, SharePoint 2016 searcherror

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.

SharePoint 2016 - There was an exception in the database. Microsoft SharePoint, SharePoint 2013, SharePoint 2016 storedproceduremissing

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.

SharePoint 2016 - There was an exception in the database. Microsoft SharePoint, SharePoint 2013, SharePoint 2016 upgraderequired

So I then ran the configuration wizard and ran into the upgrade errors. The upgraded database schema doesn’t match the TargetSchema.

SharePoint 2016 - There was an exception in the database. Microsoft SharePoint, SharePoint 2013, SharePoint 2016 failedupgrade

So now I ran the Upgrade-SPContentDatabase powershell commands for each of my content  databases before running my SharePoint Configuration Wizard again.

SharePoint 2016 - There was an exception in the database. Microsoft SharePoint, SharePoint 2013, SharePoint 2016 upgradecontentdbs

Now my SharePoint farm upgraded fine and my search web parts lived happily ever after!

Avatar for Pieter Veenstra

By Pieter Veenstra

Business Applications Microsoft MVP working as a Principal Architect at HybrIT Services Ltd. You can contact me using contact@sharepains.com

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from SharePains by Microsoft MVP Pieter Veenstra

Subscribe now to keep reading and get access to the full archive.

Continue Reading

%d bloggers like this: