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

Highlighted
One Star

[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 Smiley Happy

Accepted Solutions
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

Ok thank You Smiley Happy
I used the only available connection type "Iterate" from tLogCatcher -> tSendMail and it seems to be working
Moderator

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

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 Forum 33055, there is response from @shong.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog