Support Article

Report Scheduler sending the previous days reports

SA-29398

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


 

  1. Configure a Report Definition with many columns and configure timeout for the report.
  2. Configure the scheduler to run daily based on a date (eg: today)
  3. Ensure we have small set of records for today and a high volume of records for tomorrow.
  4. 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 October 20, 2016 - Updated November 5, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.