Hi,
I’m trying to use Sync to replicate data from Salesforce into a Postgres database. I have a full load working, and every night it truncates then reloads the tables.
I’m having a lot of problems setting up another job that then runs an incremental update periodically. It seems straightforward to set up. My jobs incremental settings are:
- Start Date: 2026-01-06
- Replication Interval : 1 day
When I run the job, I consistently get the same error, regardless of which Salesforce object I try to incrementally update. In this case my source is Building__c, and the destination is the Postgres table salesforce.building.
The error I get is: [0] Updating Row is failed. ERROR: Server error [SQL state: 42P01]: relation "salesforce_building__r_1329269084" does not exist (Character 13) , AffectedCount: 0
I can’t find any mention of this type problem in the documentation, and have followed all the steps in the docs to set this up.
Has anyone else encountered something like this, or perhaps have an idea on what I might try changing?
Thanks!
