Chargeback Report - VM name column empty


#1

Hi
I try to create chargeback report. I add “CPU Used Cost” and “Memory Used Cost” fields, “VM name” field add to report automaticaly. Also I used Filter based on My Company Tag and chose Group by “VM/Instance”. Report preview shows result table but “VM name” column empty. Why is it empty?
Number of raws looks like correct and equal to number of VM with selected Tag, “CPU Used Cost” and “Memory Used Cost” fields are filled with costs.


#2

@gtanzillo can you review this question by @Aydar.Fatykhov and forward to a SME is necessary.


#3

Hey @jprause @gtanzillo
Is there any suggestions or workaround?


#4

Hi @Aydar.Fatykhov

The VM name is being pulled directly from of the performance data. Specifically from the resouece_name column of the metric_rollups table. Seems like you may have some VM performance data where the resource_name is blank. I recall a bug related to that issue. It was fixed with this PR https://github.com/ManageIQ/manageiq/pull/5545.

You can fix the bad rows by running this code in a Rails console:

MetricRollup.includes(:resource).where(:resource_type=>'VmOrTemplate', :resource_name => nil).each do |p|
  p.update_attribute(:resource_name, p.resource.name)
end

I would recommend that you backup your database before executing it.