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.

1 comment:

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.