You need to sign in to do that
Don't have an account?
Rupali Pophaliya
Email to Case error: UNABLE_TO_LOCK_ROW : unable to obtain exclusive access to this record
Hi,
We have set up Email to Case functionality. We are getting this error at least once in a day and the case is not opened:
We have gone through this knowledge Article: https://help.salesforce.com/apex/HTViewSolution?urlname=Email-to-Case-error-UNABLE-TO-LOCK-ROW-unable-to-obtain-exclusive-access-to-this-record&language=en_US (https://help.salesforce.com/apex/HTViewSolution?urlname=Email-to-Case-error-UNABLE-TO-LOCK-ROW-unable-to-obtain-exclusive-access-to-this-record&language=en_US)
But, when case is created, we are not updating any parent record of it.
What is the reason of this issue?
Thanks,
Rupali
We have set up Email to Case functionality. We are getting this error at least once in a day and the case is not opened:
UNABLE_TO_LOCK_ROW : unable to obtain exclusive access to this record
We have gone through this knowledge Article: https://help.salesforce.com/apex/HTViewSolution?urlname=Email-to-Case-error-UNABLE-TO-LOCK-ROW-unable-to-obtain-exclusive-access-to-this-record&language=en_US (https://help.salesforce.com/apex/HTViewSolution?urlname=Email-to-Case-error-UNABLE-TO-LOCK-ROW-unable-to-obtain-exclusive-access-to-this-record&language=en_US)
But, when case is created, we are not updating any parent record of it.
What is the reason of this issue?
Thanks,
Rupali
Now in the email to case scenario if multiple transactions are happening concurrently and all are trying to create contacts/cases( with same account record on lookup field) then there is always a small probabilty that one transaction holding the lock on particular account record will put the other transaction in record lock out phase( just because of skew).
Generally, salesforce platform processes more than billion transactions per day with average response time of less than 300 milliseconds and database holds a lock for a very short amount of time but due to skew which causes some lock contention and reduce database concurrency.