Fix Salesforce Connect Schema Metadata Sync Error

Salesforce Connect: Can't Sync Schema Metadata (Error Code: Null)

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.

    • Related Articles

    • Salesforce: Inactive User Error

      Overview 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 ...

    • Connect: Plan Does Not Support Secure Endpoints

      Overview Secure endpoints (private endpoints with IP restrictions and user accounts) are available only in the Standard and Professional pricing plans. Public endpoints are the only option available in the Free and Basic pricing plans. If your ...

    • Zoho CRM: invalid_code Login Error

      Overview If you encounter the error "An error occurred during login operation. Error: invalid_code" while connecting to Zoho CRM in Skyvia, it means the wrong Domain is selected in your Zoho CRM connection settings. Resolution Open your Zoho CRM ...

    • Replication: Schema Validation Failed (Absent Columns / Redundant Columns)

      Overview 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: "Integration failed: Table 'TableName' schema validation failed: Absent columns: 'FieldName1', ...

    • 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 ...