-
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 - [adinserter block='9']
-
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
Send Email to Salesforce Sales Cloud Data from Marketing Cloud Using Import and Automation Filter Activity
Go through this blog to have a better understanding of how import and automation filter activity works in Salesforce Marketing Cloud. Requirement: We want to…
Top 5 Challenges CFOs Face When Implementing CPQ
The automation of business operations currently holds a leading position in the development priorities of many firms. Automation has developed new forms and capabilities since…
7 Essential Salesforce Hacks For Beginners
Salesforce CRM is an incredibly powerful tool for sales and customer relations. Through Salesforce you can manage customer details and sales prospects as well as…
Popular Salesforce Videos
Marketing Cloud To Become Customer Company
Leverage Marketing Cloud's ability to engage customers by delivering premium personalized experiences and building meaningful relationships with them. Contact Cyntexa to boost your business with…
What is Audit Trail in Salesforce?
Audit Trails helps to track the recent setup changes that you and other administrators have made to your organization. Watch this video to learn about…
Predicted Job Growth of Salesforce Business Analysts
In this video, Ben Analyst predicts the potential future growth of Salesforce. He compares the growth of Salesforce to other companies' growth rates and also…
