Understanding the common UNABLE TO LOCK ROW issue with bulk data job
Every time a record is inserted or updated, Salesforce must lock the target records that are selected for each lookup field; this practice ensures that, when when the data is committed to the database, its integrity is maintained. Learn how to avoid the "Unable to lock row" error while uploading large records in Salesforce. Below, are some sample scenarios to help you better understand the issue and how to resolve it: Sample scenario : ---------------------- Here, the "Order Detail" object is the main object on which we want to perform a DML operation and "Order__c" is the parent of "Order Detail" object. A. Process: --------------- 1. User can make an upsert/insert call on "Order Detail" object, lets take an example of upsert. 2. Wherein external ID is "Order_Detail_Id__c" B. What's happening at the back end? ------------------------------------------------ 1. When we do an Upsert call on "Order