The ability to define external lists is a real cool new feature of SharePoint 2010. When we defined an external list for rather large table we got a very vague error when the table was rendered:
“Unable to display this Web Part. To troubleshoot the problem open this page in a Microsoft SharePoint-compatible HTML editor such as Microsoft SharePoint designer.
When opening the mobile view we got:
“Database connector throttled the response. The response from the database contains more than ‘2000’ rows. The maximum number of rows that can be read through the Database connector is ‘2000’. The limit can be changed via ‘Set-SPBusinessDataCatalogThrottleConfig’ cmdlet.
As the error message suggests the problem lies in the fact that the SPBusinessDataCatalogThrottleConfig has to be increased.
To do this:
- On the SharePoint server, go to the command prompt.
- Start powershell.
- Find the Guid-ID for the BCS service application through Get-SPServiceApplicationProxy. You get a result similar as below.
- Type Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy <GUID-ID>.
- Execute the following commands:
- $Db = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy <GUID-ID>
- Set-SPBusinessDataCatalogThrottleConfig -Identity $Db -maximum 25000 -default <new-default>
- Where new-default is a value above 2000.
- Now the list should be displayed.