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!

Advertisement