Issue
I'm seeing the following write error message in the Heroku Connect dashboard logs, or in the sf_message field of the Trigger log table:
The record couldnt be saved because it failed to trigger a flow. A flow trigger failed to execute the flow with version ID {{SALEFORCE_ID}}. Flow error messages: This interview has been terminated as another interview in the same bulk execution request failed with the following error: An unhandled fault has occurred in this flow
An unhandled fault has occurred while processing the flow. Please contact your system administrator for more information. Contact your administrator for help.
Resolution
This error can happen if Heroku Connect is writing records to Salesforce and those record updates are triggering a Flow on the Salesforce side.
If you're seeing this error, it's possible that the way your Flow has been designed is preventing it from being able to keep up with the number of updates or changes that Heroku Connect is sending to Salesforce, or some other similar conflict around the data that Connect is trying to sync.
To resolve this error you will need to redesign the Flow so that it is able to process the number of record updates that Heroku Connect sends to Salesforce.