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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MAli_Khan923132608504
Contributor
Contributor

Error on Sending Email when using tSetKeyStore

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)

0693p000009J0RXAA0.png

Labels (2)
5 Replies
Anonymous
Not applicable

Hi

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

 

Regards

Shong

MAli_Khan923132608504
Contributor
Contributor
Author

0693p000009JN6hAAG.png0693p000009JN6rAAG.png0693p000009JN6mAAG.png0693p000009JN6cAAG.png

MAli_Khan923132608504
Contributor
Contributor
Author

i have uploaded the screenshots

Anonymous
Not applicable

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

MAli_Khan923132608504
Contributor
Contributor
Author

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.