topic How to find the rows responsible for runtime error messages? in Talend Studio

How to find the rows responsible for runtime error messages?

Konstantin_Lisyanskiy — Fri, 15 Nov 2024 23:23:55 GMT

Hi everybody,

I've got an issue loading data from a JSON file to MySQL.

Here is the Job:

Here is what I get when I run the job:

So, it seems that not every row makes it to the database.

Is there a way to understand what records/rows in what input files are responsible for those red error messages? Is there any kind of a detailed log?

Thanks in advance!

Regards,

Konstantin

Re: How to find the rows responsible for runtime error messages?

Anonymous — Wed, 22 Dec 2021 03:44:35 GMT

Hello,

Could you please let us know if this KB article helps for your use case?

https://community.talend.com/s/article/Data-truncation-Data-too-long-for-column-causes-wy9Uh

Best regards

Sabrina

Re: How to find the rows responsible for runtime error messages?

Konstantin_Lisyanskiy — Wed, 22 Dec 2021 10:32:16 GMT

Hi! Thanks for your reply. It kind of helps, but the question was not about how I fix this very problem. Rather it was about how I can trace to the root of the problem. Which could help fix this and some other future issues.

I also get this 'Missing property in path $ ['info']' among the messages. I do not understand what it means and what the source of it is.

So, this is, basically, about how I find where the issue is and understand what happens, not how to fix this specific issue.

Thanks for your help anyway! Appreciate it!

Re: How to find the rows responsible for runtime error messages?

gjeremy1617088143 — Thu, 23 Dec 2021 10:31:57 GMT

first you can desactivate all the components after the json component and link it to a tLogRow just to ensure that your problem not coming from the json