In this “Failed to upgrade SharePoint products” troubleshooting article, we will learn about how to fix the upgrade database error when the SharePoint configuration wizard failed, basically, we might see the below two errors or exceptions:
- Failed to upgrade SharePoint Products
- Exception: The upgraded database schema doesn’t match the TargetSchema
Issue Description (Failed to upgrade SharePoint products): The upgraded database schema doesn’t match the targetschema
For a SharePoint administrator running a SharePoint configuration wizard successfully is a big achievement those dealing with this can find the meaning of why I have used this word. Let’s come to the topics – when we run the SharePoint configuration wizard in the production server due to some reason it may be for a CU update or some other database issue. Over a period of time when the installation wizard runs, we will get the failure error – this content database needs to upgrade.
How do we overcome this error? the upgraded database schema doesn’t match the targetschema
The error says the target database does not match the schema which needs to be upgraded. So whichever database is mentioned in the error needs to upgrade – we need to run the below PowerShell command for each database one by one.
Example:
Upgrade-SPContentDatabase "WSS_ContentDatabase"
So, if we have multiple content database which needs an upgrade – running this command one by one is time-consuming. So the best way to complete this upgrade – using the below command in a single shot.
Get-SPContentDatabase | ?{$_.NeedsUpgrade -eq $true} | Upgrade-SPContentDatabase
After successfully upgrading the content database, run the SharePoint configuration wizard again from the beginning, then we will be able to run the wizard successfully.
Summary: Failed to upgrade SharePoint Products
Thus, we have learned in this article how to fix the database upgrade error during running the SharePoint configuration wizard.
- Hot to fix when the configuration of SharePoint products failed.
- How to fix the failed to upgrade SharePoint Products error.
- How to fix the exception: The upgraded database schema doesn’t match the TargetSchema (EventID:an59t)
- Microsoft SharePoint upgrade spfarm sequence failed.
- How to upgrade the SharePoint content database using the Upgrade-SPContentDatabase command.
- How to get the SharePoint content database using the Get-SPContentDatabase command.
See Also: SharePoint Online tutorial (SharePoint Online PowerShell)
You may also like the below SharePoint Online tutorials:
- Office 365: Getting started with SharePoint PnP PowerShell – installation
- In 2 steps convert a classic SharePoint page to modern using PnP
- Office 365: Retrieve hub sites and associated sites using PnP Powershell
- Create a modern team site using PnP PowerShell in SharePoint
- In 4 steps access SharePoint online data using postman tool
- SharePoint admin center: Learn SharePoint online administration in an hour – step by step
- SharePoint REST API: GET vs POST vs PUT vs DELETE vs PATCH
- Office 365: Understanding the hub site in SharePoint online
- Install a software update for SharePoint Server
