unable to obtain exclusive access to this record - error

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
twong
Posts: 2
Joined: Thu 21 Dec 2017 19:40

unable to obtain exclusive access to this record - error

Post by twong » Tue 06 Mar 2018 17:01

My SSIS package is doing an update on records within Salesforce. It's using a "Devart Salesforce Destination" control. I believe the common issue for this error (not specific to this control) is multiple threads trying to update things at the same time. However, there is no setting for controlling a thread count. Any thoughts?

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: unable to obtain exclusive access to this record - error

Post by Shalex » Wed 07 Mar 2018 19:29

twong wrote:I believe the common issue for this error (not specific to this control) is multiple threads trying to update things at the same time.
The reasons of the error are described at https://salesforce.stackexchange.com/qu ... his-record.
twong wrote:However, there is no setting for controlling a thread count. Any thoughts?
Please right click Devart Salesforce Destination > Show Advanced Editor > Component Properties and try setting ParallelBatchProcessing=False.

Post Reply