Hide Forgot
Description of problem: The history database daily tables store their date in column defined as timestamps with timezone. This causes the date and time to shift when changing time zones as well and the time is no longer 00:00 which the reports depends on to work. Version-Release number of selected component (if applicable): 3.0.2-2 How reproducible: always Steps to Reproduce: 1. start collecting a specific time zone for a few days. 2. change time zone of the server. 3. try to run reports based of daily tables. Actual results: many reports return empty result. Expected results: should not affect the results
This is fixed by upstream patch in the link: http://gerrit.ovirt.org/1255 Yaniv
3.1/si13.2 When changing postgres Time Zone, DWH stop collecting data in history DB, Please advise,
NOT Fixed 3.1/si13.2 Changed both OS Time Zone & Postgres, Data is reflected correctly in history DB (via client) -- some reports are opened with empty IC - br18, br21, br10A -- a Reports crash (Exception) NOT Fixed 3.1/si13.2 (See attached) ================ How I converted Time Zone +++++++++++++++++++++++++++ RHEL6.3 ln -sf /usr/share/zoneinfo/America/Los_Angeles /etc/localtime /etc/sysconfig/clock file (e.g. "America/Los_Angeles") /sbin/hwclock --systohc Postgres SET TIME ZONE 'America/Los_Angeles'; REBOOT ----- v3_1_host_samples_history_view "2012-08-12 22:59:43.776-07" "2012-08-12 22:57:16.452-07" "2012-08-12 22:56:17.339-07" Return to Israel ------------------- "2012-08-13 09:05:59.334+03" "2012-08-13 09:04:46.312+03" "2012-08-13 09:02:58.348+03"
Created attachment 603859 [details] exception
Created attachment 603860 [details] empty IC
Crash summary: Error Message java.lang.ClassCastException: org.ovirt.authentication.EngineUserDetails cannot be cast to com.jaspersoft.jasperserver.api.metadata.user.domain.User
This exception seems unrelated to the case. 1. verify this bug 2. open new bug with this issue and provide steps to reproduce this. Yaniv
Regarding the empty IC window I have a bug - https://bugzilla.redhat.com/show_bug.cgi?id=847606 were u referring to this issue ?
"Error Message: java.lang.ClassCastException: org.ovirt.authentication.EngineUserDetails cannot be cast to com.jaspersoft.jasperserver.api.metadata.user.domain.User" Yaniv
ok
Fixed 3.1/si13.2 For the other issues I will open separate bugs Fixed 3.1/si13.2