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
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
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: 
Ajay3
Contributor
Contributor
‎2020-12-24 03:43 AM

error logging mechanism

Hi Team,

I need a quick help. Talend only show the error as 'ORA-01722: invalid number' when it failed for number format exception. However I want to capture the column name and for which particular row the error is occurred. I need to captured that level of details in the file or table.

Can any one please let me know how I can achieve it.

Labels (3)
Labels
402 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2020-12-24 07:27 AM

Hello,

To find the row that's causing the problem, please connect a Rejects flow from tOracleOutput to tLogRow.

Let us know if it helps.

Best regards

Sabrina

402 Views
0 Likes
Ajay3
Contributor
Contributor
‎2020-12-24 12:17 PM
Author

Hi Sabrina,

 

yeah the one which you said i tried it only gives the number of entire rows which has issue and the error.

But I also want the specific column name and the value for which it is failing.

 

Can you please provide some input on this

Thanks

402 Views
0 Likes
Anonymous
Not applicable
‎2020-12-25 03:54 AM

In response to Ajay3

Hello,

Could you please elaborate your case with an example with expected output result?

Best regards

Sabrina

402 Views
0 Likes