Report Scheduler sending the previous days reports
Report Scheduler was configured to run daily and email the report. On a specific day when it fails, the report scheduler fails due to the query getting timed out. In such case, the report scheduler was still getting the report from the last successful run and sends the email, instead of creating a broken queue item.
Problem #1, SQLState HY008, Error code 0: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
Steps to Reproduce
- Configure a Report Definition with many columns and configure timeout for the report.
- Configure the scheduler to run daily based on a date (eg: today)
- Ensure we have small set of records for today and a high volume of records for tomorrow.
- Schedule the report to run on a daily basis and email to user.
Application was not skipping the process of sending the email, even if the Report Definition has failed.
Published October 20, 2016 - Updated November 5, 2016