Bug 1372267 - Chargeback of openstack instances are all blank
Summary: Chargeback of openstack instances are all blank
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Reporting
Version: 5.6.0
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: GA
: cfme-future
Assignee: Gregg Tanzillo
QA Contact: Ola Pavlenko
URL:
Whiteboard: openstack:chargeback
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-09-01 09:51 UTC by Sachin
Modified: 2020-01-17 15:54 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-02-13 13:37:56 UTC
Category: ---
Cloudforms Team: Openstack
Target Upstream Version:


Attachments (Terms of Use)

Description Sachin 2016-09-01 09:51:12 UTC
Description of problem:

After applying a bugfix from https://bugzilla.redhat.com/show_bug.cgi?id=1370422, the chargeback of openstack instance are blank.

Version-Release number of selected component (if applicable):
CFME-5.6.1


Steps to Reproduce:

1. Create a tag category called 'chargeback';
2. Create two tags 'sample0' and 'sample1' in the category that we just created;
3. Switch to 'Cloud Intel' -> 'Chargeback' -> 'Rates' and create two new ones called 'Low-Rate Sample' and 'High-Rate Sample';
4. Switch to 'Assignments', and assign rate 'Low-Rate Sample' to tag 'sample0' and 'High-Rate Sample' to 'sample1';
5. Switch to 'Compute' -> 'Cloud' -> 'Instances', tag some vms/instances with 'sample0', and the others with 'sample1';
6. Switch to 'Cloud Intel' -> 'Reports' -> 'Reports', Create a new report called 'Custom Chargeback', which is based on 'Chargeback for VMs';
7. Edit the report we just created, and add the following fields to the report:
  * CPU Total
  * CPU Total Cost
  * Memory Total
  * Memory Total Cost
  * Storage Total
  * Storage Total Cost
  * Owner
  * Fixed Total Cost
  * Total Cost
8. Then click the 'Queue' button to generate a new report sheet.


Actual results:

Host/Node utilization can be seen under Cloud -> Instance


Expected results:



Additional info:

Comment 3 Sachin 2016-09-02 07:18:40 UTC
Reproducer: 10.65.9.185(CFME-5.6.1.2)
Dumped customer's vmdb


I see non-zero values for column 'cpu_usage_rate_average' for metrics and metric_rollups tables. The column 'cpu_usage_rate_average' had ZERO value. before applying the patch.

---
select cpu_usage_rate_average from metric_rollups where resource_name='helloworld';
select cpu_usage_rate_average from metrics where resource_name='helloworld';
---

Let me know if you need anything else.


--
Sachin

Comment 4 Sachin 2016-09-26 13:38:25 UTC
Any update on this bug?

Comment 10 Sachin 2016-10-27 05:21:40 UTC
Hello Gregg,

Are you working on a reproducer(db dump attached) or do you want me to create a new one?

Comment 11 Šimon Lukašík 2017-02-13 10:36:17 UTC
I cannot reproduce this one.

I didn't used the db. However, I picked 5.6.4.0.20170201130751_9521533 (that has bug 1370586 included). I added fresh openstack and I followed the reproducer steps closely. The chargeback shows values just fine.

Sachin, does the customer still experiences the problem?

Comment 12 Sachin 2017-02-13 10:38:55 UTC
Customer did'nt came back and the case has been archived. If the chargeback is working as expected. We can close this case.


Note You need to log in before you can comment on or make changes to this bug.