topic Re: [resolved] send error code via tsendmail in Talend Studio

[resolved] send error code via tsendmail

Anonymous — Sat, 16 Nov 2024 13:07:29 GMT

Hi all
I wan to send the error code via a tsendmail componenet,but I don't know how to manage it .Someone says that if you press Ctrl and Space,you will get the list of variables,but in fact,it's seems no use.
Thank you for your suggestion in advance.A sample would be the best.
We are using TOS 4.1.1

Re: [resolved] send error code via tsendmail

Anonymous — Wed, 26 Jan 2011 08:52:48 GMT

Hello
What's error code you want to send on tSendmail? capture by tLogCatcher?
Best regards
Shong

Re: [resolved] send error code via tsendmail

Anonymous — Wed, 26 Jan 2011 09:02:30 GMT

Hi
Yes,I want to catch the exeception and send it to others mailbox via tsendmail. In addition,I also want to send the error java code ,is there a way to solve the problem?

Re: [resolved] send error code via tsendmail

Anonymous — Wed, 26 Jan 2011 10:10:57 GMT

Hello
The job looks like:
...
tLogCatcher--main-->tLogRow--main-->tJavaRow
|
onsubjobok
|
tSendMail
on tJavaRow:
globalMap.put("error_code", input_row.message);
on the message filed of tSendMail:
(String)globalMap.get("error_code")
Best regards
Shong

Re: [resolved] send error code via tsendmail

Anonymous — Wed, 26 Jan 2011 13:50:08 GMT

Hello,
I read post about tlogcatcher, but i not able to use it.
I'd like to get all messages error or warning. for example i have this when i run job into talend
Unknown column 'Infinity' in 'field list'
Unknown column 'Infinity' in 'field list'
Unknown column 'Infinity' in 'field list'
Unknown column 'Infinity' in 'field list'
2011-01-26
i'd like to get errors when the job is running into a bat file. and then send a mail.
is it possible?
thanks

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 08:17:30 GMT

Thank you shong,it works.
Hi claudine,just try it as shong's method,you will get what you want.

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 08:27:50 GMT

Hi Joe,
you know what ? i could'nt put a "onsubjobok" because as it was test i use composant tfileoutputexcel instead of tsendmail. and it was impossible to connect 2 lines fromtLogCatcher.
thanks for your answer, sorry for my mistake!

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 08:34:25 GMT

Hi Claudine
Can you upload a screenshot of your job? What's your design problem?
Best regards
Shong

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 08:52:29 GMT

Hello Shong,
here is screen shot.
I don't know how to connect TlogCatcher.
the goal is to get all errors, even warning, in this example,
its a bat file running every night.
i divide by zero, so i get "message infinity..;" and the database is not updated.
in that case i'd like to have a mail
regards,
claudine

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 08:56:25 GMT

Hi shong
I have created a context and defined some global various in the context. Here is the problem: can I display the value of various I have defined in the mail sent via tsendmail? In other words,can I display the content of context in the mail sent via tsendmail?

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 09:03:04 GMT

Hello Joe,
i already do that
regards,
claudine

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 09:04:08 GMT

hello claudine
Have you tried to use a tDie or tWarn at the end of your job by OnSubjobError,and then use a tcatchlog to catch it ?

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 09:09:30 GMT

You're right, if i use a TDie, job will stop, and i can fetch message of tdie in mail.
I did'nt think about that before, thanks, i'll do that.
i'have to keep watch all bat jobs!

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 09:16:04 GMT

Is "chemin" the variable name that you have defined?

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 09:21:39 GMT

yes,
all the mail use context variable. except the sender

Re: [resolved] send error code via tsendmail

Anonymous — Thu, 27 Jan 2011 09:25:59 GMT

I'll have a try tomorrow,as the server is in busy working now. Thanks for your suggestion

Re: [resolved] send error code via tsendmail

Anonymous — Fri, 28 Jan 2011 08:41:44 GMT

hello,
i don't understand how to connect tLogCatcher,
why is it impossible to have a main line with a DbConnexion?
how this component works?
thanks
claudine

Re: [resolved] send error code via tsendmail

Anonymous — Fri, 28 Jan 2011 09:20:34 GMT

Hi,
I don't know java...
i tried the Shong solution with mail and i have those error, and realy not understand,
can you help?
thanks

Re: [resolved] send error code via tsendmail

Anonymous — Fri, 28 Jan 2011 09:42:32 GMT

Hi claudine,
I'm sorry that in fact, I don't know ,even alittle,about French. But , pls delete the ";"in your tsendmail first,it needn't.and then try it again.

Re: [resolved] send error code via tsendmail

Anonymous — Fri, 28 Jan 2011 09:55:04 GMT

About tlogCatcher, you needn't to connect it to any component but tLogRow. And you can use a tDie connect with your main job with OnComponentError/OnSubjobError.
The tLogCatcher will catch the exeception automatic.