Databases running in compatibility range, upgrade recommended (for BdcServiceDatabase)

The SharePoint Health Analyzer showed the below error after March 2013 PU Upgrade for SharePoint 2013.

Title:  Databases running in compatibility range, upgrade recommended.

Severity: 2 – Warning

Category: Configuration

Explanation:

The following databases have versions that are older than the current SharePoint software, but are within the backwards compatible range:SP_BDC_DB

– When I browsed to the Upgrade and Migration -> Review database status

c1

Resolution

Run the below command in SharePoint Management Shell

(Get-SPDatabase | ?{$_.type -match “BdcServiceDatabase”}).Provision()

c2

Now if you try to open the BCS Service Application you get the below error.

c3

To fix this give the BCS Service Applications’ App Pool Account SPDataAccess on the BCS database.

c4

till the next time!

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s