[resolved] Paramétrage du tSendMail

[Anonymous]

Bonjour,
J'ai : tMSSqlInput => tMap => tMSSqlOutput
|| on sub job error
||
tSendMail

Dans le corps du message du composant tSendMail, comment faire pour afficher toutes les données
que je vois apparaître dans la console?
Merci de votre aide

[Anonymous]

Quand je paramétrer la TSendMail (voir écran capure) je recoit bien l'e-mail mais sans le message d'erreur de la console: "Bonjour, Une erreur levai dans le travail de Talendnull "

[Anonymous]

Hi,
I have seen your screenshot.
Put string into tsendmail message body as follows:

"Hello the error message is "+((String)globalMap.get("tFixedFlowInput_1_ERROR_MESSAGE"))

What's your actual error of tMap in console?
Best regards
Sabrina

[Anonymous]

I obtain the same result(profit). I receives the email with " null " as error message

[Anonymous]

Hi,
What's the error message of tMap? java exception, or compile error?
Best regards
Sabrina

[Anonymous]

Here is the error message :
Démarrage du job OBJ_MESURES_METEO a 11:22 21/03/2014.
connecting to socket on port 3483
connected
Impossible d'insérer une ligne de clé en double dans l'objet 'dbo.OBJ_MESURES_METEO' avec un index unique 'PK_OBJ_MESURES_METEO'.
Exception in component tMap_4
java.lang.NullPointerException
at java.math.BigDecimal.add(Unknown Source)
at iac_dev.obj_mesures_meteo_1_2.OBJ_MESURES_METEO.tMSSqlInput_5Process(OBJ_MESURES_METEO.java:1807)
at iac_dev.obj_mesures_meteo_1_2.OBJ_MESURES_METEO.runJobInTOS(OBJ_MESURES_METEO.java:5527)
at iac_dev.obj_mesures_meteo_1_2.OBJ_MESURES_METEO.main(OBJ_MESURES_METEO.java:5327)
disconnected
Job OBJ_MESURES_METEO terminé à 11:22 21/03/2014.

[Anonymous]

Hi aurelie2014,
Try this solution to see if it is OK with you.
Using TalendHelpCenter:tLogcatcher to fetch set fields and messages from Java Exception, tDie and/or tWarn.
Please have a look at my screenshots
Best regards
Sabrina

[Anonymous]

It works. It is great, thank you very much 🙂

[Anonymous]

In Java, what is that you know how we show in the tSendMail the message in the console in black :
" Impossible to insert a line of key in double(copy) into the object ' dbo. OBJ_MESURES_METEO ' with a unique(only) index ' PK_OBJ_MESURES_METEO ' "

[Anonymous]

Hi,
You can use a custom component called tRedirectOutput to redirect the entire message printed on the console to a text file, and send an email with the file if the job run fails, the job design looks like:
tFileInput--main--tFileOutPut
|
onsubjoberror
|
tSendmail
About tRedirectOutput component, please read this topic:
http://www.talendforge.org/forum/viewtopic.php?pid=108078#p108078.
Best regards
Sabrina

[Anonymous]

Hi,
Thank you for your answer.
I met u other problem, I added 4GO of RAM and 3 processors on the remote desktop. Then when I executed the job Talend, I obtain the following error:
"Exception in component tMSSqlOutput_3
java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:410)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.tFileInputDelimited_3Process(Alim_Mesures_METEO_Temp.java:1648)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.runJobInTOS(Alim_Mesures_METEO_Temp.java:5992)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.runJob(Alim_Mesures_METEO_Temp.java:5783)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.tFileList_1Process(Alim_Mesures_METEO.java:786)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.runJobInTOS(Alim_Mesures_METEO.java:3675)

at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.main(Alim_Mesures_METEO.java:3463)
Caused by: java.net.SocketException: No buffer space available (maximum connections reached?): connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)

Exception in component tRunJob_3
java.lang.RuntimeException: Child job running failed
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.tFileList_1Process(Alim_Mesures_METEO.java:808)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.runJobInTOS(Alim_Mesures_METEO.java:3675)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.main(Alim_Mesures_METEO.java:3463)"

What is that you know the cause of this error?