Bug 790475 - headpin cli product list returns PGError: column environments.locker does not exist
Summary: headpin cli product list returns PGError: column environments.locker does not...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Subscription Asset Manager
Classification: Retired
Component: katello
Version: 1.0.0
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: rc
: 1.0
Assignee: Bryan Kearney
QA Contact: SAM QE List
URL:
Whiteboard:
Depends On:
Blocks: 703617
TreeView+ depends on / blocked
 
Reported: 2012-02-14 16:10 UTC by Eric Sammons
Modified: 2012-04-27 00:20 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
katello-headpin-all-0.1.135-2.el6.noarch
Last Closed: 2012-04-27 00:20:31 UTC
Embargoed:


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.