Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1976768

Summary:	Inquiries regarding missing data in the calendar table created/inserted into the ovirt_engine_history DB.
Product:	[oVirt] ovirt-engine-dwh	Reporter:	jmh <whoisjmh>
Component:	Database	Assignee:	Aviv Litman <alitman>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Pavel Novotny <pnovotny>
Severity:	high	Docs Contact:
Priority:	high
Version:	4.4.7.2	CC:	bugs, dfodor, emesika, lsvaty, mperina, pelauter, sradco
Target Milestone:	ovirt-4.4.7	Keywords:	ZStream
Target Release:	4.4.7.3	Flags:	pm-rhel: ovirt-4.4+ mperina: blocker? pelauter: planning_ack+ sradco: devel_ack+ lsvaty: testing_ack+
Hardware:	Unspecified
OS:	All
Whiteboard:
Fixed In Version:	ovirt-engine-dwh-4.4.7.3	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2021-07-08 14:15:41 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:

Description jmh 2021-06-28 08:06:43 UTC

Description of problem:

I recently discovered that the spark-line chart is not displayed in the dashboard of the ovirt admin page. As a result of looking up the code and query, the data of the calendar table in the ovirt_engine_history DB of ovirt-dwh was only available until 2021-01-01 00:00:00, so a query statement ( https://github.com/oVirt/ovirt-engine/blob/master/frontend/webadmin/modules/frontend/src/main/resources/org/ovirt/engine/ui/frontend/server/dashboard/dao/HostDwhDAO.properties)RIGHT OUTER JOIN was not getting the correct data. First, the existing "generate_series('2011-01-01 00:00'::timestamp, '2021-01-01 00:00', '1 hours')" part was temporarily modified and applied until 2051. , it was confirmed that the spark-line chart was displayed normally.


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


How reproducible:

https://github.com/oVirt/ovirt-dwh/blob/master/packaging/dbscripts/upgrade/03_05_0060_updated_insert_calendar_table_values_script.sql

Please modify the sql file so that spark-line chart is output without any problem in Dashboard.

Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 RHEL Program Management 2021-06-28 11:37:48 UTC

The documentation text flag should only be set after 'doc text' field is provided. Please provide the documentation text and set the flag to '?' again.

Comment 2 Martin Perina 2021-06-29 09:42:54 UTC

Data present in webadmin dashboard might be incorrect, but we don't loose anything. After fixing the calendar table, dashboard should be working again

Comment 5 Pavel Novotny 2021-07-08 13:41:00 UTC

Verified in 
ovirt-engine-4.4.7.6-0.11.el8ev.noarch
ovirt-engine-dwh-4.4.7.3-1.el8ev.noarch

The sparkline chart is visible again and it's showing correct data.

Comment 6 Sandro Bonazzola 2021-07-08 14:15:41 UTC

This bugzilla is included in oVirt 4.4.7 release, published on July 6th 2021.

Since the problem described in this bug report should be resolved in oVirt 4.4.7 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.