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!

 

BCS: 2000 items limit in external list

Hi all! The other day I was configuring an external list from a BCS and went I tried to visualize the list I received the following error message:

Database response throttled. Maximum number of rows that can be read through the database system utility is 2000. Use Set-SPBusinessDataCatalogThrottleConfig cmdlet.

Solution: PowerShell!!

$bcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs

Check the throttle limit:  $BCSThrottle

Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 40000 
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs

Check another time the throttle limit to see how the values have been changed: $BCSThrottle

Scope        : Database
ThrottleType : Items
Enforced     : True
Default      : 40000
Max          : 1000000

And that’s all, hope it helps!