Bug 1194224

Summary: Error executing SQL statement when opening "Users' Spice Sessions Activity (BR45)" page with period range set to other than daily.
Product: Red Hat Enterprise Virtualization Manager Reporter: Petr Kubica <pkubica>
Component: ovirt-engine-reportsAssignee: Shirly Radco <sradco>
Status: CLOSED DUPLICATE QA Contact: Petr Kubica <pkubica>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.5.0CC: ecohen, gklein, iheim, lsurette, rbalakri, Rhev-m-bugs, yeylon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-02-19 13:19:20 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Displayed errors on page (error.log)
none
logs from reports server
none
screenshot none

Description Petr Kubica 2015-02-19 11:19:17 UTC
Created attachment 993546 [details]
Displayed errors on page (error.log)

Description of problem:
When the period range is set other than daily on page "Users' Spice Sessions Activity (BR45)", there are some errors with SQL.
Detailed information of errors displayed on page is in error.log

Version-Release number of selected component (if applicable):
rhevm-reports-3.5.0-10.el6ev.noarch

How reproducible:
100%

Steps to Reproduce:
1. open "Users' Spice Sessions Activity (BR45)"
2. set period range to yearly
3. click on OK

Actual results:
Error

Expected results:
-

Additional info:
attached log from reports server and screenshot

Comment 1 Petr Kubica 2015-02-19 11:19:54 UTC
Created attachment 993547 [details]
logs from reports server

Comment 2 Petr Kubica 2015-02-19 11:20:17 UTC
Created attachment 993548 [details]
screenshot

Comment 3 Shirly Radco 2015-02-19 13:19:20 UTC

*** This bug has been marked as a duplicate of bug 1184350 ***