topic error logging mechanism in Talend Studio

error logging mechanism

Ajay3 — Sat, 16 Nov 2024 00:54:02 GMT

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.

Re: error logging mechanism

Anonymous — Thu, 24 Dec 2020 12:27:15 GMT

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

Re: error logging mechanism

Ajay3 — Thu, 24 Dec 2020 17:17:42 GMT

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

Re: error logging mechanism

Anonymous — Fri, 25 Dec 2020 08:54:52 GMT

Hello,

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

Best regards

Sabrina