Page 1 of 1
unable to obtain exclusive access to this record - error
Posted: Tue 06 Mar 2018 17:01
by twong
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?
Re: unable to obtain exclusive access to this record - error
Posted: Wed 07 Mar 2018 19:29
by Shalex
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.
Re: unable to obtain exclusive access to this record - error
Posted: Wed 19 Sep 2018 14:07
by twong
I tried adding the property. Still no luck :(
Re: unable to obtain exclusive access to this record - error
Posted: Wed 26 Sep 2018 16:10
by Shalex
1. Is it possible that other package or other dataflow (or someone via web interface) works with the same Salesforce object in the same time?
2. Does the Salesforce object you update have any triggers?
3. Try disabling Bulk API by setting Bulk API=False in all Devart Salesforce Destination components that work with the Salesforce object you get "unable to obtain exclusive access to this record" with.