My _trigger_log has records with state='READONLY'

Issue

I'm making updates to mapped tables in Postgres but Heroku Connect is not syncing the changes to Salesforce. The changes appear in my _trigger_log, but the state is READONLY not PENDING or SYNCED or FAILED.

Resolution

When you see a READONLY state in the _trigger_log, it means that Heroku Connect detected a change to a mapping that is read-only. When this happens, the change is recorded as if it would be synced to Salesforce, but it is never synced.

To resolve this, you can modify the mapping to be read / write. That will allow future changes made in Postgres to be captured and synced to Salesforce. You can also update the records in the _trigger_log to be synchronized as if they were new by changing their state column from READONLY to NEW:

UPDATE salesforce._trigger_log SET state = 'NEW' WHERE state = 'READONLY' AND table_name = '<NEWLY READ/WRITE TABLE NAME>';

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support
Terms of Service Privacy Cookies © 2018 Salesforce.com