If you face the below issue while using external data type column in your project to fetch information from external system
“An error occurred while retrieving data from ResourceHub-Prod. Administrators, see the server log for more information”
Here is the resolution for you.
- This is security/Permission issue
- you need to set navigate to SharePoint admin center
- Click on BCS settings
- Click on
- Look out for your required BDC Model and then select Set Metadata store permissions to Execute for all the membership group
- Click on Secure Store Stettings
- Select the required Target Application ID
- Click Edit and Add the required groups for example (Everyone except external users) to Target members group.
This will resolve your permission issue and you can select your external fields 🙂
Happy SharePointing 🙂