After upgrading to RHEV-M 3.5, getting "ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details." messages in event log.

Solution Verified - Updated -

Issue

  • Why do we get error "ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.", after upgrading to RHEV-M 3.5?
  • Event log:
Correlation ID: null, Call Stack: , Custom Event ID: -1, Message: ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.
  • In postgresql-xx.log:
ERROR:  invalid input syntax for type timestamp with time zone: "Fri February 13 2015 11:00:00 ECT" in character 214
  • After an upgrade to RHEV 3.5 , we see ETL errors.
    -Fresh install RHEV, in rhev-m admin web shows:
    ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.
In /var/lib/pgsql/data/pg_log/posgresql-xxx.log show:
ERROR:  invalid input syntax for type timestamp with time zone: "Wed Apr 15 21:00:00 WEST 2015" at character 214

Environment

  • Red Hat Enterprise Virtualization 3.5

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content