Red Hat Bugzilla – Bug 1257185
Error after adding Virtual Machines to Statistics Daily domain in ad-hoc reports
Last modified: 2016-02-10 15:13:09 EST
Created attachment 1067238 [details]
+++ 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):
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
--- 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.
why did you clone this bug?
Because it happens on 3.5 as well as 3.6
We won't fix this unless customer requests this