Bug 1234821
| Summary: | Error after adding Virtual Machines to Statistics Daily domain in ad-hoc reports | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Petr Matyáš <pmatyas> | ||||
| Component: | ovirt-engine-reports | Assignee: | Shirly Radco <sradco> | ||||
| Status: | CLOSED ERRATA | QA Contact: | Petr Matyáš <pmatyas> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 3.6.0 | CC: | gklein, lsurette, oourfali, pstehlik, rbalakri, Rhev-m-bugs, yeylon, ykaul, ylavi | ||||
| Target Milestone: | ovirt-3.6.0-rc | ||||||
| Target Release: | 3.6.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | ovirt-3.6.0-beta2 | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | |||||||
| : | 1257185 (view as bug list) | Environment: | |||||
| Last Closed: | 2016-03-09 21:20:03 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Bug Depends On: | 1209022, 1233193, 1238110 | ||||||
| Bug Blocks: | |||||||
| Attachments: |
|
||||||
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? After checking this there is a problem adding fields from "Running Host Configuration" together with fields from "Users' Usage". 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. 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 |
Created attachment 1042209 [details] Jasperserver log 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