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

Products

• VMware Aria Suite

Issue/Introduction

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.

In vCenter Chargeback 1.5, there are 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.

Additionally, newly generated reports are not listed on the Running Reports page.

Environment

VMware vCenter Chargeback Manager 2.5.x and later

Cause

In reports tab it lists stale and inactive reports but does not include new reports

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.