Support Article
Report Scheduler sending the previous days reports
Summary
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.Error Messages
Problem #1, SQLState HY008, Error code 0: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:257)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6080)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.
Root Cause
Application was not skipping the process of sending the email, even if the Report Definition has failed.Resolution
Apply HFix-30071
Published November 5, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.