While Creating External List in sharepoint You may often face this kind of problem when the DB table contains huge number of data.
"Database Connector has throttled the response. The response from database contains more than '800' rows. The maximum number of rows that can be read through Database Connector is '800'. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet."
Through powershell command you can increase the BCS Throttle size. Simply copy the code and run it.
Add-PSSnapin Microsoft.SharePoint.PowerShell
$bcs = Get-SPServiceApplicationProxy | where {$_ -match "Business Data Connectivity Service"}
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs
Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs
Happy Powershelling :)
Thanks
Asish
"Database Connector has throttled the response. The response from database contains more than '800' rows. The maximum number of rows that can be read through Database Connector is '800'. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet."
Through powershell command you can increase the BCS Throttle size. Simply copy the code and run it.
Add-PSSnapin Microsoft.SharePoint.PowerShell
$bcs = Get-SPServiceApplicationProxy | where {$_ -match "Business Data Connectivity Service"}
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs
Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs
Happy Powershelling :)
Thanks
Asish
No comments:
Post a Comment