Project

General

Profile

Actions

Bug #16358

closed

smart proxy puppet dashboard is broken

Added by Tomer Brisker over 7 years ago. Updated over 5 years ago.

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

Description

 | ActionView::Template::Error (PG::UndefinedTable: ERROR:  missing FROM-clause entry for table "smart_proxies" 
 | LINE 1: ..." WHERE "hosts"."type" IN ('Host::Managed') AND (("smart_pro...
 |                                                              ^
 | : SELECT COUNT(count_column) FROM (SELECT  1 AS count_column FROM "reports" INNER JOIN "hosts" ON "hosts"."id" = "reports"."host_id" AND "hosts"."type" IN ('Host::Managed') WHERE "reports"."type" IN ('ConfigReport') AND (status <> 0) AND "reports"."host_id" IN (SELECT "hosts"."id" FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (("smart_proxies"."name" = 'localproxy'))) AND (("reports"."reported_at" >= '2016-08-23')) LIMIT 9) subquery_for_count):
 |     1: <h4 class="header">
 |     2:   <%= _("Latest Events") %>
 |     3: </h4>
 |     4: <% if @latest_events.empty? %>
 |     5:   <p class="ca"><%= _("No interesting reports received in the last week") %></p>
 |     6: <% else %>
 |     7:   <table class="<%= table_css_classes 'table-fixed reports-table' %>">
 |   app/views/dashboard/_reports_widget.html.erb:4:in `_app_views_dashboard__reports_widget_html_erb___2136443021252204128_187649700'
 |   app/views/smart_proxies/plugins/_puppet_dashboard.html.erb:2:in `_app_views_smart_proxies_plugins__puppet_dashboard_html_erb__957152418137412667_187659560'
 |   app/controllers/smart_proxies_controller.rb:69:in `puppet_dashboard'
 |   app/controllers/concerns/application_shared.rb:14:in `set_timezone'
 |   app/models/concerns/foreman/thread_session.rb:32:in `clear_thread'
 |   lib/middleware/catch_json_parse_errors.rb:9:in `call'
 |   lib/middleware/tagged_logging.rb:18:in `call'
 | 


Related issues 2 (0 open2 closed)

Related to Foreman - Bug #16044: Errors in individual dashboard widgets fail entire pageClosedTomer Brisker08/10/2016Actions
Related to Foreman - Bug #16627: Puppet general tab new error on 1.12.3ClosedTomer Brisker09/20/2016Actions
Actions #1

Updated by Tomer Brisker over 7 years ago

  • Related to Bug #16044: Errors in individual dashboard widgets fail entire page added
Actions #2

Updated by Tomer Brisker over 7 years ago

This was caused by the changes to the main dashboard introduced in #16044

Actions #3

Updated by Dominic Cleal over 7 years ago

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

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/3799 added
Actions #5

Updated by Tomer Brisker over 7 years ago

  • Target version set to 1.6.2
Actions #6

Updated by Anonymous over 7 years ago

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

Updated by Dominic Cleal over 7 years ago

  • Related to Bug #16627: Puppet general tab new error on 1.12.3 added
Actions

Also available in: Atom PDF