Project

General

Profile

Actions

Bug #16044

closed

Errors in individual dashboard widgets fail entire page

Added by Daniel Lobato Garcia over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Dashboard
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1353749
Description of problem:
when using filters for Dashboard in Satellite 6.2 an sql error occurs.

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

How reproducible:

Always
Steps to Reproduce:
1.Create filters for users.
2.login as user and press dashboard.
3.

Actual results:
Oops, we're sorry but something went wrong PG::Error: ERROR: missing FROM-clause entry for table "katello_host_collections" LINE 1: ...id" IN (1) AND "hosts"."location_id" IN (2) AND (("katello_h... ^ : SELECT COUNT FROM (SELECT DISTINCT "katello_errata"."id" AS count_column FROM "katello_errata" INNER JOIN "katello_content_facet_errata" ON "katello_content_facet_errata"."erratum_id" = "katello_errata"."id" INNER JOIN "katello_content_facet_errata" "content_facet_errata_katello_errata_join" ON "content_facet_errata_katello_errata_join"."erratum_id" = "katello_errata"."id" INNER JOIN "katello_content_facets" ON "katello_content_facets"."id" = "content_facet_errata_katello_errata_join"."content_facet_id" WHERE "katello_content_facets"."host_id" IN (SELECT "hosts"."id" FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."organization_id" IN (1) AND "hosts"."location_id" IN (2) AND (("katello_host_collections"."name" ILIKE 'oss%'))) LIMIT 6) subquery_for_count

Expected results:
Seeing the dashboard.

Additional info:


Related issues 13 (1 open12 closed)

Related to Foreman - Tracker #8107: Dashboard refactoring trackerNewTomer Brisker10/26/2014

Actions
Related to OpenSCAP - Bug #16123: After upgrade "undefined method `name' for nil:NilClass" when visiting dashboard (oscap widget)ClosedOri Rabin08/16/2016Actions
Related to Katello - Bug #14429: Katello - deleting version 1 and associated content views caused undefined method `name' for nil:NilClass Rejected03/31/2016Actions
Related to Foreman - Bug #16238: dashboard widget for latests events can be exteramlly slowClosedOhad Levy08/23/2016Actions
Related to Foreman - Bug #16260: Intermittent DashboardIntegrationTest failuresClosedTomer Brisker08/24/2016Actions
Related to Foreman - Refactor #8108: use AJAX to load Dashboard widgetsResolvedTomer Brisker10/26/2014Actions
Related to Foreman - Bug #16358: smart proxy puppet dashboard is brokenClosedTomer Brisker08/29/2016Actions
Related to Foreman - Bug #16702: dashboard widgets ignore filtersClosedTomer Brisker09/27/2016Actions
Related to Foreman - Refactor #16723: Lazy load data for dashboard widgetsClosedTomer Brisker09/28/2016Actions
Related to Foreman - Bug #15287: link in graph on Smart proxy -> Puppet page have "undefined" as smart proxy nameClosedTomer Brisker06/03/2016Actions
Related to Foreman - Bug #16704: Searching fails on dashboardClosedTomer Brisker09/27/2016Actions
Related to Katello - Bug #17244: Error accessing dashboard when user has filtered access to hostsClosedTomer Brisker11/07/2016Actions
Has duplicate Foreman - Bug #11316: A bad widget breaks the entire dashboardDuplicate08/07/2015Actions
Actions #1

Updated by Daniel Lobato Garcia over 7 years ago

  • Target version set to 117

Cloned this to Foreman because we should handle dashboard failures from plugin gracefully (currently they break the entire page if just one widget fails)

Actions #2

Updated by Dominic Cleal over 7 years ago

  • Subject changed from ActiveRecord::StatementInvalid in dashboard to Errors in individual dashboard widgets fail entire page
  • Category set to Dashboard
  • Priority changed from High to Normal
Actions #3

Updated by Daniel Lobato Garcia over 7 years ago

  • Target version changed from 117 to 1.6.2
Actions #4

Updated by Tomer Brisker over 7 years ago

  • Status changed from New to Assigned
  • Assignee set to Tomer Brisker
Actions #5

Updated by The Foreman Bot over 7 years ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/3762 added
Actions #6

Updated by Tomer Brisker over 7 years ago

Actions #7

Updated by Tomer Brisker over 7 years ago

  • Related to Bug #16123: After upgrade "undefined method `name' for nil:NilClass" when visiting dashboard (oscap widget) added
Actions #8

Updated by Tomer Brisker over 7 years ago

  • Related to Bug #14429: Katello - deleting version 1 and associated content views caused undefined method `name' for nil:NilClass added
Actions #9

Updated by Ohad Levy over 7 years ago

  • Related to Bug #16238: dashboard widget for latests events can be exteramlly slow added
Actions #10

Updated by Anonymous over 7 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions #11

Updated by Dominic Cleal over 7 years ago

  • Related to Bug #16260: Intermittent DashboardIntegrationTest failures added
Actions #12

Updated by Dominic Cleal over 7 years ago

  • translation missing: en.field_release set to 160
Actions #13

Updated by Tomer Brisker over 7 years ago

Actions #14

Updated by Tomer Brisker over 7 years ago

  • Related to Bug #16358: smart proxy puppet dashboard is broken added
Actions #15

Updated by Dominic Cleal over 7 years ago

  • Related to Bug #16702: dashboard widgets ignore filters added
Actions #16

Updated by Dominic Cleal over 7 years ago

Actions #17

Updated by Tomer Brisker over 7 years ago

  • Related to Bug #15287: link in graph on Smart proxy -> Puppet page have "undefined" as smart proxy name added
Actions #18

Updated by Tomer Brisker over 7 years ago

  • Related to Bug #16704: Searching fails on dashboard added
Actions #19

Updated by Tomer Brisker over 7 years ago

  • Related to Bug #17244: Error accessing dashboard when user has filtered access to hosts added
Actions #20

Updated by Tomer Brisker over 7 years ago

  • Has duplicate Bug #11316: A bad widget breaks the entire dashboard added
Actions

Also available in: Atom PDF