BDC Connection issue with SharePoint document library?

Question

I'm using SharePoint on-premises 2019 edition. I have document library having 2500 documents. At the starting I connected my database to SharePoint to fetch the details of employees based on their ID nos. Unfortunately I lost connection between my SharePoint library and database. When I tried to reconfigure the database it is showing that "Unable to render the data. If the problem persists, contact your web server administrator". for external list. In document library it won't fetch the data from db instead it showing an error.

I really not found any useful information in server logs. can any help me out with this.
i can do deleting the external column in list. if i do it I may loss all the loaded data for those 2500 items.
suggest me the solution with this.

Answer 1

Hi @Namadi Rakesh ,

The error message "Business Data Connectivity object not found. administrators, see the server log for more information" in SharePoint, it typically means that there is an issue with the Business Data Connectivity (BDC) service application. Here are a few things you can try to troubleshoot the issue:

1. Check the BDC service application: Make sure that the BDC service application is running and has been properly configured. You can check this by going to Central Administration > Application Management > Manage Service Applications, and then selecting the BDC service application. If the service application is not running or has not been configured correctly, you may need to troubleshoot or reconfigure it.
2. Check the permissions: Make sure that the account you are using to access the BDC service application has the necessary permissions. The account should be a member of the BDC service application's administrators group.
3. Check the server logs: As the error message suggests, you may be able to find more information about the issue in the server logs. Check the logs for any error messages related to the BDC service application or the specific object that you are trying to access.
4. Check the external system: If you are trying to access an external system through the BDC service application, make sure that the external system is running and accessible. You may need to troubleshoot the external system to resolve the issue.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.