AnsweredAssumed Answered

Retry Salesforce Sync after Sync Failure

Question asked by ad030a031a0b8c1e7e0521f26ccfebd87441958d on Oct 3, 2016
Latest reply on Oct 5, 2016 by 6dc2c32f2fe11d7787a5f9c6184e49c1157082b1

Periodically I see the Salesforce Sync Error "UNABLE_TO_LOCK_ROW" in our Marketo notifications.  I understand that this error is due to some other process (specifically, an Apex job)  running in our Salesforce org every hour and Marketo is trying to write to the same record(s).  If we decide that we can't get rid of this other process, is there a smart way to retry the Salesforce sync?  So far all I can come up with is a nightly batch campaign that looks for records that have not synced with Salesforce for 24 hours AND have had some type of activity (score change, filled out a form, changed status in any program) but with a fairly large database I'm not sure this is ideal.  Any other suggestions?