search cancel

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 Clarity PPM SaaS

Issue/Introduction

Jaspersoft scheduled reports are not getting delivered after upgrading 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.

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 username and password fields need to be left out because the O365 SMTP server is expecting anonymous access

Environment

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=

Save and restart Jaspersoft