Bug 1243662

Summary:	[rhevm-reports] reports are not generating with "No data available" message.
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Ulhas Surse <usurse>
Component:	ovirt-engine-reports	Assignee:	Shirly Radco <sradco>
Status:	CLOSED ERRATA	QA Contact:	Lukas Svaty <lsvaty>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	3.5.3	CC:	lsurette, melewis, rbalakri, Rhev-m-bugs, usurse, vaibhav.sonivs, vchoudha, yeylon, ykaul, ylavi
Target Milestone:	ovirt-3.6.0-rc2	Keywords:	Reopened, Tracking, ZStream
Target Release:	3.6.0
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	Previously, there were issues in the SQL queries of BR2A and BR10A reports regarding disk and network usage. This meant that network usage was not displayed in BR2A and BR10A and disk was not displayed in BR10A. Now, the SQL queries have been corrected so that the data is shown in the reports.	Story Points:	---
Clone Of:
Clones:	1271522 (view as bug list)		Environment:
Last Closed:	2016-03-09 21:20:08 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:	1209999
Bug Blocks:	1271522

Description Ulhas Surse 2015-07-16 04:37:26 UTC

Description of problem:
While generating report, the data not avaialable message is displayed for some reports. Even the data is available say for 1 year.

Version-Release number of selected component (if applicable):
rhevm-dwh-3.5.3-2.el6ev.noarch
rhevm-reports-3.5.3-1.el6ev.noarch

How reproducible:
Always

Steps to Reproduce:
1. Try to generate reports: 
  Summary of Host Usage Resources (BR17)
  Datacenter Storage Space Status (DR8)
  Datacenter Top Five Used Storage Domain (DR26)
  Storage Domains Inventory (BR47)

Actual results:
No output or graph

Expected results:
There must be data on the graph/ report

Additional info:
I tried this internally and same results are there.

Comment 5 Yaniv Lavi 2015-07-20 10:00:23 UTC

Is the DWH running? Can you attach the DWH log?

Comment 20 vaibhav 2015-08-16 05:11:47 UTC

till when we have to wait for to resolve this BUG

Comment 21 Yaniv Lavi 2015-08-18 11:16:25 UTC

We are still trying to understand what is not working. To my understanding there was issue with DR reports. DR reports are webadmin dashboard reports. They can not be run via reports portal only via webadmin dashboard tab. If you connect with user via SSO or user role you can execute them, but not see them. If you connect with admin you see all resources, even DR reports.

What other reports do not work as expected?

Comment 29 Yaniv Lavi 2015-10-11 17:39:29 UTC


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

Comment 33 Yaniv Lavi 2015-10-14 13:12:37 UTC

Same as BZ #1209999. It's the same issue.

Comment 34 Lukas Svaty 2015-10-15 10:36:04 UTC

verified in rhevm-reports-3.6.0-0.7.el6ev.noarch

Comment 40 errata-xmlrpc 2016-03-09 21:20:08 UTC

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