I am upserting data into salesforce object based on a external ID. There are no duplicates in the source data file. I am able to insert data but unable to upsert data. I even tried to set the batch size to 1 just for testing purposes. I get this error:
failed to release the resource in tSalesforceOutput_1 :duplicate value found: xxx_External_ID__c duplicates value on record with id: xxxxxxxxxxxxxxxxxx
The external ID is set up on the object. I used the same data source to upsert data using another tool (workbench) and it works fine. But in talend I am unable to UPSERT. I have used upsert in other talend jobs and it works fine.
