topic Re: [resolved] Handling Database Warnings with Talend in Talend Studio

[resolved] Handling Database Warnings with Talend

Anonymous — Sat, 16 Nov 2024 11:49:06 GMT

Hi!
I'm receiving this warning message when I insert several data from a CSV file in a Database Table (the violation of a Constraint):
ORA-00001: unique constraint (XXXX.TABLE_UK_1) violated
How can I "ignore" the row that is causing this warning, and continue processing the remaining data?
Thanks.

Re: [resolved] Handling Database Warnings with Talend

Anonymous — Thu, 28 Nov 2013 12:23:31 GMT

Hi
It have ignored the rows that violates the unique constraint and continue to process the remaining data, if you check the 'die on error' option on DB output component, the job will throw the java exception and stop to execute; if you uncheck the 'die on error' option, the job will capture the problematic rows and continue to execute, link a rejects connector from DB output component to a tLogRow, you will see all the problematic rows, for example:
tFileInputDelimited--main--tOracleOutput--rejects--tLogRow
Shong

Re: [resolved] Handling Database Warnings with Talend

Anonymous — Thu, 28 Nov 2013 12:29:23 GMT

Thanks, I didn't know that!
Is that 'reject' a component? I'm using "Talend Open Studio for Data Integration, Version: 5.3.1", and I can't find it.

Re: [resolved] Handling Database Warnings with Talend

Anonymous — Thu, 28 Nov 2013 13:10:58 GMT

Hi
It is a connector, not a component, right lick on the tOracleOutput in this case and you will find it in the menu.
Shong

Re: [resolved] Handling Database Warnings with Talend

Anonymous — Thu, 28 Nov 2013 13:26:54 GMT

That option doesn't appear in my 'tOracleOutput' component... Just the Main option appears.

Re: [resolved] Handling Database Warnings with Talend

Anonymous — Thu, 28 Nov 2013 13:44:35 GMT

I found that it doesn't appear because the Batch option is selected
Thanks.