SharePoint 2010 and BCS – Unable to display this Web Part

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.

  1. Filter your data by using stored procedure, view etc. and make sure that you didn’t get more than 2000 elements.
  2. 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:

Get-SPServiceApplicationProxy

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.

Source

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: