BDC Database is in compatibility range and upgrade is recommended

blank

Database is in compatibility range and upgrade is recommended

V: 1.1

Issue

Your apply a Cumulative Update (CU) for SharePoint or Project Server PPM. After the update deployment you run the SharePoint Configuration Wizard to update the farm to new patch version. Now you go to Central Administration > Upgrade and Migration > Review Database Status. You will find that the status of Business Data Connectivity (BDC) database shows the message:

Database is in compatibility range and upgrade is recommended 

SP2013_BDC_In_Compatibility_Range_01
SP2013 BDC In Compatibility Range 01

Even running the SharePoint Configuration Wizard again will not fix this issue.

Resolution

The databases should not be left in the compatibility range for long. To resolve this issue for BDC service application, run the following Power Shell commands from one of the SharePoint server. Launch Power shell with elevated admin rights.

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

 

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

SP2013_BDC_In_Compatibility_Range_02
SP2013 BDC In Compatibility Range 02

BDC database should be in good state now. Go to SharePoint Central Administration > Upgrade and Migration > Review Database Status and review the status for BDC database.

SP2013 BDC In Compatibility Range 03
SP2013_BDC_In_Compatibility_Range_03

References

  1. SharePoint Updates – CU Updates
  2. Project Server Updates – CU Updates

Leave a Reply

Sign up for Softvative Newsletter

Get notified about new articles and deals

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter