Job Run Reports Are Generating With No Data Found

Products

• iDash Workload Automation

Issue/Introduction

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.

Environment

Release:
Component: AEIDSH

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