Bug 790475

Summary: headpin cli product list returns PGError: column environments.locker does not exist
Product: [Retired] Subscription Asset Manager Reporter: Eric Sammons <esammons>
Component: katelloAssignee: Bryan Kearney <bkearney>
Status: CLOSED CURRENTRELEASE QA Contact: SAM QE List <sam-qe-list>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 1.0.0CC: tomckay
Target Milestone: rc   
Target Release: 1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
katello-headpin-all-0.1.135-2.el6.noarch
Last Closed: 2012-04-27 00:20:31 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 703617    

Description Eric Sammons 2012-02-14 16:10:31 UTC
Description of problem:
When listing products by command line, headpin, PGError is returned.

<snip>
headpin> product list --org ACME_Corporation
PGError: ERROR:  column environments.locker does not exist
LINE 1: SELECT "environments".* FROM "environments" WHERE "environme...
                                                          ^
: SELECT "environments".* FROM "environments" WHERE "environments"."locker" = 't' AND "environments"."organization_id" = 1
</snip>

Reproducer:

headpin -u [user] -p [password] shell
headpin> product list --org ACME_Corporation

Expected Results:

In this case a error should be returned explaining that an environment option must be passed as ACME_Corporation has multiple environments.

Comment 5 Tom McKay 2012-02-27 14:28:20 UTC
Fixed in HTB#6
katello-headpin-0.1.140-3 or later

Comment 6 Eric Sammons 2012-03-06 20:28:48 UTC
[root@cubert ~]# headpin -u admin -p admin shell
headpin> client remember --option org --value manifestZ3iImD2gCTwNBtv
Successfully remembered option [ org ] 
headpin> product list
------------------------------------------------------------------------------------------------------------------------------------------------
                                  Product List For Organization manifestZ3iImD2gCTwNBtv, Environment 'Library'

 Id          Name                                                                     Provider Id   Provider Name   Sync Plan Name   GPG key  
------------------------------------------------------------------------------------------------------------------------------------------------
 69          Red Hat Enterprise Linux Server                                          4             Red Hat                                   
 RH0103708   Red Hat Enterprise Linux Server Premium 8 sockets Up to 4 guests         4             Red Hat                                   
 RH0197181   Red Hat Enterprise Linux Server Self-support 1-2 sockets Up to 1 guest   4             Red Hat                  

VERIFIED

katello-headpin-all-0.1.141-1.el6.noarch