Business Connectivity Database is in compatibility range and upgrade is recommended -en-

Since SharePoint 2013 Public Update March 2013 there is a problem in Central Admin -> Manage Databases Upgrade Status where the Business Connectivity Database shows, that it is in compatibility Range and Upgrade is recommended.

DB_BDCUpgradeNeeded

Normally you can use PSCONFIG.EXE -cmd upgrade -inplace b2b (found in the c:\program files\common files\microsoft shared\webserver extensions\15\bin) to upgrade any database in compatibility mode. Also the Upgrade-SPContentDababase Command would be handy, if it was a Content Database. As in our scenario nothing of it works, I did some investigation and found, that it could be done with the Provision() method of the SharePoint API. There it states:

Prepares a Microsoft SQL Server database for use with Microsoft SharePoint Foundation. If the database does not exist it will be created. If the database exists prior to calling the method, it will be provisioned with the SharePoint schema.

http://msdn.microsoft.com/en-us/library/office/ms478822(v=office.15).aspx

 

 

So as it states „Will be provisioned with the SharePoint schema“ it obviously also upgrades it. There is a simple PowerShell you can run to call the Provision Method:

 
$db = Get-SPDatabase | Where-Object {$_.Type -eq "Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase"}
$db.Provision() 

After this operation, everything is back to normal and the Business Connectivity Database has No Action required

So long, Samuel

Tags:

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s