'Database is in compatibility range and upgrade is recommended' for BDCServiceDatabase after March 2013 Upgrade

March 14, 2013 · 1 min read

After applying the March 2013 Update for SharePoint 2013 (http://www.microsoft.com/en-us/download/details.aspx?id=36989), the BDC Databases in your farm might be in a state where they need upgrade. You can review the current database status in Central Admin | Upgrade & Migration | Review database status.

This state is ok, as long as it doesn’t last too long. But at one day you need to upgrade the Database. The upgrade is no problem for SPContentDatabases, just use Upgrade-SPContentDatabase.

It is a little bit different for various Service Applications, especially for BDC. To get your BDC Databases to the latest state you can use the following PowerShell Commands:

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

After this, your BDC-Databases should be up to date again.

If you get an error when trying to access the BCS Service Application from Central Admin, make sure that the application pool account has “SPDataAccess” on the BCS Database:

sp_bcs.jpg 

Markus