Description of problem:

Rhevm reports errors "ETL service sampling has encountered an error. Please consult the service log for more details" 

Version-Release number of selected component (if applicable):
rhevm-4.0.6.3-0.1.el7ev.noarch
ovirt-engine-dwh-4.0.6-1.el7ev.noarch
ovirt-engine-dwh-setup-4.0.6-1.el7ev.noarch

Actual results:

2017-01-14 14:43:05|TMkTqM|ePMtqm|FTCMiX|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCInput_5|org.postgresql.util.PSQLException:ERROR: smallint out of range|1
Exception in component tJDBCInput_18
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
        at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync.tJDBCInput_18Process(StatisticsSync.java:13089)
        at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$7.run(StatisticsSync.java:16163)
2017-01-14 14:43:05|TMkTqM|ePMtqm|FTCMiX|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java Exception|tJDBCInput_18|org.postgresql.util.PSQLException:ERROR: current transaction is aborted, commands ignored until end of transaction block|1
Exception in component tJDBCInput_12
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
        at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:11111)
        at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$6.run(StatisticsSync.java:16117)
2017-01-14 14:43:05|FTCMiX|ePMtqm|lE2N4t|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4444)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4188)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3593)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2977)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2295)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649)
        at ovirt_engine_dwh.sampletimekeepingjob_4_0.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:11361)

2017-01-17 16:30:43|ETL Service Stopped
2017-01-17 16:31:33|ETL Service Started

2017-03-03 09:21:03|T4CEVH|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704
2017-03-03 09:21:38|pJa9wA|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704
2017-03-03 09:22:18|1vFSmu|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704
2017-03-03 09:23:03|rmYAU5|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704
2017-03-03 09:23:53|TR8EDO|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704
2017-03-03 09:38:53|qEPlN4|dlRn1n|zX18Bu|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704

Expected results:

sample time keeping runs with no issues.

Additional info:

-- Created this new bug as per 
https://bugzilla.redhat.com/show_bug.cgi?id=1402471#c10

-- Below services were restarted to check if issue is resolved, but the issue persists.
# service ovirt-engine stop
# service ovirt-engine-dwhd stop
# service postgresql restart
# service ovirt-engine start
# service ovirt-engine-dwhd start