Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] How to configure tWarn -> tLogCatcher -> tLowRow? Or, wrong approach?

Hi,
My original configuration was:
MysqlOutput -> tLogRow
Once I started using tWarn and tLogCatcher the error message in tLogRow changed, not the expected data truncation error, but something that looks like this:
connecting to socket on port 3819
connected
2013-11-27 15:58:37|E2p8ae|E2p8ae|E2p8ae|DEMO|cl_ad__TO__dimListing|Default|4|tWarn|tWarn_1|this is a warning|42
disconnected

Wanted to use tLogCatcher since it can catch more errors and warnings than tLogRow can alone from my understanding, so I could get as many errors as possible going to one tSendMail component
What would be the best way to go in this situation? Original and modified canvases attached
Thank You 0683p000009MACn.png
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,
The purpose of tLogCatcher is operating as a log function triggered by one of the three: Java exception, tDie or tWarn, to collect and transfer log data.
For you truncation error, you have to use "Rejects" row in your job design.
That means there would be two input for tsendmail: tlogcatcher-->tsendmail(Java exception, tDie or tWarn)
RejectsRow-->(Data truncation, type mismatch...)
Best regards
Sabrina

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hi,
The purpose of tLogCatcher is operating as a log function triggered by one of the three: Java exception, tDie or tWarn, to collect and transfer log data.
For you truncation error, you have to use "Rejects" row in your job design.
That means there would be two input for tsendmail: tlogcatcher-->tsendmail(Java exception, tDie or tWarn)
RejectsRow-->(Data truncation, type mismatch...)
Best regards
Sabrina
Anonymous
Not applicable
Author

Ok thank You 0683p000009MACn.png
I used the only available connection type "Iterate" from tLogCatcher -> tSendMail and it seems to be working
Anonymous
Not applicable
Author

Hi,
I used the only available connection type "Iterate" from tLogCatcher -> tSendMail and it seems to be working

Could you please check your further problem in https://community.talend.com/t5/Design-and-Development/How-to-get-console-contents-into-tSendMail-em..., there is response from @shong.
Best regards
Sabrina