topic Re: [resolved] Skip error rows in tOracleOutput in Talend Studio

[resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 10:12:21 GMT

Hi all,
I need to skip rows on error in tOracleOutput component and in advance settings I unchecked the "Die on error" option.
Then I tried inserting a record set. But this record set contains a row with the same primary key as one of the existing records in the table.
I expected the job to skip that row and insert the other rows of the set. But I didnt notice that. Can anyone tell me the reason for this?
Thanks.

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 10:51:49 GMT

As I figured out, Talend does not insert all the error-free rows in my records list. What it does is, it stops processing the records at the same point in both cases (ie, Die on error checked OR Die on error unchecked). The difference is, in the Die on error checked scenario, it rollbacks the changes. In Die on error unchecked scenario, it commits all the error-free rows up to that moment. So, in both cases all the rows after the point of failure are not committed to the database.
Please correct me if I am wrong. Thanks.

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 10:58:07 GMT

Hi,
Have you checked direct Error records to some output using Reject link from tOracleOutput component... in this case, it would redirect all the error records to another output and continue with other records...
This link is enabled when you de-select Batch Size option...
Try this.
Thanks
Vaibhav

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 11:05:20 GMT

Hi Vaibhav,
The thing is that my tOracleOutput component's action on data is 'Insert'. So I cannot use the reject link since it is disabled when I use the above option. Are there any other strategies to catch the rejected rows (in my case rows that create unique constraint violations).
Thanks.

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 11:11:57 GMT

That is not a problem, I think you are using Existing Connection (Disable that checkbox)... In advance properties, you will get that option.
Vaibhav

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 11:22:02 GMT

My 'Use an existing connection' option is unchecked. The Rejects link appear only when you switch to another 'Action on data' like 'Insert or update' or 'Update or insert' in 'tOracleOutput'.

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 11:37:59 GMT

This is not true... Which version of Talend you are using... there must be some problem in talend... Check the screenshot for Talend 5.3.0.xx. Action on Data is Insert and action on table is Default.
Talend team would test it for you...
thanks
Vaibhav

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 11:53:07 GMT

It is my mistake Vaibhav. Sorry I have mistaken 'commit size' to 'batch size'. Now the reject link appears. Thanks for your support.

Re: [resolved] Skip error rows in tOracleOutput

Anonymous — Mon, 07 Jul 2014 13:01:15 GMT

Oh... that's ok... Hope that you get the solution to your issue..
Thanks
Vaibhav