unable to obtain exclusive access to this record - error
unable to obtain exclusive access to this record - error
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
The reasons of the error are described at https://salesforce.stackexchange.com/qu ... his-record.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.
Please right click Devart Salesforce Destination > Show Advanced Editor > Component Properties and try setting ParallelBatchProcessing=False.twong wrote:However, there is no setting for controlling a thread count. Any thoughts?
Re: unable to obtain exclusive access to this record - error
I tried adding the property. Still no luck :(
Re: unable to obtain exclusive access to this record - error
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.
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.