Bulk API Error: UNABLE_TO_LOCK_ROW:unable to obtain exclusive access to this record or 124 recordsUNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record:UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this recordUNABLE_TO_LOCK_ROW - InsertUNABLE_TO_LOCK_ROW Error with Test ClassBulk API Row Lock RootWhich toolstechniques are you using to improve performance of mass deletion of custom object records?Facing record lock issue on Parent when loading millions recordsGroupMember lockingSalesforce Bulk API Unable to lock rowUsers getting “Unable to obtain exclusive access” Error
Is being an extrovert a necessary condition to be a manager?
Is a world with one country feeding everyone possible?
Existence of a model of ZFC in which the natural numbers are really the natural numbers
Gas chromatography flame ionization detector (FID) - why hydrogen gas?
What pc resources are used when bruteforcing?
Can a UK national work as a paid shop assistant in the USA?
Team member is vehemently against code formatting
Keeping the dodos out of the field
why "American-born", not "America-born"?
Can the Conjure Barrage spell stack with the Disarming Attack or Trip Attack Battle Master maneuvers?
JavaScript: Access 'this' when calling function stored in variable
Way of refund if scammed?
Variable does not Exist: CaseTrigger
Why is unzipped file smaller than zipped file
What is the winged creature on the back of the Mordenkainen's Tome of Foes book?
Ratings matrix plot
csname in newenviroment
How to tease a romance without a cat and mouse chase?
Are there any tips to help hummingbirds find a new feeder?
Congruence, Equal, and Equivalence
Wifi light switch needs neutral wire. Why? AND Can that wire be a skinny one?
How do you earn the reader's trust?
Efficient Algorithms for Destroyed Document Reconstruction
Meaning of "half-crown enclosure"
Bulk API Error: UNABLE_TO_LOCK_ROW:unable to obtain exclusive access to this record or 124 records
UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record:UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this recordUNABLE_TO_LOCK_ROW - InsertUNABLE_TO_LOCK_ROW Error with Test ClassBulk API Row Lock RootWhich toolstechniques are you using to improve performance of mass deletion of custom object records?Facing record lock issue on Parent when loading millions recordsGroupMember lockingSalesforce Bulk API Unable to lock rowUsers getting “Unable to obtain exclusive access” Error
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
During the process of loading 90,000 opportunities into Salesforce using the Bulk API, I get this error:
UNABLE_TO_LOCK_ROW:unable to obtain exclusive access to this record or 124 records...
After the error there is a long list of Account record Id's.
- I am using a batch size of
10,000 - All processes, flows and work flows are off
- All triggers are disabled.
I am unsure why this is happening...
Questions
- Why am I getting this error?
- What can I do I better understand the error?
- How might fix it?
opportunity bulk-api locking
asked May 8 at 13:27
RobsRobs
2,905843
add a comment |
During the process of loading 90,000 opportunities into Salesforce using the Bulk API, I get this error:
UNABLE_TO_LOCK_ROW:unable to obtain exclusive access to this record or 124 records...
After the error there is a long list of Account record Id's.
- I am using a batch size of
10,000 - All processes, flows and work flows are off
- All triggers are disabled.
I am unsure why this is happening...
Questions
- Why am I getting this error?
- What can I do I better understand the error?
- How might fix it?
opportunity bulk-api locking
asked May 8 at 13:27
RobsRobs
2,905843
add a comment |
During the process of loading 90,000 opportunities into Salesforce using the Bulk API, I get this error:
UNABLE_TO_LOCK_ROW:unable to obtain exclusive access to this record or 124 records...
After the error there is a long list of Account record Id's.
- I am using a batch size of
10,000 - All processes, flows and work flows are off
- All triggers are disabled.
I am unsure why this is happening...
Questions
- Why am I getting this error?
- What can I do I better understand the error?
- How might fix it?
opportunity bulk-api locking
asked May 8 at 13:27
RobsRobs
2,905843
During the process of loading 90,000 opportunities into Salesforce using the Bulk API, I get this error:
UNABLE_TO_LOCK_ROW:unable to obtain exclusive access to this record or 124 records...
After the error there is a long list of Account record Id's.
- I am using a batch size of
10,000 - All processes, flows and work flows are off
- All triggers are disabled.
I am unsure why this is happening...
Questions
- Why am I getting this error?
- What can I do I better understand the error?
- How might fix it?
opportunity bulk-api locking
opportunity bulk-api locking
asked May 8 at 13:27
RobsRobs
2,905843
asked May 8 at 13:27
RobsRobs
2,905843
asked May 8 at 13:27
RobsRobs
2,905843
asked May 8 at 13:27
RobsRobs
2,905843
asked May 8 at 13:27
RobsRobs
2,905843
2,905843
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
A great resource for understanding row locking situations is the Record Locking Cheat Sheet (PDF link). Note at the top of page 2 that insert, update, and delete of Opportunities locks the parent Account.
Since your batch job is running in parallel across its batches, the batches can independently attempt to gain locks on the same Account, resulting in this exception.
There's a couple of different strategies you can apply.
- Sequence the inbound Opportunities by Account Id. This will limit lock contention between batches running in parallel, although it may or may not be enough to completely eliminate it if Opportunities on the same Account sometimes overlap batch boundaries.
- Ask the Bulk API to process in serial mode to eliminate contention between batches (see here for details on this configuration in the Salesforce Data Loader; other clients might have slightly different setup).
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
2
You sir are a gentleman and a scholar.
– Robs
May 8 at 13:35
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f261638%2fbulk-api-error-unable-to-lock-rowunable-to-obtain-exclusive-access-to-this-rec%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
A great resource for understanding row locking situations is the Record Locking Cheat Sheet (PDF link). Note at the top of page 2 that insert, update, and delete of Opportunities locks the parent Account.
Since your batch job is running in parallel across its batches, the batches can independently attempt to gain locks on the same Account, resulting in this exception.
There's a couple of different strategies you can apply.
- Sequence the inbound Opportunities by Account Id. This will limit lock contention between batches running in parallel, although it may or may not be enough to completely eliminate it if Opportunities on the same Account sometimes overlap batch boundaries.
- Ask the Bulk API to process in serial mode to eliminate contention between batches (see here for details on this configuration in the Salesforce Data Loader; other clients might have slightly different setup).
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
2
You sir are a gentleman and a scholar.
– Robs
May 8 at 13:35
add a comment |
A great resource for understanding row locking situations is the Record Locking Cheat Sheet (PDF link). Note at the top of page 2 that insert, update, and delete of Opportunities locks the parent Account.
Since your batch job is running in parallel across its batches, the batches can independently attempt to gain locks on the same Account, resulting in this exception.
There's a couple of different strategies you can apply.
- Sequence the inbound Opportunities by Account Id. This will limit lock contention between batches running in parallel, although it may or may not be enough to completely eliminate it if Opportunities on the same Account sometimes overlap batch boundaries.
- Ask the Bulk API to process in serial mode to eliminate contention between batches (see here for details on this configuration in the Salesforce Data Loader; other clients might have slightly different setup).
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
2
You sir are a gentleman and a scholar.
– Robs
May 8 at 13:35
add a comment |
A great resource for understanding row locking situations is the Record Locking Cheat Sheet (PDF link). Note at the top of page 2 that insert, update, and delete of Opportunities locks the parent Account.
Since your batch job is running in parallel across its batches, the batches can independently attempt to gain locks on the same Account, resulting in this exception.
There's a couple of different strategies you can apply.
- Sequence the inbound Opportunities by Account Id. This will limit lock contention between batches running in parallel, although it may or may not be enough to completely eliminate it if Opportunities on the same Account sometimes overlap batch boundaries.
- Ask the Bulk API to process in serial mode to eliminate contention between batches (see here for details on this configuration in the Salesforce Data Loader; other clients might have slightly different setup).
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
A great resource for understanding row locking situations is the Record Locking Cheat Sheet (PDF link). Note at the top of page 2 that insert, update, and delete of Opportunities locks the parent Account.
Since your batch job is running in parallel across its batches, the batches can independently attempt to gain locks on the same Account, resulting in this exception.
There's a couple of different strategies you can apply.
- Sequence the inbound Opportunities by Account Id. This will limit lock contention between batches running in parallel, although it may or may not be enough to completely eliminate it if Opportunities on the same Account sometimes overlap batch boundaries.
- Ask the Bulk API to process in serial mode to eliminate contention between batches (see here for details on this configuration in the Salesforce Data Loader; other clients might have slightly different setup).
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
answered May 8 at 13:33
David Reed♦David Reed
42.7k82463
42.7k82463
2
You sir are a gentleman and a scholar.
– Robs
May 8 at 13:35
add a comment |
2
You sir are a gentleman and a scholar.
– Robs
May 8 at 13:35
2
2
You sir are a gentleman and a scholar.
– Robs
May 8 at 13:35
You sir are a gentleman and a scholar.
– Robs
May 8 at 13:35
add a comment |
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f261638%2fbulk-api-error-unable-to-lock-rowunable-to-obtain-exclusive-access-to-this-rec%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
