that would be a lot of semi-colons
This example uses MySQL, but you can modify it for your database.
tMySQLInput_1 -- > tFlowToIterate --> tSendMail
In tFlowToIterate uncheck "Use the default (key, value) in global variables" and create a key called "email_address", that is set to the email address field from your database input.
In the To field of tSendMail use: (String)globalMap.get("email_address")
"Agt_doc Process Failed at agt_spDocReport_Cat1;
Error message : ((String)globalMap.get("tRunJob_1_ERROR_MESSAGE"))"
This is what iam using in my tsendemail Message box . I am getting an error
Syntax error on tokens, delete these tokens
How do i resolve this. Please let me know
Here i am attaching a simple job using one tsend mail and i am getting this error.
Exception in component tSendMail_1
javax.mail.MessagingException: Exception reading response;
nested exception is:
javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
at javax.mail.Service.connect(Service.java:297)
at javax.mail.Service.connect(Service.java:156)
at javax.mail.Service.connect(Service.java:105)
at javax.mail.Transport.send0(Transport.java:168)
at javax.mail.Transport.send(Transport.java:98)
at test.tpop_test_0_1.tpop_test.tSendMail_1Process(tpop_test.java:434)
at test.tpop_test_0_1.tpop_test.runJobInTOS(tpop_test.java:647)
at test.tpop_test_0_1.tpop_test.main(tpop_test.java:513)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.AppInputStream.read(Unknown Source)
at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)
disconnected
... 10 more
Caused by: java.io.EOFException: SSL peer shut down incorrectly
at com.sun.net.ssl.internal.ssl.InputRecord.read(Unknown Source)
... 19 more
Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
How did you set your tsendmail component? The port is? Please upload your component setting screenshot into forum so that we can address your issue quickly.
Best regards
Sabrina
i am having only one tSendmail component that's it....
i am not able to upload the images anyway
to :"debashis@test.com"
from: "debashis@test.com"
show sender name : checked
sender name : "debashis"
smtp host: "smail.test.com"
smtp port :300
ssl report :checked
need authentication :checked
die on error :checked
username: debashis@test.com
password: mypass