Scheduled Report is sent out blank in email

Article Id: 127868

Status: Published

Updated On: 13-12-2019 16:06

Products:

CLARITY PPM FOR ITG , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM On Premise

Issue/Introduction:

When I schedule the report I get an email with an empty file and I get the following error:

JasperReports Server encountered an error while generating this report. Please contact your administrator.

If looking in the logs we 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.

Environment:

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

Schedule the report at a different time, for example 1 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.