ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Scheduled Jaspersoft reports fail with error "RPT-0021" prior to 15.4.1

book

Article ID: 110652

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Reports are scheduled via Reports and Jobs were running and have suddenly the reports start failing.

Example error in log:

Exception: Document already exists
Error RPT-0021: Error occurred while saving the report Capacity_vs_Demand_by_Resource_recurrence.PDF. Please contact your system administrator.

Example error in the BG log:

ERROR 2018-01-30 13:20:14,541 [Thread-212004] niku.njs (clarity:admin:21099943__D909634C-4F02-40BE-A89B-F6ADB666FE59:none) Error during adding file to DMS. com.niku.union.exceptions.DMSException: Document already exists:Capacity_vs_Demand_by_Resource_recurrence_13359899.pdf

Steps to Reproduce:

  1. Navigate to Home>Reports and Jobs
  2. Select a report from the list.
  3. Select Scheduled and uncheck Immediately under When.
  4. Select today's date and time for the start date
  5. Scroll down and select Set Recurrence
  6. Set the report to run via crontab (Example: "*/15 * * * *" to run every 15 minutes)
  7. Submit the scheduled report.

Expected Result:  Scheduled reports run every 15 minutes until paused or canceled. 

Actual Result:  Reports run as expected for a period of time, then fail.  Once the scheduled report fails, it continues to fail. 

Cause

Caused by DE39624 

Resolution

This is resolved in 15.4.1 and onwards and backported to 15.3 patch 3

Workaround 1:

  1. Generate the report in the background which is accessible from Reports and Jobs > Reports
  2. Run the job as Scheduled.
  3. Uncheck the 'immediate' option.
  4. Set the date prior to the current date.

Workaround 2:

Schedule reports in Home > Advanced Reporting