My Oracle Support Banner

OLVM: Event Reports Error "ETL service aggregation to hourly tables has encountered an error" (Doc ID 2766658.1)

Last updated on JUNE 15, 2021

Applies to:

Linux OS - Version Oracle Linux 7.9 and later
Linux x86-64

Symptoms

ovirt-engine-dwhd.log reports below error:

2021-03-26 00:00:00|jKdQfP|V1S079|PR4T54|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2021-03-26 00:00:00| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Thu Mar 25 23:00:00 WIB 2021 and runTime = Fri Mar 26 00:00:00 WIB 2021 .Please consult the service log for more details.|42
Exception in component tJDBCInput_3
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
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.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.tJDBCInput_3Process(HourlyTimeKeepingJob.java:1528)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.tJDBCConnection_3Process(HourlyTimeKeepingJob.java:1258)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.tPostjob_1Process(HourlyTimeKeepingJob.java:1133)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.runJobInTOS(HourlyTimeKeepingJob.java:9507)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.runJob(HourlyTimeKeepingJob.java:9158)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tInfiniteLoop_2Process(ParallelRun.java:3123)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tJava_3Process(ParallelRun.java:2884)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun$3.run(ParallelRun.java:5666)
Caused by: java.io.IOException: Stream closed
at sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:45)
at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:140)
at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)
at org.postgresql.core.PGStream.flush(PGStream.java:517)
at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1141)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)
... 11 more
2021-03-30 00:00:00|3sipe1|V1S079|PR4T54|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java Exception|tJDBCInput_3|org.postgresql.util.PSQLException:An I/O error occured while sending to the backend.|1
2021-03-30 00:00:00|o28EJA|V1S079|PR4T54|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2021-03-30 00:00:00| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Mon Mar 29 23:00:00 WIB 2021 and runTime = Tue Mar 30 00:00:00 WIB 2021 .Please consult the service log for more details.|42



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.