search cancel

Email not going through Jasper Report

book

Article ID: 230398

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Email not going through Scheduled Jasper Reports also we are not able to download documents attached in attachment fields.

Downloading fields is giving Error 500.

Error Message:

2021-12-02 14:39:48,478 ERROR ReportExecutionJob,quartzScheduler_Worker-1:363 [] - The job error notification was not completed. An error occurred while sending it.

org.springframework.mail.MailSendException: Mail server connection failed; nested exception is javax.mail.MessagingException: Can't send command to SMTP host;

  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. Failed messages: javax.mail.MessagingException: Can't send command to SMTP host;

  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; message exception details (1) are:

Failed message 1:

javax.mail.MessagingException: Can't send command to SMTP host;

Environment

Release : All Release 

Component : CLARITY

Resolution

1. In the js.quartz.properties file, please defined the correct mail host name value to the report.scheduler.mail.sender.host property.
report.scheduler.mail.sender.host=smtphosthou.xvyxvxyxvy.com
Also, confirmed that the report.scheduler.web.deployment.uri property is defined correctly.
report.scheduler.web.deployment.uri=http://10.124.16.160:8085/reportservice/

2. Next, in the js.config.properties file, please confirmed that the deploy.base.local.url is defined correctly.
deploy.base.local.url=http://10.124.16.160:8085/reportservice/
If the deploy.base.url was previously defined with an error in the URL. please now defined the correct URL for the same.
deploy.base.url=http://qa-clarityppm-report.azure.xyzxyzxyz.com/reportservice/

3. Finally, in the applicationContext-report-scheduling.xml file, Please check that the mail.smtp.auth property is defined as true. The smtp.starttls.enable was defined as true in this file, but the same property was defined as false in the js.quartz.properties file. Also please confirm with your mail server admin, and this property needs to be false for your environment.

4. After saving all the changes, Please restart the Tomcat.

5. Schedule the Test Report