SharePoint 2016 – There was an exception in the database.

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!

Leave a Reply

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

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,912 other subscribers

Recent Posts

Archive

Thank you for visiting SharePains

%d bloggers like this: