Bug 1920830 - Report template "Last Checkin" fails when "Include unknown" is set to false
Summary: Report template "Last Checkin" fails when "Include unknown" is set to false
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Reporting
Version: 6.9.0
Hardware: All
OS: All
unspecified
medium
Target Milestone: 6.9.0
Assignee: satellite6-bugs
QA Contact: Lukáš Hellebrandt
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-01-27 05:58 UTC by Ranjan Kumar
Modified: 2021-05-20 14:27 UTC (History)
3 users (show)

Fixed In Version: foreman-2.3.1.8-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2021-04-21 13:10:30 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 31747 0 Normal Closed Report template "Last Checkin" fails: ERF45-5139 [Foreman::Renderer::Errors::UnknownReportColumn] 2021-02-15 20:58:49 UTC
Red Hat Product Errata RHSA-2021:1313 0 None None None 2021-04-21 13:11:04 UTC

Description Ranjan Kumar 2021-01-27 05:58:06 UTC 
Description of problem: "Last Checkin" report generation fails when "Include unknown" is set to false

Error Message:
ERF45-5139 [Foreman::Renderer::Errors::UnknownReportColumn]: Rendering failed, one or more unknown columns specified for ordering - "Last Checkin"

Error trace:
2021-01-27T11:17:20 [I|app|9311ed11] Started POST "/templates/report_templates/132-Host%20-%20Last%20Checkin/schedule_report" for 127.0.0.1 at 2021-01-27 11:17:20 +0530
2021-01-27T11:17:20 [I|app|9311ed11] Processing by ReportTemplatesController#schedule_report as HTML
2021-01-27T11:17:20 [I|app|9311ed11]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"PB2yA9gbdJjcX/prpOFSApE7Y3ZWSk2mihsYu0C5lco39ONlxwi4nZ4nPj1N/8EN3+r7b4nFRJa4JNL7K62paA==", "report_template_report"=>"[FILTERED]", "commit"=>"Submit", "id"=>"132-Host - Last Checkin"}
2021-01-27T11:17:20 [I|app|9311ed11] Enqueued TemplateRenderJob (Job ID: ea4adf28-1882-4c98-b3ab-bcaa9ad3b6ef) to Dynflow(default) with arguments: {"template_id"=>"132-Host - Last Checkin", "gzip"=>false, "send_mail"=>false, "mail_to"=>"root.redhat.com", "format"=>"csv", "input_values"=>{"23"=>{"value"=>"9 hours"}, "24"=>{"value"=>"os ~ RedHat "}, "25"=>{"value"=>"false"}}}, {:user_id=>4}
2021-01-27T11:17:20 [I|app|9311ed11] Redirected to https://dhcp131-11.gsslab.pnq2.redhat.com/templates/report_templates/132-Host%20-%20Last%20Checkin/report_data?job_id=ea4adf28-1882-4c98-b3ab-bcaa9ad3b6ef
2021-01-27T11:17:20 [I|app|9311ed11] Completed 302 Found in 209ms (ActiveRecord: 36.1ms | Allocations: 23908)
2021-01-27T11:17:20 [I|app|3aa760a0] Started GET "/templates/report_templates/132-Host%20-%20Last%20Checkin/report_data?job_id=ea4adf28-1882-4c98-b3ab-bcaa9ad3b6ef" for 127.0.0.1 at 2021-01-27 11:17:20 +0530
2021-01-27T11:17:20 [I|app|3aa760a0] Processing by ReportTemplatesController#report_data as HTML
2021-01-27T11:17:20 [I|app|3aa760a0]   Parameters: {"job_id"=>"ea4adf28-1882-4c98-b3ab-bcaa9ad3b6ef", "id"=>"132-Host - Last Checkin"}
2021-01-27T11:17:20 [I|app|3aa760a0]   Rendering report_templates/report_data.html.erb within layouts/application
2021-01-27T11:17:20 [I|app|3aa760a0]   Rendered report_templates/report_data.html.erb within layouts/application (Duration: 56.2ms | Allocations: 7403)
2021-01-27T11:17:20 [I|app|3aa760a0]   Rendered layouts/_application_content.html.erb (Duration: 4.0ms | Allocations: 7450)
2021-01-27T11:17:20 [I|app|3aa760a0]   Rendering layouts/base.html.erb
2021-01-27T11:17:20 [I|app|9311ed11] Performing TemplateRenderJob (Job ID: ea4adf28-1882-4c98-b3ab-bcaa9ad3b6ef) from Dynflow(default) enqueued at 2021-01-27T05:47:20Z with arguments: {"template_id"=>"132-Host - Last Checkin", "gzip"=>false, "send_mail"=>false, "mail_to"=>"root.redhat.com", "format"=>"csv", "input_values"=>{"23"=>{"value"=>"9 hours"}, "24"=>{"value"=>"os ~ RedHat "}, "25"=>{"value"=>"false"}}}, {:user_id=>4}
2021-01-27T11:17:20 [I|app|3aa760a0]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_theme_satellite-7.0.1.4/app/views/foreman_theme_satellite/_theme_client_side_branding.js.erb (Duration: 3.1ms | Allocations: 6890)
2021-01-27T11:17:20 [I|app|3aa760a0]   Rendered layouts/base.html.erb (Duration: 33.3ms | Allocations: 38660)
2021-01-27T11:17:20 [I|app|3aa760a0] Completed 200 OK in 116ms (Views: 100.6ms | ActiveRecord: 3.5ms | Allocations: 65727)
2021-01-27T11:17:20 [W|app|9311ed11] Scoped order is ignored, it's forced to be batch order.
2021-01-27T11:17:21 [E|app|9311ed11] Error performing TemplateRenderJob (Job ID: ea4adf28-1882-4c98-b3ab-bcaa9ad3b6ef) from Dynflow(default) in 82.39ms: Foreman::Renderer::Errors::UnknownReportColumn (ERF45-5139 [Foreman::Renderer::Errors::UnknownReportColumn]: Rendering failed, one or more unknown columns specified for ordering - "Last Checkin"):
 9311ed11 | /usr/share/foreman/lib/foreman/renderer/scope/report.rb:74:in `apply_order!'
 9311ed11 | /usr/share/foreman/lib/foreman/renderer/scope/report.rb:27:in `report_render'
 9311ed11 | /opt/theforeman/tfm/root/usr/share/gems/gems/safemode-1.3.6/lib/safemode/scope.rb:37:in `method_missing'
 9311ed11 | Host - Last Checkin:66:in `bind'


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


How reproducible: Always


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:
Comment 4 Lukáš Hellebrandt 2021-03-08 13:44:31 UTC 
Verified with Sat 6.9 snap 16.

Tried with org with hosts and with org without hosts, reports were generated correctly.
Comment 7 errata-xmlrpc 2021-04-21 13:10:30 UTC 
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 (Moderate: Satellite 6.9 Release), 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-2021:1313
Note You need to log in before you can comment on or make changes to this bug.