Created attachment 992255 [details]
screenshot

the same error is on "Inventory Dashboard", "System Overview Dashboard" and "Uptime Dashboard" page too

(In reply to Petr Kubica from comment #0)
> Created attachment 992254 [details]
> reports-log
> 
> Description of problem:
> While choosing period range to different than daily in Host OS Break Down
> (BR22B) for system overview.
> 
> it give me an:
> 
> Unexpected error
> 
> com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL
> statement for : startDate
> 
> Version-Release number of selected component (if applicable):
> rhevm-reports-3.5.0-10.el6ev.noarch
> 
> How reproducible:
> 100%
> 
> Steps to Reproduce:
> 1. Open "Host OS Break Down (BR22B) for system overview" page
> 2. Choose period range to yearly
> 
> Actual results:
> Enexpected error.
> 
> Additional info:
> attached logs from repors

Hi Petr,

Please attach a db dump for history db:
/usr/bin/pg_dump -U "<user>" -F custom -f "<file>" "<db name>"

Created attachment 995517 [details]
pg_dump of ovirt_engine_history db

Hi Shirly,

Dump attached.
Created using the provided command.

I now tried to reproduce this error but with no success.
Can you please check if this still persists?

I can still reproduce this error in rhevm-reports-3.5.3-1.el6ev.noarch
jasper-libs-1.900.1-16.el6_6.3.x86_64
jasperreports-server-pro-5.5.0-10.el6ev.noarch

Installed as clean environment without any data

my steps:
1. install engine & dwh & reports
2. open Host OS Break Down (BR22B) for system overview
3. click on Options
4. Change Daily to Monthly

during the change, it shows the same error

(In reply to Petr Kubica from comment #8)
> my steps:
> 1. install engine & dwh & reports
> 2. open Host OS Break Down (BR22B) for system overview
> 3. click on Options
> 4. Change Daily to Monthly
> 
> during the change, it shows the same error

Are you using reports portal dashboards or directly accessing report?
Because this is in 'System Reasources' which should not be accessed directly and user role can not see only execute.

I'm using reports portal and I opened Host OS Break Down (BR22B) for system overview in Library. I login as "admin" to reports portal. The issue is still in rhevm-reports-3.5.3-1.el6ev.noarch.

(In reply to Petr Kubica from comment #10)
> I'm using reports portal and I opened Host OS Break Down (BR22B) for system
> overview in Library. I login as "admin" to reports portal. The issue is
> still in rhevm-reports-3.5.3-1.el6ev.noarch.

You should not test reports that are located in 'System Resources'.
You can login with user role and you won't even see them.
This report should be tested via the reports portal dashboards that are in the 'Dashboards' folder, do you see a error using system overview dashboard?

If you show the dashboards in reports portal (home -> dashboard - View list) and you open the "Inventory Domain" or "System Overview Dashboard" and change the "Period range", you will see the same exception. (I wrote about this in comment #2)

If the user (admin) see the items in Library and opened them (he can access to these items), it should work. Any exception shouldn't be displayed and it should display the relevant data. 
The second way is hide 'non-working' items in Library if the admin should not working with them. So he will not be confused when he will see the exception.

After the startDate exceptions, if you try to change Date, you will see another exception:

Unexpected error
com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL statement for : Data_Centers

RHEV 3.6.0 BETA2 is out, any open bugs are moved to the BETA3 milestone.

Verified in rhevm-reports-3.6.2.1-1.el6ev.noarch

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHEA-2016-0425.html