Clarity Advanced Reporting scheduled reports with an email output doesn't work

book

Article ID: 224001

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Jaspersoft scheduled reports are not getting delivered after upgrading to Clarity 15.9 and Jaspersoft 7.1 > 7.8. The config worked fine in 7.1 server, and no changes to the email config files before/after upgrade. Scheduling a report with an email output doesn't work and when creating a schedule, no emails get produced.  Also, all existing schedules with an email output doesn't work.

Here is the error in the Jaspersoft.log:

2021-08-24T15:52:27,080 ERROR SecureExceptionHandlerImpl,quartzScheduler_Worker-2:116 [] - fail to send out alert mail notification
2021-08-24T15:52:27,080 ERROR ReportExecutionJob,quartzScheduler_Worker-2:367 [] - fail to send out alert mail notification
org.springframework.mail.MailAuthenticationException: Authentication failed; nested exception is javax.mail.AuthenticationFailedException: 535 5.7.3 Authentication unsuccessful

 at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:425) ~[spring-context-support-4.3.23.RELEASE.jar:4.3.23.RELEASE]
 at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:346) ~[spring-context-support-4.3.23.RELEASE.jar:4.3.23.RELEASE]
 at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:341) ~[spring-context-support-4.3.23.RELEASE.jar:4.3.23.RELEASE]
 at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobAlertImpl.sendAlertMail(ReportExecutionJobAlertImpl.java:97) ~[jasperserver-api-engine-impl-7.8.0.jar:?]
 at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.JaaSReportExecutionJobAlertImpl.sendAlertMail(JaaSReportExecutionJobAlertImpl.java:64) ~[ca-jasper-extensions.jar:?]
 at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendAlertMail(ReportExecutionJob.java:768) [jasperserver-api-engine-impl-7.8.0.jar:?]
 at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:607) [jasperserver-api-engine-impl-7.8.0.jar:?]
 at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:249) [jasperserver-api-engine-impl-7.8.0.jar:?]
 at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:47) [ji-report-options-api-7.8.0.jar:?]
 at org.quartz.core.JobRunShell.run(JobRunShell.java:202) [quartz-2.3.2.jar:?]
 at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?]
Caused by: javax.mail.AuthenticationFailedException: 535 5.7.3 Authentication unsuccessful

Cause

The the username and password fields do need to be left out because the O365 SMTP server is expecting anonymous access

Environment

Clarity 15.9 / Jaspersoft 7.8

Resolution

In a server file called js.quartz.properties on the Jaspersoft server remove username and password values from the properties file and the mail authentication is successful, i.e., emails for the scheduled reports are now getting delivered to Clarity users.

report.scheduler.mail.sender.username=
report.scheduler.mail.sender.password=