Salesforce and Syncing - "... It does not have 'IsDeleted' column."

  • 9Views
  • Last Post 2 weeks ago
  • Topic Is Solved
0
votes
Jacob Widmer posted this 2 weeks ago

Hey there,

Attempting to sync the RecordType table of a SFDC org to a table I've created in a Postgres database. Unfortunately getting the error:

Table cannot be used in synchronization. It does not have 'IsDeleted' column.


What would be the recommended way to get around this Skyvia limitation? I've attempted to add that column in Salesforce to no avail.

Any help appreciated, thanks.

1
votes
Mariia Zaharova posted this 2 weeks ago

The "IsDeleted" column is required for data changes tracking when using synchronization or replication (incremental updates).

The RecordType object doesn't have the "IsDeleted" column and, due to the fact that this is a system column, it cannot be created manually. Thus, the error you are getting while trying to create sync task is an expected one. 

If you are interested in a one-way integration from Salesforce to PostgreSQL database, you can use Replication package without Incremental Updates option.

For this select only "Drop Tables" and "Create Tables" check boxes for replicating such objects. In this case, the necessary database tables will be recreated each time the package is running.

 

See https://skyvia.com/resources/docs/index.html?how_to_create_replication_task.htm

 

If you have any further questions, feel free to contact us.

  • Supported by
  • Jacob Widmer
Close