Reprocess cancelled reports in the report scheduler

KB ARTICLE

Overview

This procedure resets reports that were cancelled by the report scheduler so they can be processed again. Use this procedure with caution— if the number of reports is large or the reports are complex, running them may impact production system performance.

Report status values

Value	Status
0	Unreleased
1	Released
2	Ready
3	Active
4	Finished
5	Cancelled

Procedure

Open SQL Server Management Studio (SSMS).
Stop the Report Scheduler Service.
Open Task Manager and confirm the Report Scheduler Service process has stopped.
Run the following script against the FactoryLogix database.
Start the Report Scheduler Service.
Open FactoryLogix Analytics and check the Report Scheduler Queue to confirm reports are being processed.

UPDATE TaskScheduleQueues
SET StatusEnum = 1
WHERE StatusEnum IN (2, 3)
AND ID NOT IN (SELECT TaskScheduleQueueID FROM TaskScheduleOutputs)

Note

The script resets reports in Ready (2) or Active (3) status that have no corresponding output record, setting them back to Released (1) so the scheduler will reprocess them.