Proxy creation failed. Unable to get the application proxy.

I have publishing the external content type via SharePoint Designer and it’s been successfully displayed in the Central Administration too but while adding the list on the site; it’s throwing an error as follows

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.

I checked the logs and found the following traces:

Proxy creation failed. Unable to get the application proxy

Error while executing web part: Microsoft.BusinessData.Infrastructure.BdcException: The shim execution failed unexpectedly - Unable to obtain the application proxy for the context.. ---> Microsoft.Office.SecureStoreService.Server.SecureStoreServiceException: Unable to obtain the application proxy for the context.     at Microsoft.Office.SecureStoreService.Server.SecureStoreProvider.get_Proxy()     at Microsoft.Office.SecureStoreService.Server.SecureStoreProvider.GetRestrictedCredentials(String appId)     at Microsoft.SharePoint.BusinessData.SystemSpecific.Db.DbConnectionManager.GetConnection()     at Microsoft.SharePoint.BusinessData.SystemSpecific.Db.DbSystemUtility.ExecuteStatic(IMethodInstance methodInstance, ILobSystemInstance lobSystemInstance, Object[] args, IExecutionContext context...     c8cfe618-7d0b-4dd0-bb87-55fe239f183b

There are most probably two possible reasons for this issue as:

1.   Service connection proxy

2.   Displaying number of records in a list as there is default value: 2000

Let’s try to see the resolutions for both the reasons!

Resolution#1: (for Service connection proxy)

1.   Open the central administration

2.   Application management

3.   Service Applications

4.   Configure service application associations

5.   Check the web application in which your site exist

6.   Check the “application proxy group” column

7.   Make sure the BDC and secure store service applications check boxes are mark,

8.   If they are not then please tick the check box and click OK

Resolution#2: (for displaying number of records)

1.   Open the SharePoint 2010 management PowerShell console

2.   Type the following command: Get-SPServiceApplicationProxy

3.   You will get the list of service application along with their GUID’s

4.   Copy the BCS service application GUID and paste it in notepad

5.   Now check the existing values by using this command:

Get-SPBusinessDataCatalogThrottleConfig-Scope ThrottleType Items Database-GUID-ServiceApplicationProxy

6.   Once you know the values then you will come to know that the default value is 2000 and we need to change that! How? See below-

Get-SPBusinessDataCatalogThrottleConfig –Scope Database –ThrottleType Items –ServiceApplicationProxy $contosoServAppProxy | Set-SPBusinessDataCatalogThrottleConfig –Maximum 1000000000 –Default 500000

Reference:

a)   http://technet.microsoft.com/en-us/library/ff607904%28v=office.15%29.aspx

b)   http://blogs.msdn.com/b/bcs/archive/2010/02/16/bcs-powershell-introduction-and-throttle-management.aspx

That’s it- You are done. Check your results now and the error shouldn’t be there now!

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.

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.

Product Applies To:

SharePoint Server 2010

Business Data Catalog

   The BDC is essentially a catalog of business applications that are of interest to SharePoint Server 2007 users, and it bridges the gap between the portal and business applications by bringing in key data from various applications to SharePoint sites, lists, search, and user profiles. The BDC is the key infrastructural component around which most of the other business data features of SharePoint Server 2007 are built. Administrators can register business applications in the BDC, after which the data in the application is immediately available to SharePoint through the business data features described below. A key requirement for each registered business application is an XML-based metadata model that describes the application programming interfaces (API) of the application or the schema of the database that maps to business objects (e.g. customer) and properties (e.g. name) that a SharePoint user can understand. These metadata models can be easily created by DBAs or database developers.

Business Data Web Parts

SharePoint Server 2007 ships with four out-of-the-box Business Data Web Parts: Business Data List, Business Data Items, Business Data Related List, and Business Data Actions. These Web Parts rely on the Business Data Catalog, and their main purpose is to display business data in a portal application without the need for any programming. Moreover, these Web Parts are generic and can show any type of data (entity) registered in the Business Data Catalog.

These Web Parts support Web Part Connections, which enable Master-Detail types of data display – again, without any programming. For example, you can display customers and their details using the BusinessDataList and BusinessDataItems Web Parts.

Web Part	Description
Business Data List Web Part	Displays a list of entity instances from a business application registered in the Business Data Catalog. For example, you can use a Business Data List Web Part to display all the customers or orders from the AdventureWorksDW database.
Business Data Items Web Part	Displays the details of an entity instance from a business application. For example, you can use a Business Data Items Web Part to display the details of a particular customer or order from the AdventureWorksDW database.
Business Data Related List Web Part	Displays a list of related entity instances from a business application. For example, you can use a Business Data Related List Web Part to display all the orders for a particular customer from the AdventureWorksDW database.
Business Data Actions Web Part	Displays a list of actions associated with an entity as defined in the Business Data Catalog. For example, you can use a Business Data Actions Web Part to display all the actions that portal users can perform on the Customer entity. Some examples of these actions are to send e-mail to a customer or edit the address of a customer.

Business Data in Lists

Windows SharePoint Services V3 provides custom field types. SharePoint Server 2007 leverages this feature to provide a new field type called Business Data that is available to all lists in SharePoint Server 2007. The Business Data field type enables users to add data from business applications registered in the Business Data Catalog to any SharePoint list. For example, in your RFP (Request for Proposal) Document Library, you can add a Business Data column to the document properties that specifies the customer who issued the RFP. This enables users to view the customer’s details and perform actions associated with them from within the Document Library.

Business Data Actions

You can define actions for each entity in the Business Data Catalog. Some examples of actions for a customer entity are to send e-mail to a customer or to edit the address of a customer. Business Data Catalog implements actions as links that allow you to navigate to a URL directly from the page where the entity or Business Data column is displayed. For example, these links can open Web pages, display the native graphical user interfaces (GUI) of line-of-business applications, and launch Microsoft® Office InfoPath® forms.

Business Application Search

By leveraging the Business Data Catalog, the Search Center feature of SharePoint Server 2007 can gather and index data from all of the registered business applications and provide full-text searching. For example, after you register the AdventureWorksDW sample database from SQL Server 2005 in the Business Data Catalog, the Search Center feature can crawl the database and return customer data in search results. In addition, the Search Center feature’s extensibility enables you to create customized search experiences. For example, you can create a Customers tab in the Search Center where users can search strictly for customers in the AdventureWorksDW database.