[ovirt-users] Re: dashboard data empty

2020-02-23 Thread Fabrizio Cardarello
Shirly of course I restarted the process you can find the error in the log
file in my first email. Anyway tomorrow I can also send you all the log. I
also opened a bug on bugzilla.
The problem seems related to postgres jdbc.

Il dom 23 feb 2020, 14:11 Shirly Radco  ha scritto:

> 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 
>
> 
>
>
> On Thu, Feb 20, 2020 at 7:31 PM Fabrizio Cardarello <
> f.cardare...@gmail.com> wrote:
>
>> What do you suggest? Could concern the heap size?
>>
>> Il gio 20 feb 2020, 17:11 Ritesh Chikatwar  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  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|30
 hoursToKeepSamples|24
 deleteMultiplier|1000
 lastErrorSent|2011-07-03 12:46:47.00
 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 -- u

[ovirt-users] Re: dashboard data empty

2020-02-23 Thread Shirly Radco
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 




On Thu, Feb 20, 2020 at 7:31 PM Fabrizio Cardarello 
wrote:

> What do you suggest? Could concern the heap size?
>
> Il gio 20 feb 2020, 17:11 Ritesh Chikatwar  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  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|30
>>> hoursToKeepSamples|24
>>> deleteMultiplier|1000
>>> lastErrorSent|2011-07-03 12:46:47.00
>>> 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@ovirt.org
>>> To unsubscribe send an email to users-le...@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/XNHHCEVYDPBVJM7ZYJ6X3L7UUQ3P5I7M/
>>>
>> ___
> Users mailing list -- us

[ovirt-users] Re: dashboard data empty

2020-02-20 Thread Fabrizio Cardarello
What do you suggest? Could concern the heap size?

Il gio 20 feb 2020, 17:11 Ritesh Chikatwar  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  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|30
>> hoursToKeepSamples|24
>> deleteMultiplier|1000
>> lastErrorSent|2011-07-03 12:46:47.00
>> 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@ovirt.org
>> To unsubscribe send an email to users-le...@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/XNHHCEVYDPBVJM7ZYJ6X3L7UUQ3P5I7M/
>>
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/X33EJZLCMPJIKIFG4DSE52ZKXUX7XZYJ/


[ovirt-users] Re: dashboard data empty

2020-02-20 Thread Ritesh Chikatwar
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  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|30
> hoursToKeepSamples|24
> deleteMultiplier|1000
> lastErrorSent|2011-07-03 12:46:47.00
> 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@ovirt.org
> To unsubscribe send an email to users-le...@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/XNHHCEVYDPBVJM7ZYJ6X3L7UUQ3P5I7M/
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/I5AXSJ5POQEXAEMS7NSWU7PTVQI7XSWR/