-
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
Reimagining User Experience with Salesforce to Drive a Better Customer Experience
The end user delivering the service must be the first objective in the pursuit of a better customer experience. This is especially true for any…
Drag and Drop Address Field on Google Map | Salesforce Help Guide
Why we need Why we need this type of Address functionality - In the business there are lots of accounts (Person/Business account) and we need…
The Secret of Successful Companies: Meet and Keep Your Customers With Salesforce CRM
Various researches have shown that a satisfied customer is the best advertisement. They remain loyal both to the brand and the product and rarely think…
Popular Salesforce Videos
Why iCompliance Trusts TechForce Services for Salesforce Managed Services | Client Testimonial
At iCompliance, delivering trusted AFSL compliance services requires seamless operations and efficient technology. That’s why they turned to TechForce Services for Salesforce Managed Services. In…
Salesforce For Beginners | Introduction To Salesforce | Salesforce CRM Development Tutorials
In this video, BeginIT provides an introduction to Salesforce, including its difference from legacy CRM systems. And also, BeginIT explains the procedure to create an…
WWE Connector for Salesforce
In this quick video we will show the Workspace Web Edition Connector for Salesforce. The WWE Connector leverage a powerful browser extension to guarantee a…
