-
In case of parallel data loading, how to avoid record locked error in Salesforce?
In case of parallel data loading, how to avoid record locked error in Salesforce?
-
2 Replies
-
Record locked error can be avoided by two ways
Change schema of Object : Check every Lookup field and make sure that in Lookup Option you have notselected “Don’t allow deletion of the lookup record that’s part of lookup relationship”. Because of this selection, even during insert operation system hold lock against record and other batches accessing same record fails.
Order Insert operations in CSV File : In this option, Sort column containing parent record Id for Lookup fields. So all records of same parent will be loaded in same batch and parent record locked problem across batch will be resolved -
Check your code mainly triggers written on code or code entry may have FOR UPDATE clause included in them. Remove them and it will work fine.
Log In to reply.
Popular Salesforce Blogs
Integrate Salesforce with AI to Increase Efficiency and Improving Customer Experience
Transform sales and customer services with AI: Salesforce Integrates Generative AI Improves Automation, Personalization & Predictive Analytics to Boost Enterprise Success In the increasingly competitive…
Migrating Your Existing Salesforce and Jira Integration to Sinergify
Migration process, ugh! That’s the usual expression when we hear about switching from one technology or tool to another. And that’s because transitioning to a…
Your Journey to Salesforce to Becoming a Salesforce Developer
As an informational guide for Salesforce beginners and anyone who would like to start a career in it, this article assembles the basic knowledge about…
Popular Salesforce Videos
4 Tips on How to Build Product Messaging & Positioning That Stands Out | Salesforce on Salesforce
Messaging and positioning work together and should be the North Star for any product launch. If done well, it will set you apart from the…
How to Delete Preloaded Sample Data in New Salesforce Organizations
When Users begin a trial or subscription with Salesforce, their org comes with a set of sample data. This data includes Accounts, Contacts, and Opportunities.…
Done With Training But Not Getting Salesforce Interview Calls, What To Do?
To sum up, choosing a Salesforce Career will be a better option than any other profession seeing the opportunities that it is creating in the…