Database is in compatibility range and upgrade is recommended – Solution

Problem: 
After a service pack upgrade in SharePoint 2013, database status under  Central Admin >> Upgrade & Migration >> Review database status – turned into “Database is in compatibility range and upgrade is recommended”

Solution:

In most cases, this message simply means, You have installed the latest patch/service pack, and running SharePoint products configuration wizard is pending still! So, run the SharePoint products configuration wizard once to clear this message.

fix database is in compatibility range and upgrade is recommended

Still getting the “Database is in compatibility range and upgrade is recommended” message?
To resolve this error with BDC service application, just execute below cmdlet in the PowerShell console.

(Get-SPDatabase | ?{$_.type -eq "Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase"}).Provision()

Once its executed BDC database status turned to “No Action Required”.

“Database is in compatibility range and upgrade is recommended” on Content databases
In SharePoint 2016 Central Administration, under the database upgrade status page, found the status of a SharePoint content database as “Database is Running in Compatibility Range and Upgrade Recommended”.

Database is Running in Compatibility Range and Upgrade Recommended

Here is how to resolve it:

  • Run the cmdlet “Upgrade-SPContentDatabase” on the contend database once, which should resolve the problem.
    Get-SPContentDatabase –Identity <database-name> | Upgrade-SPContentDatabase
  • Run PSConfig command line: PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

Salaudeen Rajack

Information Technology Professional with Two decades of SharePoint Experience.

Leave a Reply