UMP Unified Dashboard reports for Oracle are showing "Data not Monitored"

book

Article ID: 140582

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Navigate to Unified Dashboards > Application and Server > Oracle
On the list page, click on a server or QOS name.
The qoschart page that comes up displays "Data Not Monitored"

The data is viewable in CABI and Operator Console and the QOS data looks ok in the database.

Cause

Queries stored in the MSSQL back end database that build these reports need to be updated.

Environment

UIM 8.51 - UIM 9.2.0

Component : UIM - UNIFIED_DASHBOARDS

MSSQL backend database

Resolution

Run the attached sql queries to populate the proper queries into the page.  After running the queries, reload the page and open a report to view the monitored data.

Additional Information

These updated entries will be included in UIM 9.2.1.

Attachments

1574352046834__umpqosreport.sql get_app
1574352031317__umpListViews.sql get_app