Correct. Was added in an upgrade script. There might be a bug/issue/change in the order that the upgrade script runs vs create_views_* above.
Adding Aviv and Shirly.
i found this problem at log. UPDATE 0 2022-01-21 16:02:41,589+0900 Running upgrade sql script '/usr/share/ovirt-engine-dwh/dbscripts/upgrade/pre_upgrade/set_etl_minimal_version.sql'... 2022-01-21 16:02:41,591+0900 dbfunc_psql_die --file=/usr/share/ovirt-engine-dwh/dbscripts/upgrade/pre_upgrade/set_etl_minimal_version.sql ********* QUERY ********** INSERT INTO history_configuration(var_name,var_value) SELECT 'MinimalETLVersion','4.4.7' WHERE not exists (SELECT var_name FROM history_configuration WHERE var_name = 'MinimalETLVersion'); ************************** INSERT 0 0 ********* QUERY ********** UPDATE history_configuration SET var_value = '4.4.7' WHERE var_name = 'MinimalETLVersion'; ************************** ...... 2022-01-21 16:02:43,138+0900 Skipping upgrade script /usr/share/ovirt-engine-dwh/dbscripts/upgrade/04_04_0040_added_host_count_threads_as_cores.sql, its version 04040040 is <= current version 04040070 ********* QUERY ********** copy (select now()) to stdout with delimiter as '|'; ************************** Sorry for the mess, Thank you -- Jihwan