Bug 1743579

Summary:	Created on Time report field doesn't yield any data
Product:	Red Hat CloudForms Management Engine	Reporter:	Parthvi Vala <pvala>
Component:	Reporting	Assignee:	Gregg Tanzillo <gtanzill>
Status:	POST ---	QA Contact:	Sudhir Mallamprabhakara <smallamp>
Severity:	medium	Docs Contact:	Red Hat CloudForms Documentation <cloudforms-docs>
Priority:	medium
Version:	5.11.0	CC:	dmetzger, jocarter
Target Milestone:	GA	Flags:	yrudman: needinfo? (jocarter)
Target Release:	5.11.z
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	Inquiry
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	CFME Core	Target Upstream Version:
Embargoed:

Description Parthvi Vala 2019-08-20 09:10:37 UTC

Description of problem:
There are some time-related fields that do not yield any data when queued.

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

How reproducible:
Always

Steps to Reproduce:
1. Create a report based on VMs and Instances and fields - name, boot time and created on time.
2. Queue the report
3. Check the `Created on Time` column

Actual results:
1.
2.
3. No data is visible under the column.

Expected results:
1.
2.
3. Time on which the reports were created must be available under the column.

Additional info:
I checked by creating a fresh VM, but I didn't see any data for that.
There are other time fields as well that do not yield any data.
Same issue exists on 5.10.

Comment 2 Yuri Rudman 2019-08-20 12:41:31 UTC

There is settings in config/settings.yml (or in advanced settings in UI) telling if this date should be set: ems_refresh.capture_vm_created_on_date
It looks like default value is false.

If that flag is true than date filed will be populated for all newly added vm(s)

Could you set ems_refresh.capture_vm_created_on_date to true, add new VM and check if date is present

Comment 3 Parthvi Vala 2019-08-20 13:26:10 UTC

I created a new VM after setting `ems_refresh.capture_vm_created_on_date` to true, but it didn't populate the `Created at Time` column in the report.

Comment 7 CFME Bot 2019-08-21 21:05:57 UTC

https://github.com/ManageIQ/manageiq/pull/19185

Comment 15 CFME Bot 2019-08-27 15:05:58 UTC

New commit detected on ManageIQ/manageiq/master:

https://github.com/ManageIQ/manageiq/commit/fb27840916024f4918cbce2a6abb09f63fbc10e6
commit fb27840916024f4918cbce2a6abb09f63fbc10e6
Author:     Yuri Rudman <yrudman>
AuthorDate: Wed Aug 21 16:21:51 2019 -0400
Commit:     Yuri Rudman <yrudman>
CommitDate: Wed Aug 21 16:21:51 2019 -0400

    fix: no reject! exists on ActiveRecord_Relation, use reject instead, whcih converts ActiveRecord_Relation to Array
    Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1743579

 app/models/vm_or_template.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)