Bug 1914825

Summary: Update queries to use v4_4 views in all dashboards
Product: [oVirt] ovirt-engine-dwh Reporter: Aviv Litman <alitman>
Component: GrafanaAssignee: Aviv Litman <alitman>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Novotny <pnovotny>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 4.4.4CC: gdeolive, mperina, sradco
Target Milestone: ovirt-4.4.5Flags: pm-rhel: ovirt-4.4+
pm-rhel: planning_ack+
mperina: devel_ack+
gdeolive: testing_ack+
Target Release: 4.4.5   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: ovirt-engine-dwh-4.4.5 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-03-18 15:14:36 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Metrics RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
V4_3 none

Description Aviv Litman 2021-01-11 09:56:03 UTC 
Created attachment 1746224 [details]
V4_3

Created attachment 1746224 [details]
V4_3

Created attachment 1746224 [details]
V4_3

Description of problem:
Update queries to use v4_4 views in all dashboards

Version-Release number of selected component (if applicable):
4.4.4

How reproducible:
100%

Steps to Reproduce:
1.go to Grafana
2.choose dashboard -> panel -> Edit -> Queries

Actual results:
The queries query views v_4_3

Expected results:
The queries query views v_4_4

Notes for QA:
Need to check that all the tables used in all the dashboards starts with v4_4 instead of v4_3
* note: only tables that start with v4_3 need to change to v4_4 all other tables like 'enum_translator' stay the same.
Comment 1 Pavel Novotny 2021-03-01 21:49:49 UTC 
Verified (*) in
ovirt-engine-4.4.5.7-0.1.el8ev.noarch
ovirt-engine-dwh-4.4.5.4-1.el8ev.noarch

All v4_3_ tables have been updated to v4_4_ (*).

(*) except one occurrence in query for Hosts Inventory Dashboard -> Host Hardware Details panel.
But this change was introduced by RFE bug 1917848. I will raise the issue there.
Comment 2 Sandro Bonazzola 2021-03-18 15:14:36 UTC 
This bugzilla is included in oVirt 4.4.5 release, published on March 18th 2021.

Since the problem described in this bug report should be resolved in oVirt 4.4.5 release, it has been closed with a resolution of CURRENT RELEASE.

If the solution does not work for you, please open a new bug report.
Comment 3 Sandro Bonazzola 2021-03-22 12:55:40 UTC 
This bugzilla is included in oVirt 4.4.5 release, published on March 18th 2021.

Since the problem described in this bug report should be resolved in oVirt 4.4.5 release, it has been closed with a resolution of CURRENT RELEASE.

If the solution does not work for you, please open a new bug report.