RHBA-2014:1154 - Bug Fix Advisory

Topic

An updated rhevm-dwh package that fixes two bugs is now available.

Description

The Red Hat Enterprise Virtualization Manager data warehouse package provides
the ETL process and DB scripts to create a historic database API. Enables SQL BI
reports creation for management and monitoring.

Changes to the rhevm-dwh component:

• A direct upgrade of Data Warehouse and/or Reports from 3.2 to 3.4 was not

expected, not supported in the code, and not tested, but also not prevented.
Such an upgrade can happen if, for example, a system has the 3.2 "engine",
"dwh", and "reports" packages installed and set up; then "engine" is upgraded to
3.3; the "dwh" and "reports" packages are upgraded to 3.3 but not set up; and
then an attempt to upgrade all packages to 3.4 is made. An attempt to do such an
upgrade fails and rolls back with an unclear error message. To fix this, the 3.4
"rhevm-setup-plugins" package was modified to check early in the process if 3.2
"dwh" and "reports" are set up. Now if 3.2 "dwh" or "reports" are set up on the
system, engine-setup aborts early (so that a rollback is not required) with a
useful error message. (BZ#1123751)

• Previously, a problem in the way the calendar column was populated caused the

daily reports not to show. This happened because the timestamp was affected by
timezone, specifically for countries on timezones that are not of round hours
(e.g. Australia/Darwin UTC+9:30). A join could not be created between the
calendar table and the hourly statistics tables, and the query results dropped.
Now, the calendar columns have been repopulated with timestamps, and timezones
have been removed. Daily reports now display successfully in scenarios where the
history database time is set to a timezone that is not of a round hour.
(BZ#1125139)

Users should upgrade to this updated package, which resolves these issues.

Solution

Before applying this update, make sure all previously-released errata relevant
to your system have been applied.

Affected Products

• Red Hat Virtualization 3.4 x86_64

Fixes

• BZ - 1123751 - DWH/Reports upgrade from 3.2 to 3.4 fails

CVEs

(none)

References

(none)