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