Fix the upgrade database error while running SharePoint configuration wizard.

While SharePoint administrator run the SharePoint configuration wizard for the server patch or CU(cumulative) update - we can see the "upgrade failed" error saying that the particular database need to upgraded. In this blog we will learn how to fix this error.

Introduction

For a SharePoint administrator running a SharePoint configuration wizard successfully is a big achievement those who 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 below failure error – this content database needs upgrade.
 
 
 
 

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:
 
  1. Upgrade-SPContentDatabase "WSS_Content"  
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.
 
  1. Get-SPContentDatabase | ?{$_.NeedsUpgrade -eq $true} | Upgrade-SPContentDatabase  
 Once the database upgrade is successfully completed, do any of the following:
 
  • Run the SharePoint configuration wizard again from the beginning.
  • Execute the below command in the Sharepoint management shell.
  1. psconfig.exe -cmd helpcollections -installall -cmd secureresources -cmd services -install -cmd installfeatures -cmd applicationcontent -install -cmd upgrade -inplace b2b -force -wait  
Now then we can complete running the SharePoint configuration update successfully.
 

Summary

 
Thus, we have learned in this blog how to fix the database upgrade error during running the SharePoint configuration wizard.