You need to sign in to do that
Don't have an account?
UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record
Hi,
I have a scheduled job which fires 2 chatter batch jobs. Both use the same opportunity and try to insert in to chatter "FeedItem" table separately.
I am getting below issue:
Failed to process batch for class 'OpportunityChatterBatchJob1' for job id '707C000000Id6tz'
caused by: System.DmlException: Insert failed. First exception on row 0; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record: []
I am thinking the issue could be because both batch jobs are trying to use same opportunity id for their feeds.
I cannot fire these jobs separately because for that I have to create an extra scheduled job.
Please let me know if my analysis of the issue is correct.
Is there any alternative to stop this error from occuring in the case of 2 batch jobs scheduled at same time?
or having an extra scheduled job is the only alternative?
Thanks,
Babu.
Hi
You could serialize the Batches
See the link below:
http://developer.force.com/cookbook/recipe/serialize-batch-apex
Hope that helps,
Roy Gilad
All Answers
Hi
You could serialize the Batches
See the link below:
http://developer.force.com/cookbook/recipe/serialize-batch-apex
Hope that helps,
Roy Gilad
Thank you..
Also just wanted to add a point, one batch job can be called thru other as per winter 13 release.
Thanks,
Babu.