TsalesforceOutput Upsert Issue

yalecat — Mon, 30 Sep 2024 14:44:04 GMT

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.

Please help

Thanks

Re: TsalesforceOutput Upsert Issue

yalecat — Mon, 30 Sep 2024 14:59:17 GMT

The issue got resolved. There must have been some bug in the Tsalesforceoutput component. I deleted it and added again. And now it's working.

topic Re: TsalesforceOutput Upsert Issue in Talend Studio

TsalesforceOutput Upsert Issue

Re: TsalesforceOutput Upsert Issue