Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users(a)ovirt.org&gt; написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks -- ________________________________ Jose Ferradeira http://www.logicworks.pt _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)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/KPW5FFKG3AI...

The postgres is older than 10: postgresql-jdbc-9.2.1002-6.el7_5.noarch postgresql-libs-9.2.23-3.el7_4.x86_64 rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64 rh-postgresql95-runtime-2.2-2.el7.x86_64 rh-postgresql95-postgresql-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-contrib-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64 collectd-postgresql-5.8.0-3.el7.x86_64 Should I use this instead: su - postgres scl enable rh-postgresql95 bash psql Thanks José De: suporte(a)logicworks.pt Para: "Strahil Nikolov" <hunter86_bg(a)yahoo.com&gt; Cc: "users" <users(a)ovirt.org&gt; Enviadas: Sexta-feira, 22 De Janeiro de 2021 16:39:04 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Hello, # su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$ What am I doing wrong? Thanks José De: "Strahil Nikolov" <hunter86_bg(a)yahoo.com&gt; Para: "users" <users(a)ovirt.org&gt;, suporte(a)logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users(a)ovirt.org&gt; написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks -- ________________________________ Jose Ferradeira http://www.logicworks.pt _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)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/KPW5FFKG3AI...

Try using the 'source /opt/rh/rh-postgresql95/enable' Best Regards,Strahil Nikolov В 19:53 +0000 на 22.01.2021 (пт), José Ferradeira via Users написа:

Should I use this to delete the year 2026 from the rows? DELETE FROM dwh_history_timekeeping WHERE EXTRACT(year FROM "date") = 2026; thanks José De: "José Ferradeira via Users" <users(a)ovirt.org&gt; Para: "Strahil Nikolov" <hunter86_bg(a)yahoo.com&gt; Cc: "users" <users(a)ovirt.org&gt; Enviadas: Segunda-feira, 25 De Janeiro de 2021 18:17:50 Assunto: [ovirt-users] Re: Ovirt reporting dashboard not working That worked there are 4 lines with dates 2026-03-26. What should I do? I'm not an expert in postgresql thanks De: "Strahil Nikolov" <hunter86_bg(a)yahoo.com&gt; Para: suporte(a)logicworks.pt Cc: "users" <users(a)ovirt.org&gt; Enviadas: Sábado, 23 De Janeiro de 2021 13:20:32 Assunto: Re: [ovirt-users] Re: Ovirt reporting dashboard not working Try using the 'source /opt/rh/rh-postgresql95/enable' Best Regards, Strahil Nikolov В 19:53 +0000 на 22.01.2021 (пт), José Ferradeira via Users написа: The postgres is older than 10: postgresql-jdbc-9.2.1002-6.el7_5.noarch postgresql-libs-9.2.23-3.el7_4.x86_64 rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64 rh-postgresql95-runtime-2.2-2.el7.x86_64 rh-postgresql95-postgresql-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-contrib-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64 collectd-postgresql-5.8.0-3.el7.x86_64 Should I use this instead: su - postgres scl enable rh-postgresql95 bash psql Thanks José De: suporte(a)logicworks.pt Para: "Strahil Nikolov" <hunter86_bg(a)yahoo.com&gt; Cc: "users" <users(a)ovirt.org&gt; Enviadas: Sexta-feira, 22 De Janeiro de 2021 16:39:04 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Hello, # su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$ What am I doing wrong? Thanks José De: "Strahil Nikolov" <hunter86_bg(a)yahoo.com&gt; Para: "users" <users(a)ovirt.org&gt;, suporte(a)logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users(a)ovirt.org&gt; написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)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/6YETINUGJEP... _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)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/KG34CLI5MIU...