topic Re: How to capture ORA- errors into a file or table in Talend Studio

How to capture ORA- errors into a file or table

Anonymous — Sat, 16 Nov 2024 13:10:30 GMT

I am trying to find out how to capture Oracle error, like Unique Key constraint violation error eg: ORA-00001: unique constraint (SHICKL.ROW_UID_PK) violated.
I need to capture above mentioned error in to a file. Right now the above error can be visible in RUN area or execution area.
Please suggest me how do catch the ORA error in Talend in a file or table
Thanks,
Vivek Jayapalan

Re: How to capture ORA- errors into a file or table

Anonymous — Mon, 20 Dec 2010 16:26:35 GMT

We can use the Row Rejects link on the tOracleOutput component to capture the row errors. This will work only in a non-batch mode.
tFileInputDelimited_1 --(row1:Main)--> tOracleOutput_1 --(row2:Rejects)--> tFileOutputDelimited_1
Here row2 is a rejects (Row: Rejects) link from tOracleOutput_1 to tFileOutputDelimited_1.
Regards,
Abhi

Re: How to capture ORA- errors into a file or table

Anonymous — Tue, 21 Dec 2010 04:16:39 GMT

Hello Abhi,
There is no option for reject link from toracleoutput.
tfileinputdelimited ---> row(Main)---> toracleoutput --->row(Main)<Only row main is available> --> tfileoutputdelimited

What i could fina an option was the below method, But error_code and error message is coming null, but i can see the ORA error in the run screen.
tfileinputdelimited ---> row(Main)---> toracleoutput
|
|
|------> row(Reject)---> tfileoutputdelimited
Thanks,
Vivek Jayapalan

Re: How to capture ORA- errors into a file or table

Anonymous — Tue, 21 Dec 2010 05:39:59 GMT

Re: How to capture ORA- errors into a file or table

Anonymous — Tue, 21 Dec 2010 06:21:18 GMT

Hello Abhi,
Your Idea is working fine, i have removed the Batch option from the tOracleoutput, then i could see the Reject row link.

Thanks a lot...
Vivek Jayapalan

Re: How to capture ORA- errors into a file or table

Anonymous — Thu, 09 Feb 2012 15:14:59 GMT

Hi,
I am working Talend DI version 5.0.1 and i want to capture the rejected rows from tOracleOutPut to a tFileOutPutDelimited.
But i am not able to see the reject option on tOracleOutPut. Can anyone please help me on this?
Many Thanks,
Manju

Re: How to capture ORA- errors into a file or table

janhess — Thu, 09 Feb 2012 15:55:07 GMT

Go to advanced settings and deselect Use Batch Size.

Re: How to capture ORA- errors into a file or table

Anonymous — Fri, 10 Feb 2012 15:31:29 GMT

Thanks a lot , it worked !!!

Re: How to capture ORA- errors into a file or table

Anonymous — Tue, 13 Nov 2012 10:56:05 GMT

Thanks - that s what I need
We can use the Row Rejects link on the tOracleOutput component to capture the row errors. This will work only in a non-batch mode.
Go to advanced settings and deselect Use Batch Size.

ps ? about speed - seems it will be slowly

Re: How to capture ORA- errors into a file or table

Anonymous — Mon, 16 Sep 2013 13:07:14 GMT

Hi !
Can we use this logic for tgreenplumrow ?
tgreenplumrow->reject
|
oncomponentok
|
tgreenplumcommit

Re: How to capture ORA- errors into a file or table

Anonymous — Thu, 20 Oct 2016 14:45:02 GMT

Hi Team,
Still rowreject count is zero. after advanced settings and deselect Use Batch Size..
Please any suggestion.

Thanks
shridhar

Re: How to capture ORA- errors into a file or table

Anonymous — Thu, 26 Jul 2018 13:26:24 GMT

Create a error table with the same structure of the table with datatype of all columns as varchar2(2000) and then add 2 more columns ERRORCODE and ERRORMESSAGE again same datatype.

Add this into Talend job and then from the main table link this table with reject connector.

This works even in batch mode, I tested it. It will capture all error records including the error code and error message into the newly created error table.

Hope this helps.

Error_Capturing.png