topic Re: Problem with tsalesforceoutput rejects when Commit level >1 in Talend Studio

Problem with tsalesforceoutput rejects when Commit level >1

FredC — Sat, 16 Nov 2024 09:31:49 GMT

Hello,

I have 2 problems with the tsalesforceoutput component (talend 6.2) :

1. II've set my commit level to 10

Each time I encounter a specificl kind of error, I have incorrect data returned in my reject flow (the data fields are not the data that causes the error)

The error is : "duplicate value found: unknown duplique une valeur dans l'enregistrement ID : ..."

When I get this error message the detail of the datas which should normally cause the error is not the good one

(I think it return the first line of the 10 rows that were upserted when the error occurs)

If I set the commit level to 1 : everything is correct (but the upsert take a lot more time to finish )

2. The second problem is that if I have a commit level of 10, my reject flow will have each error message repeted 10 times (I try also with 100 ... and I get 100 similiar lines of reject for each error (I solve this by adding a taggregaterow)

For the first point do you have a solution other then setting the commit level to 1?

Thanks

Re: Problem with tsalesforceoutput rejects when Commit level >1

Anonymous — Thu, 13 Jul 2017 16:57:14 GMT

When you set commit Level to 10, and get an error, are the 10 rows that are part of that batch rollbacked? Or the successful rows committed?

Generally with other database components, the whole batch will fail.

Re: Problem with tsalesforceoutput rejects when Commit level >1

Anonymous — Thu, 13 Jul 2017 17:00:43 GMT

Also make sure you are using compatible oracle drivers that works with the Java version you have.

Re: Problem with tsalesforceoutput rejects when Commit level >1

FredC — Thu, 13 Jul 2017 17:31:12 GMT

Thank you for your reply.

I didn't check that point, I will have to check next week.

Actually the goal of my post is the identification of the rejected line that cause the error but your remarks is to be checked also !

Re: Problem with tsalesforceoutput rejects when Commit level >1

FredC — Thu, 13 Jul 2017 17:35:52 GMT

@iburtally wrote:

Also make sure you are using compatible oracle drivers that works with the Java version you have.

It works as the upsert is correctly done in salesforce (except for the rejects that I want to be able to identify to correct the data in the source application)

(the component don't send data in an oracle database, it write in salesforce.com throught a webservice)

Re: Problem with tsalesforceoutput rejects when Commit level >1

Anonymous — Thu, 13 Jul 2017 19:25:19 GMT

Sorry my mistake. My reply for another post got posted here.

Re: Problem with tsalesforceoutput rejects when Commit level >1

jdope — Thu, 01 Mar 2018 02:51:55 GMT

You're not the only one! please Vote up these bugs:

https://jira.talendforge.org/browse/TDI-40156

https://jira.talendforge.org/browse/TDI-40145

(https://community.talend.com/t5/Design-and-Development/Problem-with-tsalesforceoutput-main-reject-flow-when-Commit/m-p/38898)