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

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

  • 20Views
  • Last Post 05 October 2018
  • Topic Is Solved
0
votes
Jacob Widmer posted this 04 October 2018

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.

salesforce data-integration synchronization postgresql data-synchronization
1
votes
Mariia Zaharova posted this 05 October 2018

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
New Ticket
Categories
Popular Tags
Close