Hi Tommy,
You can apply  the patches by changing the relevant files in engine and dwh and run 'engine-setup' or 'engine-setup --offline' .

1. connect to your engine machine
2. vi /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql :
add the new line as described in the patch: https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/4/packaging/dbscripts/create_dwh_views.sql.
3. connect to your dwh machine (if the engine and dwh are on the same machine then all files are in the same machine)
4. create or edit the files in the patch: https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/, note that for you files named 4_4 should be named 4_3
You can find the file's location with this command:
find / -name create_views_4_3.sql
5. run engine-setup, or engine-setup --offline 
Let me know how it goes!

On Mon, Nov 1, 2021 at 9:42 AM Tommy Sway <sz_cuitao@163.com> wrote:

But how to apply the patches?


Is some docs can guide me how to apply?







From: Aviv Litman <alitman@redhat.com>
Sent: Sunday, October 3, 2021 10:08 PM
To: Tommy Sway <sz_cuitao@163.com>
Subject: Re: Some errors on the grafana dashboard


Important note: do not to change the minimal version part in dwh ovirt-engine-dwh.spec.in file.


On Sun, Oct 3, 2021 at 4:50 PM Aviv Litman <alitman@redhat.com> wrote:

Hi Tommy,
You can try to implement the patches I shared manually by changing the relevant files in engine and dwh and run engine-setup.

Let me know if you have any questions.



On Sun, Sep 19, 2021 at 4:56 PM Tommy Sway <sz_cuitao@163.com> wrote:

Thank you!






From: Aviv Litman <alitman@redhat.com>
Sent: Sunday, September 19, 2021 3:04 PM
To: Tommy Sway <sz_cuitao@163.com>
Subject: Re: Some errors on the grafana dashboard


Hi Tommy,
There was a bug in the way we calculate hosts CPU: we didn't consider the count_threads_as_cores option in the calculation.
The count_threads_as_cores column is available only from ovirt-engine version, and ovirt-dwh 4.4.7.




So you have to update the version to 4.4.7.
I will also add a note in the Blog.

Feel free to contact me if you have more questions.



On Tue, Sep 14, 2021 at 11:38 AM Tommy Sway <sz_cuitao@163.com> wrote:



I used the JSON file you provided and imported grafana. Before importing, I replaced the version, because the version of my system is 4.3.

$ find . -type f -name "*dashboard.json" -exec sed -i -e 's/v4_4_/v4_3_/g' {} \;

However, most of the reports are normal, but some reports have similar errors:


pq: column "count_threads_as_cores" does not exist



statusText:"Bad Request"



message:"pq: column "count_threads_as_cores" does not exist"

message:"pq: column "count_threads_as_cores" does not exist"


Many of the other reports worked fine, with only a few similar errors.

Is this caused by version incompatibility?

After all, 4.4 in the original document was replaced with 4.3 before the import.


Thank you!