Unified Reporter: Unable to receive reports

Document ID : KB000072794
Last Modified Date : 08/03/2018
Show Technical Document Details
Introduction:
This article covers the essential configuration tasks required to schedule report jobs and send them via email, for CA Unified Reporter version 8.31. The two key steps are as follows: 
 
  • Setting up an SMTP mail server
  • Scheduling a job to send a report via email
Background:
Customers may encounter different issues when trying to schedule report jobs and email them to their customers/users. This article covers the most common areas that need to be considered, e.g., configuration for scheduling reports and mail server setup.
Environment:
CA UIM 8.31, 8.51
CA Unified Reporter 8.31
Instructions:
Setting up an SMTP server - an abridged version of the doc section that covers this is as follows.
 
1. Edit the js.quartz.properties file in waspprobes\service\wasp\webapps\jasperserver-pro\WEB-INF
and add SMTP server settings. The file below uses gmail only as an example.
 
# This file is now just a pass-through for stuff in the file referenced by the Maven js.quartz.properties file.
quartz.delegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
quartz.tablePrefix=QRTZ_
quartz.extraSettings=
report.scheduler.mail.sender.host=smtp.gmail.com
report.scheduler.mail.sender.username=<user>@gmail.com
report.scheduler.mail.sender.password=xxxxx
report.scheduler.mail.sender.from=<user>@gmail.com
report.scheduler.mail.sender.protocol=smtp
report.scheduler.mail.sender.port=587
 
2. In this case, Gmail SMTP server requires SSL to be enabled, which also requires editing another xml file:
applicationContext-report-scheduling.xml   (same folder as mentioned above)
 
      <bean id="reportSchedulerMailSender" class="org.springframework.mail.javamail.JavaMailSenderImpl">
            <property name="host" value="${report.scheduler.mail.sender.host}"/>
            <property name="username" value="${report.scheduler.mail.sender.username}"/>
            <property name="password" value="${report.scheduler.mail.sender.password}"/>
            <property name="protocol" value="${report.scheduler.mail.sender.protocol}"/>
            <property name="port" value="${report.scheduler.mail.sender.port}"/>
            <property name="javaMailProperties">
               <props>
                  <prop key="mail.smtp.auth">true</prop>
                  <prop key="mail.smtp.starttls.enable">true</prop>
               </props>
            </property>
      </bean>
 
3. Scheduling a job to send a report via email:
 
For more details, you can review the Unified Reporter (UR) Server User Guide:
http://docs.nimsoft.com/prodhelp/en_US/UnifiedReporter/8.0/UnifiedReporterServerUserGuide.pdf
Please refer to the section ‘Running Reports and the Report Viewer’ as well as section 3.9.1 “Setting Up a Job”
 
Note that to send email, the administrator must configure the mail server settings, as described in the Unified Reporter (JasperReports) Server Installation Guide. Here is a link to that doc:
http://docs.nimsoft.com/prodhelp/en_US/UnifiedReporter/8.0/UnifiedReporterInstallationGuide
 
A quick example of this is offered below. Login to UMP, and launch the UR report designer