Jaspersoft Scheduled Failed

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We have a Jaspersoft Report Scheduled for last 6 months, and it runs weekly, there was failure last week, but the next run completed successfully.

Error Message on the logs: Caused by: java.sql.SQLRecoverableException: Closed Connection

Cause

This happens due to database connection expired and job failed. This could have consequences for the other jobs as this is usually an indication of a very long report execution. Quite possibly this job takes a long time to execute, hogs a thread and can potentially cause a misfire of another job.

Resolution

If the next run fails again, then please edit the schedule and change the + - 15 mins

After modifying the schedule, the scheduled report still fails then please delete the schedule instance and re-create a new one.