Issue
In the Report Designer you notice that there are items stuck in the Report Queue Status screen. Additionally, the Remove button is disabled so you cannot remove the items.
Resolution
Modify these statements based on the status indicated for the stuck items using the table below:
SELECT * FROM REPORTING.REPOSITORY WHERE STATUSTYPE='<STATUS TYPE CODE>'
If the above statement returns records, the run this statement:
DELETE FROM REPORTING.REPOSITORY WHERE STATUSTYPE='<STATUS TYPE CODE>'
The Repository table contains a field called "StatusType". These are the codes and their meanings:
| Status Type Code | Description |
| 0 | Complete |
| 1 | Failed |
| 2 | Canceled |
| 10 | Queued |
| 20 | Processing |
| 30 | Canceling |
| 40 | Queueing |