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
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 ...
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', ...
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, ...
Skyvia Backup Errors Caused by Salesforce API Requirements
Skyvia interacts with Salesforce via its API. During a backup operation, you may encounter errors due to certain limitations or behaviors specific to the Salesforce API. For example, when Skyvia performs a backup or replication, it queries all the ...