Problem with Send Job Status Notifications

Job: Immediate Execution (ID: ......) Report unit: ...... Quartz Job:
ReportJobs.job_...... Quartz Trigger: ReportJobs.trigger_......_0 Exceptions:
fail to send out alert mail notification
com.jaspersoft.jasperserver.api.JSExceptionWrapper:
javax.mail.internet.AddressException: Illegal address in string ``'' at
org.springframework.mail.javamail.MimeMessageHelper.parseAddress(MimeMessageHelper.java:708) at
org.springframework.mail.javamail.MimeMessageHelper.setTo(MimeMessageHelper.java:592) at
com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobAlertImpl.sendAlertMail(ReportExecutionJobAlertImpl.java:78) at
com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendAlertMail(ReportExecutionJob.java:594) at
com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:574) at
com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:217) at
com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:49) at
org.quartz.core.JobRunShell.run(JobRunShell.java:213) at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

Cause

When a job alert or status notification is sent, it also copies the job initiator and the organization administrators. "Job initiator" is the user who creates the scheduled report job or runs the report in the background mode. "Organization administrators" are those users who have the organization ROLE_ADMINISTRATOR role and belong to the same organization as the user who creates the report job. If any of them does not have an e-mail address in the user profile table (jiuser.emailaddress), then the entire e-mail will fail.

Resolution

We are currently working on a fix to solve this problem. Until a fix is made available, users need to make sure all their users in repository user table have e-mail address provided. This can be done through Manage - User tab in JasperReports Server web UI, then edit and enter an e-mail address for each user. If e-mail addresses are provided to those users, even with a fake one, at least the job alert/status notification will be sent to the intended recipients. Any cc'ed recipient with fake address will be rejected by the mail service, but this will not block any good recipients from getting the e-mail. Therefore, users can make a whole sale DB update using the following query, if they do not wish to edit each user profile manually and individually:

update jiuser set emailaddress = 'johndoe@fakedomain.com' where emailaddress = '' or emailaddress is null

TTC 20140206