Hide Forgot
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:
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.
Data present in webadmin dashboard might be incorrect, but we don't loose anything. After fixing the calendar table, dashboard should be working again
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.
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.