- While updating external list with a workflow you may often get the error “The workflow could not create the item in the external data source. Make sure the user has permissions to access the external data source and create items.”. To avoid this, you must use Secure Store ID for the External Content Type, and the App Pool account for the content web application must be included as a member of that SSID. Also the app pool account must have permissions to the ECT entity in the BDC service application.
- External lists are not flexible enough as compared to regular list when it comes to customization of forms with InfoPath. External list forms do not support additional data connections.
- When ever you make changes to the BDC entity, it happens to lose the permissions on the BDC entity. You always have to set permissions.
- Updater method in BCS modal never provides detailed and proper information in Trace logs if any error occurs, but Creator method always provides detailed information to the point. So do the Creator method first and correct any Data Type mismatches and then Updater should work fine.
- In order to implement Update/Delete/Insert operations on an external list using BCS modal (code solution), the underlying table must have a Primary Key
Advertisement
