Description of problem:
total costs no longer showing in any chargeback report if they are the only columns in the report
Version-Release number of selected component (if applicable):
all the time
Steps to Reproduce:
1.upgrade to 22.214.171.124 an old appliance which had reports generated that only use total costs in their columns
the old reports no longer show any data, new reports won't either
consistant behaviour with older versions of cfme showing the total costs
if more rows are added to the reports, new generated reports will show data
> the old reports no longer show any data, new reports won't either
Felix, I guess I was looking at this part too... that new reports weren't working. Clearly, they were for me. Are you seeing them work? I checked that first, because if new reports weren't working, it was highly likely that old reports wouldn't either.
See prior attachment. We have €0.00 in the database directly for the report result details so, either they're mistaken about saved reports showing the correct data or somehow the database rows were modified since they worked.
Are you sure this specific report was working with an older version? I am confused.
See following attachment of the report I'm asking about... make sure this is the one and followup with what the customer says.
Upon reviewing the case I'm also mistaken in reporting that reports were empty - they are empty or have a value of 0.
the customer's words were
Chargeback reports appear with Memory, CPU or Storage Total costs equal to zero if these are the only selected fields.
If I add the following Selected Fields when basing a report on Chargebac for Vms:
Memory Total Cost
CPU Total Cost
Storage Total Cost
Network I/O Used Cost
then, by themselves only the Network shows costs. To make it possible to have a complete costs, one needs also to add to the report the rest of the costs adding up, such as the Memory Allocated Cost, or the vCPUs Allocated cost, which are parts of the cost.
however from the exported reports they provided as you will see in attachment 1430563 [details] there is no value in some of the fields, leading me to this description.
while I'm waiting to hear if they have a copy of their 4.1 database, let me know if this helps.
I just wanted to let you know that I have recreated the problem. There's clearly a bug, where some fields, such as Memory Cost do not get calculated if another field like Memory Allocated Cost isn't also in the report. This is a bug and we'll fix it.
Note, I did a quick look at the 5.8 vs. 5.7 code and it appears that this problem would have also existed in 5.7. From the prior comments, it's hard to understand if they're saying that this exact same report worked on 5.7. In other words, I think the same report would have empty values on both 5.7 and 5.8. I will try to verify what versions that have this problem and report back.
I haven't fixed this yet but wanted to let you know that we understand the problem and how to fix it.
(In reply to Joe Rafaniello from comment #15)
> I just wanted to let you know that I have recreated the problem. There's
> clearly a bug, where some fields, such as Memory Cost do not get calculated
> if another field like Memory Allocated Cost isn't also in the report. This
> is a bug and we'll fix it.
> Note, I did a quick look at the 5.8 vs. 5.7 code and it appears that this
> problem would have also existed in 5.7. From the prior comments, it's hard
> to understand if they're saying that this exact same report worked on 5.7.
> In other words, I think the same report would have empty values on both 5.7
> and 5.8. I will try to verify what versions that have this problem and
> report back.
> I haven't fixed this yet but wanted to let you know that we understand the
> problem and how to fix it.
New commit detected on ManageIQ/manageiq/master:
Author: Joe Rafaniello <email@example.com>
AuthorDate: Fri May 4 17:34:10 2018 -0400
Commit: Joe Rafaniello <firstname.lastname@example.org>
CommitDate: Fri May 4 17:34:10 2018 -0400
Check all costs fields for relevancy for the report
If a user asks only for some of the fields (memory cost) in a chargeback report
and they didn't request specific ones (memory allocated cost), we would skip
calculating the memory cost because we thought it wasn't relevant. We need to
check all cost fields to see if they're relevant for the requested fields in the
app/models/chargeback_rate_detail.rb | 2 +-
spec/models/chargeback_vm_spec.rb | 11 +
2 files changed, 12 insertions(+), 1 deletion(-)
Verified on 126.96.36.199.