Fix “Unable to render the data. If the problem persists, contact your web server administrator.” Issue in SharePoint BCS

Problem:
Tried created an external list SharePoint 2016 using business data connectivity services, configured secure store target application and created external list in SharePoint. All went good, however the external list displayed this error message with a correlation ID.
Unable to render the data. If the problem persists, contact your web server administrator.

Unable to render the data. If the problem persists, contact your web server administrator.

Ran ULS Log viewer and found this message in the logs:
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.   

Solution:

The root cause of the problem is: The web application is not associated with the secure store service application. So, the solution is:

  • Go to SharePoint 2013/2016 Central Administration site
  • Application management >> Click on Configure service application associations under Service Applications.
  • Pick the web application in which your site exists, check the “Application proxy group” column >> Make sure the BDC and secure store service applications check boxes checked.service application association in sharepoint 2016

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

2 thoughts on “Fix “Unable to render the data. If the problem persists, contact your web server administrator.” Issue in SharePoint BCS

  • October 4, 2021 at 6:31 PM

    @Sal : Could you please suggest on it. While creating external list In SharePoint Online getting error “Unable to render the data. If the problem persists, contact your web server administrator” and Co-relation ID.After that i changed the Authentication Mode to BDC identity but when I do that I get another error “The metadata object that has Name ‘DATABASENAME’ has a property with name ‘Authentication Mode’ and value ‘RevertToSelf’. This value indicates that the runtime should revert to the identity of the application pool, but reverting to the application pool is not permitted for partitioned service application”
    Please note that i added all required accounts (Including EveryOne Group) as well.

    Reply
  • October 19, 2018 at 2:18 AM

    Yes. This post resolved my issue.

    Reply

Leave a Reply