I think this because resultset is not able to map the database value to entity. You can error it's bad value for the type short. I guess the the value passed for short variable is more then it can store. On Thu, Feb 20, 2020, 2:56 PM Fabrizio <f.cardarello(a)gmail.com&gt; wrote: > Hello everyone. > I intalled 4 node with hosted engine, everything works fine exept the > dashboard. it doesn't collect any data and is always empty of information. > searching around I found out that the problem could be the dwh service, > inside the log there is an error: > > ## log file > 2020-02-19 17:46:14|ETL Service Started > ovirtEngineDbDriverClass|org.postgresql.Driver > > ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory > hoursToKeepDaily|0 > hoursToKeepHourly|720 > ovirtEngineDbPassword|********************** > runDeleteTime|3 > > ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory > runInterleave|60 > limitRows|limit 1000 > ovirtEngineHistoryDbUser|ovirt_engine_history > ovirtEngineDbUser|engine > deleteIncrement|10 > timeBetweenErrorEvents|300000 > hoursToKeepSamples|24 > deleteMultiplier|1000 > lastErrorSent|2011-07-03 12:46:47.000000 > etlVersion|4.3.8 > dwhAggregationDebug|false > dwhUuid|5c4ffc1b-928f-4d06-a40f-bb34ba11c7f2 > ovirtEngineHistoryDbDriverClass|org.postgresql.Driver > ovirtEngineHistoryDbPassword|********************** > Exception in component tJDBCInput_2 > org.postgresql.util.PSQLException: Bad value for type short : 201905 > at > org.postgresql.jdbc2.AbstractJdbc2ResultSet.getShort(AbstractJdbc2ResultSet.java:2098) > at > ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_2Process(OsEnumUpdate.java:2354) > at > ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1921) > at > ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1376) > at > ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:873) > at > ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:736) > at > ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4396) > at > ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJob(OsEnumUpdate.java:4099) > at > ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:947) > at > ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:767) > at > ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:642) > at > ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs$2.run(SampleRunJobs.java:2683) > > ## SERVICE STATUS > ● ovirt-engine-dwhd.service - oVirt Engine Data Warehouse > Loaded: loaded (/usr/lib/systemd/system/ovirt-engine-dwhd.service; > enabled; vendor preset: disabled) > Active: active (running) since Wed 2020-02-19 17:46:14 CET; 16h ago > Main PID: 6425 (ovirt-engine-dw) > CGroup: /system.slice/ovirt-engine-dwhd.service > ├─6425 /usr/bin/python > /usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.py > --redirect-output --systemd=notify start > └─6512 ovirt-engine-dwhd > -Dorg.ovirt.engine.dwh.settings=/tmp/tmparNn_x/settings.properties -Xms1g > -Xmx1g -classpath > /usr/share/ovirt-engine-dwh/lib/*::/usr/share/java/dom4j.jar:/usr/share/java/apache-commons-collections.jar:/usr/share/java/postgresql-jdbc.jar > ovirt_engine_dwh.historyetl_4_3.HistoryETL --context=Default > > Feb 19 17:46:14 engine.ovirt.local systemd[1]: Starting oVirt Engine Data > Warehouse... > Feb 19 17:46:14 engine.ovirt.local systemd[1]: Started oVirt Engine Data > Warehouse. > _______________________________________________ > Users mailing list -- users(a)ovirt.org > To unsubscribe send an email to users-leave(a)ovirt.org > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/users@ovirt.org/message/XNHHCEVYDPB... >

