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 an external list in SharePoint. All went well; 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.

I 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 - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

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

  • @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
  • Yes. This post resolved my issue.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *