how to increase external list limit

Database Connector has throttled the response. The response from database contains more than '2000' rows. The maximum number of rows that can be read through Database Connector is '2000'. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet.

this error will occur while iam retriving table from sql to list...

Are you using SharePoint Online or On-premises?

For SharePoint Online:

In SharePoint Online the throttle limitation can’t be changed, so we may need to control the record count of each query. From SharePoint Online side, we can define filters for the External Content Type to exclude unnecessary records

For On-Premises, you can change via script as shown in below blog

https://natechamberlain.com/2019/04/01/solution-database-connector-has-throttled-the-response-error-on-external-list-in-sharepoint/

1. Log into your SharePoint server

2. Open your SharePoint 2016 Management Shell as administrator (right-click, run as administrator)

3. Connect to your site

Connect-Site -url https://sharepoint.contoso.com

4. Get ALL service application Proxy IDs (you’ll need this in a later step)

Get-SPServiceApplicationProxy

5. Note the ID of the “Business Data Con…” application

6. Set a new variable “$serviceapp” to that app using the ID you noted as its identity

$serviceapp = Get-SPServiceApplicationProxy -Identity a12b3cf4-d12j...

7. Run the following cmdlet to increase the throttle limit

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $serviceapp | Set-SPBusinessDataCatalogThrottleConfig -Maximum 1000000000 -Default 500000

Done.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari4y ago
Hi

Are you using SharePoint Online or On-premises?

For SharePoint Online:
In SharePoint Online the throttle limitation can’t be changed, so we may need to control the record count of each query. From SharePoint Online side, we can define filters for the External Content Type to exclude unnecessary records
For On-Premises, you can change via script as shown in below blog
https://natechamberlain.com/2019/04/01/solution-database-connector-has-throttled-the-response-error-on-external-list-in-sharepoint/

1. Log into your SharePoint server
2. Open your SharePoint 2016 Management Shell as administrator (right-click, run as administrator)
3. Connect to your site
Connect-Site -url https://sharepoint.contoso.com
4. Get ALL service application Proxy IDs (you’ll need this in a later step)
Get-SPServiceApplicationProxy
5. Note the ID of the “Business Data Con…” application

6. Set a new variable “$serviceapp” to that app using the ID you noted as its identity
$serviceapp = Get-SPServiceApplicationProxy -Identity a12b3cf4-d12j...
7. Run the following cmdlet to increase the throttle limit
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $serviceapp | Set-SPBusinessDataCatalogThrottleConfig -Maximum 1000000000 -Default 500000
Done.