I am trying to update Salesforce records using tSalesforceOutput component using action 'Update'.
But I am getting below error, can someone please help me on this.
Starting job a_corporate_td_to_sfdc at 07:13 22/05/2017.
[statistics] connecting to socket on port 3742
Exception in component tSalesforceOutput_2
java.lang.Exception: unable to obtain exclusive access to this record
Job a_corporate_td_to_sfdc ended at 07:16 22/05/2017. [exit code=1]
This means this record is locked by someone else.
Usualy, if you retry it will be ok or it means there is a transaction engaged on Salesforce side which never stops (surprising because of the Salesforce limits).
Can you share a little more such as job design?
I tried multiple times on different days, but still same issue persists.
Please find the attached snapshots, it is simple update.
I tried to run by disable the insert link, but no luck.
Probably due to a trigger, a workflow or a process builder or any Salesforce internal event which fire during the job execution.
Try to do the same operation using DataLoader to verifiy if the same issue occurs or not.
Else, try to define the Salesforce connection first (before the subjob), then reuse it for both operation (insert and update).
I tried with the solution you provided (use Salesforce connection before the sub job).
But still getting same error message.
I don't have permission to install software, so I am unable to use DataLoader.
Please find the attached snapshot for tmap4.
I haven't received a clear solution for my issue.
Since it is Prod environment, It will be difficult to remove ownerId and load the data.
And it was working fine before. I have added new null handling methods in one of the tmap (tmap4) due to the null pointer exception, after that change, this deadlock issue started.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.