Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Introduction
In this article, we will learn about how to fix the upgrade database error when SharePoint configuration wizard failed.
Issue Description
For a SharePoint administrator running a SharePoint configuration wizard successfully is a big achievement those deal with this can find the meaning why I have used this word. Lets 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 upgrade.
Error text
Configuration Failed
One or more configuration tasks failed. Tasks that were successfully completed won't be rolled back.
Detailed failure information is listed here:
Failed to upgrade Sharepoint Products.
This is a critical task. YOu have to fix the failures before you can continue. Follow this link for more information about how to troubleshoot upgrade failures:
An exception of type
Microsoft.SharePoint.PostSetupConfiguraiton.PostSetupConfigurationTaskException was
thrown. Additional exception infomration:
upgrade (SPContentDatabase Name=WSS_Content) failed. (EventID:an59t)
Exception: The ugraded database schema doesn't match the Target schema
(EventID:an59t)
Screenshot
How to overcome this error?
The error says target database does not match the schema which need to be upgraded. So whichever database mentioned in the error needs 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 upgrade – running this command one by one is time consuming. So 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: what we had here?
Thus, we have learned in this article how to fix the database upgrade error during running the SharePoint configuration wizard.