topic Re: Error on Sending Email when using tSetKeyStore in Talend Studio

Error on Sending Email when using tSetKeyStore

MAli_Khan923132608504 — Sat, 16 Nov 2024 01:38:25 GMT

Withouut tSetKeyStore my job is working fine when adding tSetKeyStore, getting this error

Exception in component tSendMail_1 (testjob)

javax.mail.MessagingException: Exception reading response;

nested exception is:

javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

at com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)

Re: Error on Sending Email when using tSetKeyStore

Anonymous — Fri, 21 Aug 2020 05:58:11 GMT

Can you upload some screenshots of tSetKeystore and tSendMail settings? It might give us some clues.

Regards

Shong

Re: Error on Sending Email when using tSetKeyStore

MAli_Khan923132608504 — Mon, 24 Aug 2020 05:46:32 GMT

Re: Error on Sending Email when using tSetKeyStore

MAli_Khan923132608504 — Mon, 24 Aug 2020 05:56:31 GMT

i have uploaded the screenshots

Re: Error on Sending Email when using tSetKeyStore

Anonymous — Mon, 24 Aug 2020 21:36:37 GMT

This could be a number of things. Keystores and creating p12 keystores can be notoriously hard to get right. This looks like the issue you are having. Google the error message and you will find a number of suggestions. I would try and narrow it down for you, but I do not have your keystore or the certificates you are using to do this.

On another note, your linkage in the job looks a bit weird. You appear to be linking your DBOutput component to your DBInput using an OnComponentOK link. Why are the subjobs not linked via the tRest component using an OnSubJobOK link? I assume that the two subjobs are to be run sequentially

Re: Error on Sending Email when using tSetKeyStore

MAli_Khan923132608504 — Wed, 26 Aug 2020 07:04:55 GMT

i have to send the email AFTER DBoutput OnComponentOK after this i have to get the data from DBInput and send it in email in the form of table.

Already google this error but no success.

If you want i will send my keystore.