3

My Web part consumes a list that presents this error:

The Database Connector limited the response. The database response contains more than '2000' rows. The maximum number of rows that can be read in the Database Connector is '2000'. You can change the limit by using the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet

5

Unfortunately, it's one of the main limitations of SharePoint External List!

In External List, If the number of retrieving items is more than 2000 items, the external list will not working properly. you will face a performance issue and it may be stuck to render!

Fortunately, you can exceed the default max limit (2.000 items) using Set-SPBusinessDataCatalogThrottleConfig cmdllet to the absolute max (25.000 items).

But unfortunately, exceeding the default max size is not recommended based on Microsoft support response. Moreover, the performance issue will not be solved!!

For more details check

  • Thanks for help man, Just because it is not recommended and possibly cause performance problems I chose to change the query, limiting the return. Thank you very much. – Xablau Developer Oct 26 '17 at 17:55
0

In my case there were two object as one for service and second one for proxy. And I get it resolved by below commands

$bcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq ('Microsoft.SharePoint.BusinessData.SharedService.' + 'BdcServiceApplicationProxy')}

$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs[0]

$BCSThrottle

Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.