Hi Yedidyah,

After the fix that Paul pointed out, I can now see the data populating in all the daily tables.

Thanks for your response

Anton Louw

Cloud Engineer: Storage and Virtualization at Vox

T: 087 805 0000 | D: 087 805 1572
M: N/A
E: anton.louw@voxtelecom.co.za
A: Rutherford Estate, 1 Scott Street, Waverley, Johannesburg
www.vox.co.za

Disclaimer

The contents of this email are confidential to the sender and the intended recipient. Unless the contents are clearly and entirely of a personal nature, they are subject to copyright in favour of the holding company of the Vox group of companies. Any recipient who receives this email in error should immediately report the error to the sender and permanently delete this email from all storage devices.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more Click Here.

From: Yedidyah Bar David <didi@redhat.com>
Sent: 05 March 2020 08:59
To: Staniforth, Paul <P.Staniforth@leedsbeckett.ac.uk>
Cc: Anton Louw <Anton.Louw@voxtelecom.co.za>; users@ovirt.org
Subject: Re: [ovirt-users] Re: Changing the Data Warehouse Sampling Scale

On Wed, Mar 4, 2020 at 7:09 PM Staniforth, Paul
<P.Staniforth@leedsbeckett.ac.uk> wrote:
>
>
> Hello Anton,
> you can also manually do this
> edit /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf
> run systemctl restart ovirt-engine-dwhd.service
>
> if you upgrade your engine it puts the old 10-setup-scale.conf back but it keeps a copy

You can also add your own copy of this file with a later name (say
"99-my-stuff.conf").
This will take precedence and won't be touched by upgrades. However:

>
>
> Regards,
> Paul S.
> ________________________________
> From: anton.louw@voxtelecom.co.za <anton.louw@voxtelecom.co.za>
> Sent: 04 March 2020 05:37
> To: users@ovirt.org <users@ovirt.org>
> Subject: [ovirt-users] Changing the Data Warehouse Sampling Scale
>
> Caution External Mail: Do not click any links or open any attachments unless you trust the sender and know that the content is safe.
>
> Hi Everybody,
>
> I have a question. When oVirt was deployed in our environment by previous engineers, the DWH was installed as Basic. I would like to change this to Full, to get the daily stats, as this is now empty due to the scale.

If it's completely empty, perhaps there is some other problem, not the scale.

To further debug this, check that both the engine and dwh access the
same database (this should be ok by default, but perhaps you used
non-defaults) by checking the credentials they use in their conf
files:

grep DWH_DB /etc/ovirt-engine/engine.conf.d/*conf
grep DWH_DB /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*conf

You might also check /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log .

Best regards,

> Is this just as simple as described in the following article: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fdocumentation%2Fdata-warehouse%2FChanging_the_Data_Warehouse_Sampling_Scale.html&data=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533&sdata=ywsasun9mV0sNSjCmEeIf%2B94UZdc%2Fc%2Bevx9A1ScodXQ%3D&reserved=0
>
> Are there any precautions I should take, and has anybody else ever done this before?
>
> Thanks a lot
> _______________________________________________
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-leave@ovirt.org
> Privacy Statement: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fprivacy-policy.html&data=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533&sdata=ZKYdi41tiNeR5dDB3urRtPK%2BOact7CM17J8uEaB4obQ%3D&reserved=0
> oVirt Code of Conduct: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fcommunity%2Fabout%2Fcommunity-guidelines%2F&data=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533&sdata=RYLw8RIpcv3YJPvpE8QcZN9qsSjmkt%2BEzWDTScBuZfg%3D&reserved=0
> List Archives: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.ovirt.org%2Farchives%2Flist%2Fusers%40ovirt.org%2Fmessage%2FOXCU4RPMVR7XQUGBKJX63CUAFWPKE3GX%2F&data=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533&sdata=S%2B3GTsLTkW28Kk0P1uHCIsqUP087RYxQCdtrASzJfUU%3D&reserved=0
> To view the terms under which this email is distributed, please go to:-
> http://leedsbeckett.ac.uk/disclaimer/email/
>
> _______________________________________________
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-leave@ovirt.org
> Privacy Statement: https://www.ovirt.org/privacy-policy.html
> oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
> List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/FQBQ4ISS5BTVHST7FN44LPKAQSAZW2SL/

--
Didi