Overview

This error occurs because the object used in your endpoint does not have a primary key column. Salesforce requires a primary key for external objects, which is why you encounter an error when validating and syncing your External Data Source in Salesforce. At this stage, External Objects are being created.

Resolution

• If the object is a table (rather than a database view), add a primary key column to the table in the database and then re-add it to the endpoint model.
• If the object is a database view, or if adding a primary key column is not possible, you can manually designate any column as the Entity Key directly in the endpoint model.