Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2010-12-20 03:41 AM

How to capture ORA- errors into a file or table

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
Labels (2)
Labels
712 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2010-12-20 11:26 AM
Author

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
505 Views
0 Likes
Anonymous
Not applicable
‎2010-12-20 11:16 PM
Author

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
505 Views
0 Likes
Anonymous
Not applicable
‎2010-12-21 12:39 AM
Author

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
505 Views
0 Likes
Anonymous
Not applicable
‎2010-12-21 01:21 AM
Author

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
505 Views
0 Likes
Anonymous
Not applicable
‎2012-02-09 10:14 AM
Author

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
505 Views
0 Likes
janhess
Creator II
Creator II
‎2012-02-09 10:55 AM

Go to advanced settings and deselect Use Batch Size.
505 Views
0 Likes
Anonymous
Not applicable
‎2012-02-10 10:31 AM
Author

Thanks a lot , it worked !!!
505 Views
0 Likes
Anonymous
Not applicable
‎2012-11-13 05:56 AM
Author

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
505 Views
0 Likes
Anonymous
Not applicable
‎2013-09-16 09:07 AM
Author

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