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.
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.