Salesforce Connect: Can't Sync the Schema Metadata for Your External System – Check That the Schema Metadata Is Valid. Error Code: Null
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.
- 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.
Related Articles
Replication: Table '...' Schema Validation Failed (Resolving 'Absent Columns' and 'Redundant Columns' Errors)
If you encounter the following errors in an integration, it means the schema of your data source no longer matches the schema Skyvia has cached: Error: "Integration failed: Table 'TableName' schema validation failed: Absent columns: 'FieldName1', ...
Resolving the "Inactive User" Error in Skyvia Salesforce Connections
The "inactive user" error occurs at the Salesforce connection level in Skyvia. It means that the Salesforce user account used for the connection is inactive or no longer valid, so Salesforce blocks API authentication. As a result, Skyvia cannot run ...
Connect: Plan Does Not Support Secure Endpoints
Secure endpoints (private endpoints with IP restrictions and user accounts) are available only in the Standard pricing plan. Public endpoints are the only option available in the Free and Basic pricing plans. If your endpoint is invalid or uses ...
Zoho CRM: An error occurred during login operation. Error: invalid_code
If you encounter the login error An error occurred during login operation. Error: invalid_code while connecting to Zoho CRM, it means the wrong Domain is selected in your Zoho CRM connection. To resolve the issue, open your connection settings, ...
UPDATED: Salesforce: Expired access/refresh token
Overview If you see an "expired access/refresh token" error, your Salesforce OAuth connection is invalid. This happens when the token has expired, been revoked, or invalidated by a Salesforce security policy change. Possible Causes The OAuth token ...