Archive for February, 2016

BDC Database is in compatibility range and upgrade is recommended

Friday, February 19th, 2016

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()

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