Job Run Reports Are Generating With No Data Found

Document ID : KB000100233
Last Modified Date : 05/06/2018
Show Technical Document Details
Issue:
When running a Job Run report in iDash, it shows that no data was found event though the job(s) included in the report are confirmed to have run within the report time window.
Cause:
During a recent upgrade, certain indexes related to the iDash database table that stores job run info were not created due to a DB space issue. This began causing iDash to have trouble storing and cleaning data from this table due to performance. Because of this, the data for the report was not available.
Resolution:
Follow the steps outlined in this doc link for manually upgrading the database when a problem occurs during the upgrade...
https://docops.ca.com/ca-workload-automation-idash/12-0/en/installing/upgrade-to-the-current-release/troubleshoot-upgrading-issues/database-tables-not-updated