[Fixed] The upgraded database schema doesn’t match the TargetSchema(Failed to upgrade SharePoint Products)

No comments

 4,986 total views,  36 views today

In this 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

For a SharePoint administrator running a SharePoint configuration wizard successfully is a big achievement those dealing with this can find the meaning 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 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.

Database_Upgrade_Failed

How to overcome this error?

The error says the target database does not match the schema which needs to be upgraded. So whichever database 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

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 Upgrade-SPContentDatabase command.
  • How to get the SharePoint content database using Get-SPContentDatabase command.

See Also:

 

Free download SharePoint Online & Office 365 Administration eBook(238 Pages)

Get the PDF eBook from here:


[purchase_link id="0" style="button" color="blue" text="Free Download SharePoint Online & Office 365 Administration"]

 

 
FREE DOWNLOAD

Send download link to:

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.