I am doing a data load and I am getting the following error.
Any help would be much appreciated!
UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 1 records: 0013600000H1ljyAAB:--
Thanks!
6 件の回答
Hi Tom, The short version is that two things are trying to access the same account record at the same time. Now I'm going to guess what you're thinking: "But I'm not loading any accounts!" - that may be true, but I bet you're loading something that's
related to an account, maybe with a master-detail relation? In that case, every record you update also locks the account for a split second.
So here are a few things to do:
1. Disable any automation you have on the object that you're importing. This includes Apex triggers, processes, workflow rules, etc.
2. If you're loading large files, consider splitting them into several smaller ones.
3. If you're loading very large files, consider using the Bulk API (https://help.salesforce.com/articleView?id=loader_configuring_bulk_api.htm&type=5)
4. Make sure you're importing your file during a downtime, where no other users would be likely to be working on the system
5. Make sure there are no background processes that could be updating records and locking accounts
