Bug 1558087
| Summary: | [Regression]Error with report policy event for the last 7 days | |||
|---|---|---|---|---|
| Product: | Red Hat CloudForms Management Engine | Reporter: | thiebaut fischer <tfischer> | |
| Component: | UI - OPS | Assignee: | Harpreet Kataria <hkataria> | |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Ievgen Zapolskyi <izapolsk> | |
| Severity: | high | Docs Contact: | ||
| Priority: | high | |||
| Version: | 5.9.0 | CC: | abellott, cpelland, hkataria, izapolsk, lavenel, mpovolny, obarenbo, yrudman | |
| Target Milestone: | GA | Keywords: | TestOnly, ZStream | |
| Target Release: | 5.10.0 | Flags: | tfischer:
needinfo-
|
|
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | ||||
| Fixed In Version: | 5.10.0.0 | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1561079 (view as bug list) | Environment: | ||
| Last Closed: | 2019-02-11 14:01:55 UTC | Type: | Bug | |
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Embargoed: | ||||
| Bug Depends On: | ||||
| Bug Blocks: | 1561079 | |||
New commit detected on ManageIQ/manageiq/master: https://github.com/ManageIQ/manageiq/commit/8b167fd420f6d7e2ef1d4a3d52e4b9bf92ee4127 commit 8b167fd420f6d7e2ef1d4a3d52e4b9bf92ee4127 Author: Harpreet Kataria <hkataria> AuthorDate: Fri Mar 23 11:05:51 2018 -0400 Commit: Harpreet Kataria <hkataria> CommitDate: Fri Mar 23 11:05:51 2018 -0400 Fixed case of expression in OOTB report. This was causing an issue when copying this report and trying to change an expression of new report. Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1558087 product/reports/520_Events - Policy/120_Policy Events2.yaml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) Verified in 5.10.0.2 |
Description of problem: Error message while trying to display this timeline: Error building timeline PG::UndefinedTable: ERROR: missing FROM-clause entry for table "miq_sets" LINE 1: ...s"."ems_id" AS t0_r15 FROM "policy_events" WHERE ("miq_sets"... ^ : SELECT "policy_events"."id" AS t0_r0, "policy_events"."miq_event_definition_id" AS t0_r1, "policy_events"."event_type" AS t0_r2, "policy_events"."miq_event_definition_description" AS t0_r3, "policy_events"."miq_policy_id" AS t0_r4, "policy_events"."miq_policy_description" AS t0_r5, "policy_events"."result" AS t0_r6, "policy_events"."timestamp" AS t0_r7, "policy_events"."target_id" AS t0_r8, "policy_events"."target_class" AS t0_r9, "policy_events"."target_name" AS t0_r10, "policy_events"."chain_id" AS t0_r11, "policy_events"."username" AS t0_r12, "policy_events"."host_id" AS t0_r13, "policy_events"."ems_cluster_id" AS t0_r14, "policy_events"."ems_id" AS t0_r15 FROM "policy_events" WHERE ("miq_sets"."created_on" BETWEEN '2018-03-19 00:00:00' AND '2018-03-25 23:59:59.999999') Version-Release number of selected component (if applicable): Version 5.9.1.0.20180314203929_67fd99d How reproducible: Always Steps to Reproduce: 1. setup a vm and a policy 2. generate a policy event and make sure it is appearing on the vm timeline. 3. copy the report (cloud intel/reports/reports) policy event for the last 7 days and change the filter to This Week Actual results: Error message mentioned before Expected results: see the timeline and the events Additional info: Worked in the previous versions