Using SharePoint Designer 2010 to create a external content type and external list is a good choice and spent a lot of time. But when you open the external list in your browser you can get the following error.
Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.
The reason is very easy. If your source return more than 2000 elements this error occurred. So here are the solutions.
- Filter your data by using stored procedure, view etc. and make sure that you didn’t get more than 2000 elements.
- Change the Throttling settings
The default value of the throttling is 2000 elements. So you can edit this throttling by run the SharePoint 2010 Management Shell as Administrator.
The console will be open and you have to enter the following command:
You get a list of all Proxy Services. The Service “Business Data Connectivity Service” is important for us. The rest is in this case Trash .
Copy the GUID of the Business Data Connectivity Service and run the following comand, for showing the current throttling settings:
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottlyType Items -ServiceApplicationProxy <GUID>
For editing the current settings you have to save them into a global variable.
$db = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy <GUID>
Set-SPBusinessDataCatalogThrottleConfig -Identity $db -maximum 10000 -default 8000
Now the Throttling is set to a maximum of 10000 elements and a default value of 8000 elements. If you have a source with more then 1000 elements, then you have to set a higher value.