Bug 789324

Summary: 'headpin product list' ends up with error 'column environments.locker does not exist'
Product: [Retired] Subscription Asset Manager Reporter: Jakub Dorňák <jdornak>
Component: katelloAssignee: Tom McKay <tomckay>
Status: CLOSED CURRENTRELEASE QA Contact: SAM QE List <sam-qe-list>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 1.0.0CC: hhorak, tomckay
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-04-27 00:20:37 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Jakub Dorňák 2012-02-10 12:32:31 UTC
Description of problem:
'headpin product list' ends up with error 'column environments.locker does not exist'


Version-Release number of selected component (if applicable):
katello-cli-headpin-0.1.15-2.el6.noarch


How reproducible:
after default installation using command:
# headpin --username admin --password admin product list --org 'Red Hat'


Actual results:
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" = 2


Expected results:
list of products


Additional info:

Comment 2 Tom McKay 2012-03-06 16:05:32 UTC
This is fixed in Subscription Asset Manager Version: 0.1.141-1.el6 (perhaps earlier versions too).

Comment 3 Eric Sammons 2012-03-06 20:31:14 UTC
# headpin --username admin --password admin product list --org manifestZ3iImD2gCTwNBtv
------------------------------------------------------------------------------------------------------------------------------------------------
                                  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