Bug 1419132

Summary: error when clicking operating system under OS trend report
Product: Red Hat Satellite Reporter: Chris Duryee <cduryee>
Component: TrendsAssignee: Ivan Necas <inecas>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.2.7CC: bbuckingham, jcallaha, orabin
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-02-12 09:36:59 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:

Description Chris Duryee 2017-02-03 16:33:09 UTC
Description of problem:

If you go to monitor->trends and click operating systems, a report will appear. If you click any of the operating systems listed under the graph, you'll get this error:

2017-02-03 11:30:04 [app] [W] Action failed
 | ActiveRecord::StatementInvalid: PG::Error: ERROR:  invalid input syntax for integer: "all"
 | LINE 1: ...s"."operatingsystem_id" = $1 AND "hosts"."id" IN ('all', '--...
 |                                                              ^
 | : SELECT "hosts".* FROM "hosts"  WHERE "hosts"."organization_id" IN (1) AND "hosts"."type" IN ('Host::Managed') AND "hosts"."operatingsystem_id" = $1 AND "hosts"."id" IN ('all', '---
 | :order: name
 | ')


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