Created attachment 1067238[details]
jasper log
+++ This bug was initially created as a clone of Bug #1234821 +++
Description of problem:
Error after trying to add Virtual Machines field to either rows or columns in ad-hoc reports.
Version-Release number of selected component (if applicable):
3.6
How reproducible:
always on my setup
Steps to Reproduce:
1. open reports portal
2. create new ad-hoc report from statistics daily domain
3. try to add virtual machine field to either row or column
Actual results:
error
Expected results:
no error
Additional info:
ovirt-engine-3.6.0-0.0.master.20150622174128.gitd7d1d87.el6.noarch
ovirt-engine-dwh-3.6.0-0.0.master.20150617151108.20150617150804.gitfccbb7a.el6.noarch
rhevm-reports-3.6.0-0.0.master.20150602141841.el6ev.noarch
jasperreports-server-pro-6.0.1-1.el6ev.noarch
--- Additional comment from Shirly Radco on 2015-06-24 10:49:10 CEST ---
For Statistics Daily and Hourly domains, If I add the Virtual Machines fields in parts I can add all of them with no error.
If I try adding all of them at the same time I get an error:
"An error occurred while performing the previous request."
And after that I get this error if I try adding any field. The ad hoc view is corrupted.
This seems like a Jasper server bug. I'm guessing due to the amount of fields in this section.
Yaniv, What do you think?
--- Additional comment from Shirly Radco on 2015-06-24 13:22:25 CEST ---
After checking this there is a problem adding fields from "Running Host Configuration" together with fields from "Users' Usage".
--- Additional comment from Yaniv Dary on 2015-06-29 09:29:23 CEST ---
It's cased by:
"public_v3_6_statistics_vms_users_usage_hourly"."currently_running_on_host" = "running_on_host"."history_id"
currently_running_on_host is UUID and history_id is int.
The join is wrong, needs to be current_host_configuration_version.