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
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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: 
Anonymous
Not applicable
‎2019-12-19 10:00 AM

Talend Job Failure during Json Generation

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.
Labels (2)
Labels
190 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-12-20 03:09 AM
Author

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

190 Views
0 Likes