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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] send error code via tsendmail

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
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

24 Replies
Anonymous
Not applicable
Author

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

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?
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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!
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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?