Bug 1368408

Summary: traceback when running hammer role filters
Product: Red Hat Satellite Reporter: Peter Ondrejka <pondrejk>
Component: HammerAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.2.0CC: bbuckingham, bkearney, jcallaha, rankumar
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: 2016-08-23 11:43:43 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:

Description Peter Ondrejka 2016-08-19 10:08:35 UTC
Description of problem:

Running:

hammer role filters

returns:

PG::Error: ERROR:  invalid input syntax for integer: ""
LINE 1: ..."id" = "filters"."role_id" WHERE (("roles"."id" = ''))  ORDE...
                                                             ^
: SELECT  "filters"."id" AS t0_r0, "filters"."search" AS t0_r1, "filters"."role_id" AS t0_r2, "filters"."created_at" AS t0_r3, "filters"."updated_at" AS t0_r4, "filters"."taxonomy_search" AS t0_r5, "roles"."id" AS t1_r0, "roles"."name" AS t1_r1, "roles"."builtin" AS t1_r2, "roles"."permissions" AS t1_r3 FROM "filters" LEFT OUTER JOIN "roles" ON "roles"."id" = "filters"."role_id" WHERE (("roles"."id" = ''))  ORDER BY filters.role_id, filters.id LIMIT 20 OFFSET 0


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

satellite-6.2.1-1.3.el7sat.noarch

Expected results:

A user-friendly message about missing --id or --name parameter

Comment 3 Bryan Kearney 2016-08-20 16:17:40 UTC
Moving to POST since upstream bug http://projects.theforeman.org/issues/13064 has been closed

Comment 4 Bryan Kearney 2016-08-23 11:43:43 UTC

*** This bug has been marked as a duplicate of bug 1296782 ***