How to find the rows responsible for runtime error messages?

[Konstantin_Lisyanskiy]

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

[Anonymous]

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

[Konstantin_Lisyanskiy]

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!

[gjeremy1617088143]

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