Trying to replicate data from ZohoCRM to Postgres on-prem DB. Initially had some issues with the sync, but it started yesterday. Took 15 hours(!) to run but was completed this morning. Unfortunatley I am seeing that over half of my contacts weren't imported, with the following error insert or update on table ""Contacts"" violates foreign key constraint
Most of my other tables also encountered an issue when they were imported, with a similar error message.
Any suggestions on how I can fix this? I want to ensure all of my records are imported successfully, otherwise what is the point??