Hi, Have you tried to restart DWH ? systemctl restart ovirt-engine-dwhd If this doesn't work, please send me the ovirt-engine-dwhd.log. Best, -- Shirly Radco BI Principal Software Engineer Red Hat <https://www.redhat.com/> <https://www.redhat.com/> On Thu, Feb 20, 2020 at 7:31 PM Fabrizio Cardarello < f.cardarello(a)gmail.com&gt; wrote: > What do you suggest? Could concern the heap size? > > Il gio 20 feb 2020, 17:11 Ritesh Chikatwar <rchikatw(a)redhat.com&gt; ha > scritto: > >> I think this because resultset is not able to map the database value to >> entity. You can error it's bad value for the type short. I guess the the >> value passed for short variable is more then it can store. >> >> On Thu, Feb 20, 2020, 2:56 PM Fabrizio <f.cardarello(a)gmail.com&gt; wrote: >> >>> Hello everyone. >>> I intalled 4 node with hosted engine, everything works fine exept the >>> dashboard. it doesn't collect any data and is always empty of information. >>> searching around I found out that the problem could be the dwh service, >>> inside the log there is an error: >>> >>> ## log file >>> 2020-02-19 17:46:14|ETL Service Started >>> ovirtEngineDbDriverClass|org.postgresql.Driver >>> >>> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory >>> hoursToKeepDaily|0 >>> hoursToKeepHourly|720 >>> ovirtEngineDbPassword|********************** >>> runDeleteTime|3 >>> >>> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory >>> runInterleave|60 >>> limitRows|limit 1000 >>> ovirtEngineHistoryDbUser|ovirt_engine_history >>> ovirtEngineDbUser|engine >>> deleteIncrement|10 >>> timeBetweenErrorEvents|300000 >>> hoursToKeepSamples|24 >>> deleteMultiplier|1000 >>> lastErrorSent|2011-07-03 12:46:47.000000 >>> etlVersion|4.3.8 >>> dwhAggregationDebug|false >>> dwhUuid|5c4ffc1b-928f-4d06-a40f-bb34ba11c7f2 >>> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver >>> ovirtEngineHistoryDbPassword|********************** >>> Exception in component tJDBCInput_2 >>> org.postgresql.util.PSQLException: Bad value for type short : 201905 >>> at >>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getShort(AbstractJdbc2ResultSet.java:2098) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_2Process(OsEnumUpdate.java:2354) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1921) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1376) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:873) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:736) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4396) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJob(OsEnumUpdate.java:4099) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:947) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:767) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:642) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs$2.run(SampleRunJobs.java:2683) >>> >>> ## SERVICE STATUS >>> ● ovirt-engine-dwhd.service - oVirt Engine Data Warehouse >>> Loaded: loaded (/usr/lib/systemd/system/ovirt-engine-dwhd.service; >>> enabled; vendor preset: disabled) >>> Active: active (running) since Wed 2020-02-19 17:46:14 CET; 16h ago >>> Main PID: 6425 (ovirt-engine-dw) >>> CGroup: /system.slice/ovirt-engine-dwhd.service >>> ├─6425 /usr/bin/python >>> /usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.py >>> --redirect-output --systemd=notify start >>> └─6512 ovirt-engine-dwhd >>> -Dorg.ovirt.engine.dwh.settings=/tmp/tmparNn_x/settings.properties -Xms1g >>> -Xmx1g -classpath >>> /usr/share/ovirt-engine-dwh/lib/*::/usr/share/java/dom4j.jar:/usr/share/java/apache-commons-collections.jar:/usr/share/java/postgresql-jdbc.jar >>> ovirt_engine_dwh.historyetl_4_3.HistoryETL --context=Default >>> >>> Feb 19 17:46:14 engine.ovirt.local systemd[1]: Starting oVirt Engine >>> Data Warehouse... >>> Feb 19 17:46:14 engine.ovirt.local systemd[1]: Started oVirt Engine >>> Data Warehouse. >>> _______________________________________________ >>> Users mailing list -- users(a)ovirt.org >>> To unsubscribe send an email to users-leave(a)ovirt.org >>> Privacy Statement: https://www.ovirt.org/site/privacy-policy/ >>> oVirt Code of Conduct: >>> https://www.ovirt.org/community/about/community-guidelines/ >>> List Archives: >>> https://lists.ovirt.org/archives/list/users@ovirt.org/message/XNHHCEVYDPB... >>> >> _______________________________________________ > Users mailing list -- users(a)ovirt.org > To unsubscribe send an email to users-leave(a)ovirt.org > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/users@ovirt.org/message/X33EJZLCMPJ... >