Description of problem:
VM utilization report for 2 weeks doesn't show the data for all consecutive dates, data is missing for random dates
Version-Release number of selected component (if applicable):
Everytime at Cu environment
Steps to Reproduce:
1. Navigate to Cloud Intel>Reports>UIDAI- VM Utilization Report
2. Queue the report or check the save reports
From a period of 24 Apr to 8 May (2 weeks), many dates are missing
Report shouldn't skip any date
Ned to verify -
1. That c&U data exists for the missing periods.
2. If the data is missing, check the queue to see if C&U collection and processing is not backed up
Checked that data exists
Querying daily C&U for that VM in that time profile shows that there is C&U data for the missing days-
vm=Vm.where(:name => "UIDAI_DB_Server_02").take
pp vm.metric_rollups.where(:capture_interval_name=>"daily").where(:time_profile => TimeProfile.find_by_description("IST")).where(["timestamp > ?",16.days.ago.utc]).map(&:timestamp).uniq.sort
[Sun, 22 Apr 2018 18:30:00 UTC +00:00,
Mon, 23 Apr 2018 18:30:00 UTC +00:00,
Tue, 24 Apr 2018 18:30:00 UTC +00:00,
Wed, 25 Apr 2018 18:30:00 UTC +00:00,
Thu, 26 Apr 2018 18:30:00 UTC +00:00,
Fri, 27 Apr 2018 18:30:00 UTC +00:00,
Sat, 28 Apr 2018 18:30:00 UTC +00:00,
Sun, 29 Apr 2018 18:30:00 UTC +00:00,
Mon, 30 Apr 2018 18:30:00 UTC +00:00,
Tue, 01 May 2018 18:30:00 UTC +00:00,
Wed, 02 May 2018 18:30:00 UTC +00:00,
Thu, 03 May 2018 18:30:00 UTC +00:00,
Fri, 04 May 2018 18:30:00 UTC +00:00,
Sat, 05 May 2018 18:30:00 UTC +00:00,
Sun, 06 May 2018 18:30:00 UTC +00:00]
Further investigation is needed to determine why the report is not picking up the data for those days
Niladry, do you know when this report stop working correctly, any recent changes ?
"UIDAI - VM Utilization Report" is custom report created at 2018-04-13 06:06:22.159316.
Was it working correctly originally or did not work properly from the beginning ?
After downloading the DB locally and inspecting the report we discovered the the report includes 3 columns for consolidation -
"Number of CPU Cores Allocated"
"CPU - Usage Average Intervals (%)"
Rows that have the same values in those columns (we determined that there are, in fact matching rows) will be merged together into a single row. This means that the rows for the days that appear to be missing on the report were merged into a single row. With regard to the randomness of the missing dates, that is explained by the fact that there are some days that match values in the above columns and some that don't. The days that don't match will always be visible as a separate row on the report. This is all working as designed.
If the consolidation is removed from the report, all dates in the range are shown.
We saw the same consolidation on several other reports. So it appears that this particular report configuration was intentional.