Created attachment 1177472 [details] Trace from sat error.. 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(DISTINCT count_column) 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:
Hi Kim, can you provide more details on the user? For example, what roles/filters were associated with the user? Did the Satellite have any host collections?
Created attachment 1177805 [details] Filter description. This is the filters for the user, however in this text you dont see the Dashboard filter, this were added at the time of the bug, however removed here, in order to temporary work arround it.
Can you attach the foreman-debug for your Satellite? Was this error observed on an internal Satellite 6.2 build ? Or on the official Beta or Beta2 builds?
The official beta 2 build. i will make a debug now.
have added the debug, the last output from the debug were 016-07-13 04:30:55 [app] [W] Action failed | ActiveRecord::StatementInvalid: 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(DISTINCT count_column) 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
Created redmine issue http://projects.theforeman.org/issues/16044 from this bug
Upstream bug assigned to tbrisker
Moving to POST since upstream bug http://projects.theforeman.org/issues/16044 has been closed
Verified in Satellite 6.3 snap 6, user with filters mentioned in comment #4 (+ access_dashboard) can now view the dashboard without complications.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2018:0336