Bug 1920830
| Summary: | Report template "Last Checkin" fails when "Include unknown" is set to false | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Ranjan Kumar <rankumar> |
| Component: | Reporting | Assignee: | satellite6-bugs <satellite6-bugs> |
| Status: | CLOSED ERRATA | QA Contact: | Lukáš Hellebrandt <lhellebr> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.9.0 | CC: | dmatoule, mhulan, oprazak |
| Target Milestone: | 6.9.0 | Keywords: | Triaged |
| Target Release: | Unused | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Fixed In Version: | foreman-2.3.1.8-1 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2021-04-21 13:10:30 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: | |||
Verified with Sat 6.9 snap 16. Tried with org with hosts and with org without hosts, reports were generated correctly. 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 |
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: