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

Multi tool use
Multi tool use

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;








3















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



  1. Why am I getting this error?

  2. What can I do I better understand the error?

  3. How might fix it?









share|improve this question




























    3















    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



    1. Why am I getting this error?

    2. What can I do I better understand the error?

    3. How might fix it?









    share|improve this question
























      3












      3








      3








      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



      1. Why am I getting this error?

      2. What can I do I better understand the error?

      3. How might fix it?









      share|improve this question














      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



      1. Why am I getting this error?

      2. What can I do I better understand the error?

      3. How might fix it?






      opportunity bulk-api locking






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked May 8 at 13:27









      RobsRobs

      2,905843




      2,905843




















          1 Answer
          1






          active

          oldest

          votes


















          8














          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.



          1. 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.

          2. 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).





          share|improve this answer


















          • 2





            You sir are a gentleman and a scholar.

            – Robs
            May 8 at 13:35











          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
          );



          );













          draft saved

          draft discarded


















          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









          8














          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.



          1. 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.

          2. 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).





          share|improve this answer


















          • 2





            You sir are a gentleman and a scholar.

            – Robs
            May 8 at 13:35















          8














          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.



          1. 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.

          2. 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).





          share|improve this answer


















          • 2





            You sir are a gentleman and a scholar.

            – Robs
            May 8 at 13:35













          8












          8








          8







          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.



          1. 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.

          2. 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).





          share|improve this answer













          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.



          1. 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.

          2. 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).






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered May 8 at 13:33









          David ReedDavid Reed

          42.7k82463




          42.7k82463







          • 2





            You sir are a gentleman and a scholar.

            – Robs
            May 8 at 13:35












          • 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

















          draft saved

          draft discarded
















































          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.




          draft saved


          draft discarded














          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





















































          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







          9LYVe 3NmUc6 vq0Zb,cAGHMu,A3 QNTf
          pyFH97eQiDzUONJPO5 E9JB,FWbucY1u6 Q3yeCRj,Od 62,iUtBNxJdcaRry6MjZx5k4hW9wqYim,Cq3uQ5zq1smb0X5O

          Popular posts from this blog

          RemoteApp sporadic failureWindows 2008 RemoteAPP client disconnects within a matter of minutesWhat is the minimum version of RDP supported by Server 2012 RDS?How to configure a Remoteapp server to increase stabilityMicrosoft RemoteApp Active SessionRDWeb TS connection broken for some users post RemoteApp certificate changeRemote Desktop Licensing, RemoteAPPRDS 2012 R2 some users are not able to logon after changed date and time on Connection BrokersWhat happens during Remote Desktop logon, and is there any logging?After installing RDS on WinServer 2016 I still can only connect with two users?RD Connection via RDGW to Session host is not connecting

          Vilaño, A Laracha Índice Patrimonio | Lugares e parroquias | Véxase tamén | Menú de navegación43°14′52″N 8°36′03″O / 43.24775, -8.60070

          Cegueira Índice Epidemioloxía | Deficiencia visual | Tipos de cegueira | Principais causas de cegueira | Tratamento | Técnicas de adaptación e axudas | Vida dos cegos | Primeiros auxilios | Crenzas respecto das persoas cegas | Crenzas das persoas cegas | O neno deficiente visual | Aspectos psicolóxicos da cegueira | Notas | Véxase tamén | Menú de navegación54.054.154.436928256blindnessDicionario da Real Academia GalegaPortal das Palabras"International Standards: Visual Standards — Aspects and Ranges of Vision Loss with Emphasis on Population Surveys.""Visual impairment and blindness""Presentan un plan para previr a cegueira"o orixinalACCDV Associació Catalana de Cecs i Disminuïts Visuals - PMFTrachoma"Effect of gene therapy on visual function in Leber's congenital amaurosis"1844137110.1056/NEJMoa0802268Cans guía - os mellores amigos dos cegosArquivadoEscola de cans guía para cegos en Mortágua, PortugalArquivado"Tecnología para ciegos y deficientes visuales. Recopilación de recursos gratuitos en la Red""Colorino""‘COL.diesis’, escuchar los sonidos del color""COL.diesis: Transforming Colour into Melody and Implementing the Result in a Colour Sensor Device"o orixinal"Sistema de desarrollo de sinestesia color-sonido para invidentes utilizando un protocolo de audio""Enseñanza táctil - geometría y color. Juegos didácticos para niños ciegos y videntes""Sistema Constanz"L'ocupació laboral dels cecs a l'Estat espanyol està pràcticament equiparada a la de les persones amb visió, entrevista amb Pedro ZuritaONCE (Organización Nacional de Cegos de España)Prevención da cegueiraDescrición de deficiencias visuais (Disc@pnet)Braillín, un boneco atractivo para calquera neno, con ou sen discapacidade, que permite familiarizarse co sistema de escritura e lectura brailleAxudas Técnicas36838ID00897494007150-90057129528256DOID:1432HP:0000618D001766C10.597.751.941.162C97109C0155020