Performance reports defined in 9.0.2 are incorrectly recovered in 20.4
Article ID: 244710
Updated On:
Products
Issue/Introduction
Scheduled performance reports have been defined with CA-UIM 9.0.2. Then we migrate to 20.4.
We find the scheduled performance reports that were defined with version 9.0.2 but they have the Metric View type instead of Performance and when we edit them they have no associated report.
As a result, their execution fails.
For the execution not to fail, we have to edit each scheduled job, replace Metric View by Performance in the Report Type field, and select the right report in the Report field. But the generated report is empty.
For the generated report to contain data, you have to edit each performance report from 9.0.2 and change the Aggregation Interval field of the report from 1 hour to Automatic (from Settings - Performance Reports Designer then Import button).
Then you have to re-edit each scheduled job and reselect the right report in the Report field because it has been overwritten.
Is this issue will be fixed in the February patch of CA-UIM 20.4? Or we did do something wrong in the report schedule process?
Environment
Release: 20.1
Component: UIM OPERATOR CONSOLE - CABI REPORTS AND INTEGRATION
Resolution
Present there are two different issues when we run the old PRD jobs in UIM 20.4
1) Report execution fails:
Solution: run the below script on the UIM DB. This will fix report execution failure.
UPDATE umpReportInfo set reportType = 2 WHERE id in (Select id From umpReportInfo where name in (Select distinct path from umpQoSReports))
2) Report will get blank screen after execution.
Solution: There is no straight forward way for this because in database we have to modify the metadata of each PRD. This is not possible with a query.
Workaround: You need to open each PRD report which was created during 9.0.2 time by use import option in PRD screen. Change the Aggregation Interval field of the report from "1 hour" to "Automatic" and save the PRD
Feedback
