Bug 1416628

Summary: Error generating Chargeback reports for SCVMM when storage fields are added to report
Product: Red Hat CloudForms Management Engine Reporter: Nandini Chandra <nachandr>
Component: ReportingAssignee: Gregg Tanzillo <gtanzill>
Status: CLOSED DUPLICATE QA Contact: Nandini Chandra <nachandr>
Severity: high Docs Contact:
Priority: high    
Version: 5.7.0CC: cpelland, dajohnso, jhardy, obarenbo, slukasik
Target Milestone: GA   
Target Release: 5.7.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: chargeback:scvmm
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-01-26 15:58:11 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:

Description Nandini Chandra 2017-01-26 05:41:26 UTC
Description of problem:
-----------------------
I'm unable to generate Chargeback reports for SCVMM when the following fields are added to the report.I can successfully generate Chargeback reports when other fields are added to the report.


Storage Allocated , Storage Allocated Cost

Here's a snippet from evm.log:

[----] E, [2017-01-19T14:57:46.543893 #2945:73f140] ERROR -- : [FloatDomainError]: Infinity Method:[rescue in _async_generate_table]
[----] E, [2017-01-19T14:57:46.544229 #2945:73f140] ERROR -- : /var/www/miq/vmdb/app/models/chargeback_rate_detail.rb:62:in to_r' /var/www/miq/vmdb/app/models/chargeback_rate_detail.rb:62:in<='
/var/www/miq/vmdb/app/models/chargeback_rate_detail.rb:62:in block in find_rate' /opt/rubies/ruby-2.3.1/lib/ruby/gems/2.3.0/gems/activerecord-5.0.1/lib/active_record/associations/collection_association.rb:92:inblock in select'
/opt/rubies/ruby-2.3.1/lib/ruby/gems/2.3.0/gems/activerecord-5.0.1/lib/active_record/associations/collection_association.rb:92:in select' /opt/rubies/ruby-2.3.1/lib/ruby/gems/2.3.0/gems/activerecord-5.0.1/lib/active_record/associations/collection_association.rb:92:ineach'
/opt/rubies/ruby-2.3.1/lib/ruby/gems/2.3.0/gems/activerecord-5.0.1/lib/active_record/associations/collection_association.rb:92:in select' /opt/rubies/ruby-2.3.1/lib/ruby/gems/2.3.0/gems/activerecord-5.0.1/lib/active_record/associations/collection_proxy.rb:110:inselect'
/var/www/miq/vmdb/app/models/chargeback_rate_detail.rb:60:in find_rate' /var/www/miq/vmdb/app/models/chargeback_rate_detail.rb:84:inhourly_cost'
/var/www/miq/vmdb/app/models/chargeback_rate_detail.rb:236:in metric_and_cost_by' /var/www/miq/vmdb/app/models/chargeback_rate_detail.rb:26:incharge'
/var/www/miq/vmdb/app/models/chargeback.rb:71:in block (2 levels) in calculate_costs' /var/www/miq/vmdb/app/models/chargeback.rb:70:ineach'
/var/www/miq/vmdb/app/models/chargeback.rb:70:in block in calculate_costs' /var/www/miq/vmdb/app/models/chargeback.rb:69:ineach'
/var/www/miq/vmdb/app/models/chargeback.rb:69:in calculate_costs' /var/www/miq/vmdb/app/models/chargeback.rb:29:inblock in build_results_for_report_chargeback'
/var/www/miq/vmdb/app/models/chargeback/consumption_history.rb:15:in block (2 levels) in for_report' /opt/rubies/ruby-2.3.1/lib/ruby/gems/2.3.0/gems/activerecord-5.0.1/lib/active_record/relation/delegation.rb:38:ineach'
/opt/rubies/ruby-2.3.1/lib/ruby/gems/2.3.0/gems/activerecord-5.0.1/lib/active_record/relation/delegation.rb:38:in each' /var/www/miq/vmdb/app/models/chargeback/consumption_history.rb:14:inblock in for_report'
/var/www/miq/vmdb/app/models/chargeback/consumption_history.rb:13:in each' /var/www/miq/vmdb/app/models/chargeback/consumption_history.rb:13:ineach_cons'
/var/www/miq/vmdb/app/models/chargeback/consumption_history.rb:13:in for_report' /var/www/miq/vmdb/app/models/chargeback.rb:19:inbuild_results_for_report_chargeback'
/var/www/miq/vmdb/app/models/chargeback_vm.rb:45:in build_results_for_report_ChargebackVm' /var/www/miq/vmdb/app/models/miq_report/generator.rb:193:in_generate_table'
/var/www/miq/vmdb/app/models/miq_report/generator.rb:167:in block in generate_table' /var/www/miq/vmdb/app/models/user.rb:241:inwith_user'
/var/www/miq/vmdb/app/models/miq_report/generator.rb:167:in generate_table' /var/www/miq/vmdb/app/models/miq_report/generator/async.rb:96:in_async_generate_table'
/var/www/miq/vmdb/app/models/miq_queue.rb:347:in block in deliver' /opt/rubies/ruby-


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


How reproducible:
-----------------
Always


Steps to Reproduce:
-------------------
1.Manage a provider.Enable C&U for the provider.
2.Assign Compute rates and generate a Chargeback report.


Actual results:
---------------
Error generating Chargeback reports.


Expected results:
-----------------
No errors while generating Chargeback reports.


Additional info:
-----------------
https://github.com/ManageIQ/manageiq/issues/13591

Comment 3 Šimon Lukašík 2017-01-26 15:58:11 UTC
Indeed.

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