topic Re: Talend Job Failure during Json Generation in Talend Studio

Talend Job Failure during Json Generation

Anonymous — Thu, 19 Dec 2019 15:00:32 GMT

Hi Team, I have a talend job which pulls data from Teradata table and generates JSon using TWriteJson Component and Loads the Json in a Postgre table. Compoents involved on the jobs design Teradata Input Tmap TWriteJson PostgreSQLOutput The Terdata table has 9 million records and while running the Job, the job ended with error. Around 500,000 records were read from Teradata , Json has been generated only for aroung 60,000 records and then job ended with error. I could not find the exact issue why i failed. I want to add a component in the job which can capture the error , if any issues encountered during JSON generation. Please advise. Thanks.

Re: Talend Job Failure during Json Generation

Anonymous — Fri, 20 Dec 2019 08:09:19 GMT

Hello,

Please have a look at this component tLogCatcher which operates as a log function triggered by one of the three: Java exception, tDie or tWarn, to collect and transfer log data.

Here is online component reference:https://help.talend.com/reader/zEy_94YeKg9FVbqEiggFag/3E57vFmO99ifmffP_nb_Ew

Could you please open the error log generated automatically by the Studio to see whether you have error stack trace there?

In your Studio, click Window to open the menu, then select Show View->General->Error Log. Once you see an error, double click it.

Best regards

Sabrina