AnsweredAssumed Answered

UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record

Question asked by ad030a031a0b8c1e7e0521f26ccfebd87441958d on Dec 12, 2016
Latest reply on Dec 15, 2016 by Frank Breen

Hi everyone, we have an app in Salesforce, Rollup Helper, that runs a batch update every hour on Leads/Contacts where certain fields have changed.  This sometimes conflicts with Marketo sync, and so we get 50-100 leads that throw the error "UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record" which is clogging up our error logs. 


My initial thought was to create a nightly batch program to find records that have not synced with Salesforce within the previous 24-48 hours and also had some important update, like this:


Screen Shot 2016-12-12 at 10.14.50 AM.png


I'm curious to hear how other people have solved this problem.