Showing posts with label sharepoint bcs unable to display this web part. Show all posts
Showing posts with label sharepoint bcs unable to display this web part. Show all posts

21 May, 2014

BCS - Unable to display this Web Part

Todays article is based on the same error message on which I had publish one article few days before but while trying to replicate the same steps in different farm, I came across some useful findings which will be definitely useful for all the SharePoint communities!


Once I will share the ULS logs here then you will get the complete idea clear as how it’s different from the above reference along with different resolution steps.

Note:
If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

How to reproduce this issue? – If you know how to reproduce then you will find out the resolution also, sooner/later but solution will be there J

Problem description: Error while creating the list from external content type.

Error Message:
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.
Correlation ID: 675b973c-cd4a-4b1f-9e1a-86918a35fd16

Here are those steps: (You have already published the external content type (CT) by using SharePoint Designer and now you need to create a list based on that CT).

1.   Open your site -> View all site content
2.   Create
3.   List
4.   External List
5.   Create
6.   Type the name of the list
7.   Display list in quick launch: NO
8.   Type this name in the external content type section “New external content type” and click on check if this external CT exists
9.   Create -> you will get the error!

ULS logs findings:
Error while executing web part: Microsoft.BusinessData.Infrastructure.BdcException: Database response throttled. Maximum number of rows that can be read through the database system utility is 2000 The shim execution failed unexpectedly - Secure Store Service did not performed the operation.. ---> System.ServiceModel.CommunicationException: Secure Store Service did not performed the operation.     at Microsoft.Office.SecureStoreService.Server.SecureStoreServiceApplicationProxy.Execute[T](String operationName, Boolean validateCanary, ExecuteDelegate`1 operation)     at Microsoft.Office.SecureStoreService.Server.SecureStoreServiceApplicationProxy.GetRestrictedCredentials(Guid rawPartitionId, String applicationId)     at Microsoft.Office.SecureStoreService.Server.SecureStoreProvider.GetRestrictedCredentials(String appId)     at Microsoft.SharePoint.BusinessData.SystemSpecific.Db.DbConnectionManager.GetCo

It took some time to find out the resolution but I wanted to save your time, I wanted to save the frustration when we faced such issues and finally I would like guide you in right direction so that you can resolve this issue successfully!

Here are the Resolution Steps: This is because of BCS default throttling limits.

Step:-1: Get the GUID of BCS and Note down the BCS Application GUID
Get-SPServiceApplicationProxy

Steps:-2: Check the BCS Throttling Configuration Current Value
Get-SPBusinessDataCatalogThrottleConfig
Scope - Database
Throttle type - Items
ServiceApplicationProxy - <GUID of BCS>

Here is the output you will get:
Scope        : Database
Throttle Type: Items
Enforced     : True
Default      : 2000
Max          : 1000000

Step:-3:  Set the BCS throttle configuration
$db=Get-SPBusinessDataCatalogThrottleConfig -Scope Database -Throttle Type Items -ServiceApplicationProxy <GUID of BCS>

Set-SPBusinessDataCatalogThrottleConfig -Identity $db -Maximum 1000000 –Default 40000

Step:-4: Verify the increased throttle value
Get-SPBusinessDataCatalogThrottleConfig
Scope - Database
Throttle type - Items
ServiceApplicationProxy – <GUID of BCS>

Output:
Scope        : Database
Throttle Type: Items
Enforced     : True
Default      : 40000
Max          : 1000000

That’s it – You are done! & check the results.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.