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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.