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!
Here
is the reference of that article: http://sharepointknowledgebase.blogspot.com/2014/05/bcs-external-list-error-unable-to.html
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.
