Running Reports page of the Reports tab lists stale and inactive reports but does not include new reports

Products

• VMware Aria Suite

Issue/Introduction

You have a vCenter Chargeback 1.5 setup. To upgrade it to vCenter Chargeback Manager 2.5, you first upgrade to vCenter Chargeback Manager 2.0 and then to vCenter Chargeback Manager 2.5. In your vCenter Chargeback 1.5 setup, you have reports that are queued and unprocessed. After upgrading to vCenter Chargeback Manager 2.5, these unprocessed reports are listed on the Running Reports page of the Reports tab.
These reports are stale and inactive. Also, newly generated reports are not listed on the Running Reports page.
This issue occur only when you upgrade a vCenter Chargeback 1.5 setup to vCenter Chargeback Manager 2.5 and the existing vCenter Chargeback 1.5 setup has unprocessed reporting tasks.

Environment

VMware vCenter Chargeback Manager 2.5.x

Resolution

The reporting tasks in the CB_TASK_QUEUE table that have the MODIFIED_ON value as NULL and TASK_STATUS value as IN_PROGRESS are listed on the Running Reports page. To remove these stale reporting tasks from the page, perform the following steps:

1. Stop the vCenter Chargeback Manager service and the corresponding data collector services.
2. In the vCenter Chargeback Manager database, run the following SQL query:
   UPDATE CB_TASK_QUEUE SET TASK_STATUS = 'ERROR' WHERE TASK_STATUS = 'IN_PROGRESS' AND MODIFIED_ON IS NULL
3. Start the vCenter Chargeback Manager service and the corresponding data collector services.