Scheduled report sends out blank in email / Error "JasperReports Server encountered an error..."
search cancel

Scheduled report sends out blank in email / Error "JasperReports Server encountered an error..."

book

Article ID: 127868

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When you schedule a report, you get an email with an empty file and you get the following error:
 
JasperReports Server encountered an error while generating this report. Please contact your administrator.

In the logs you can see the following error:
2019-01-04 06:00:31,079 ERROR HibernateDaoImpl,quartzScheduler_Worker-6:111 [] - ************** HibernateDaoImpl.executeWriteCallback EXCEPTION **********
com.jaspersoft.jasperserver.api.JSDuplicateResourceException: jsexception.resource.already.exists
Arguments: "/organizations/myorg/Custom_Tasks_Report.xls",
at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getRepoResource(HibernateRepositoryServiceImpl.java:695)
at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$14.execute(HibernateRepositoryServiceImpl.java:578)
at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:83)

Deleting and recreating the scheduled report works only temporarily.

Resolution

Schedule the report at a different time, for example, one hour before or after the previous schedule. This would avoid any potential report misfires and solve the problem.

Also applies when no report notification is sent out.

Additional Information

See also: Email Notifications - known issues for Clarity