Bug 832107 - ISE When Trying to Convert Guest to Flex Entitlement With No Free Flex Entitlements
Summary: ISE When Trying to Convert Guest to Flex Entitlement With No Free Flex Entitl...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 550
Hardware: Unspecified
OS: Unspecified
medium
high
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Martin Minar
URL:
Whiteboard:
Depends On:
Blocks: sat550-blockers
TreeView+ depends on / blocked
 
Reported: 2012-06-14 14:16 UTC by Martin Minar
Modified: 2016-07-04 00:57 UTC (History)
5 users (show)

Fixed In Version: spacewalk-java-1.7.54-70
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-09-21 09:20:49 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Martin Minar 2012-06-14 14:16:41 UTC
Description of problem:
When there are no free flex entitlement for channel and I try to use "Convert to Flex" Button with guest machine I will get ISE.

Version-Release number of selected component (if applicable):
spacewalk-java-1.7.54-58.el6sat.noarch
Satellite-5.5.0-RHEL6-re20120607.0-x86_64.iso

How reproducible:
Always

Steps to Reproduce:
1. Have Satellite with no Flex Entitlements
2. Register virtual guest - guest will be registered as regular
3. Go to Overview > Virtualization Entitlement > Guest Consuming Regular Entitlement
4. Select guest and click "Convert To Flex Guest Entitlement"
  
Actual results:
ISE

Expected results:
Error message stating there is not enough flex entitlements.

Additional info:
Log from PostgreSQL:
2012-06-14 16:06:43.537 CESTERROR:  -20296 : (not_enough_flex_entitlements) - You do not have enough entitlements in your org..
2012-06-14 16:06:43.537 CESTCONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception('not_enough_flex_entitlements')"
	PL/pgSQL function "convert_to_fve" line 47 at PERFORM
2012-06-14 16:06:43.537 CESTSTATEMENT:  select * from rhn_channel.convert_to_fve($1, $2)  as result
2012-06-14 16:06:43.537 CESTERROR:  current transaction is aborted, commands ignored until end of transaction block
2012-06-14 16:06:43.537 CESTSTATEMENT:  SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT'  AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME 
2012-06-14 16:06:43.539 CESTERROR:  current transaction is aborted, commands ignored until end of transaction block
2012-06-14 16:06:43.539 CESTSTATEMENT:  select this_.id as id57_0_, this_.label as label57_0_, this_.message as message57_0_ from rhnException this_ where (this_.id=$1 or this_.id=$2)
2012-06-14 16:06:43.539 CESTERROR:  current transaction is aborted, commands ignored until end of transaction block
2012-06-14 16:06:43.539 CESTSTATEMENT:  SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT'  AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME

Comment 1 Tomas Lestach 2012-06-19 09:07:44 UTC
Was this a machine with postgresql DB?

Comment 2 Jan Pazdziora 2012-06-21 13:00:13 UTC
(In reply to comment #1)
> Was this a machine with postgresql DB?

The log from comment 0 suggests so. ;-)

Comment 4 Jan Pazdziora 2012-06-25 15:27:13 UTC
The internal server error was fixed via bug 822918.

Comment 8 Clifford Perry 2012-09-21 09:20:49 UTC
This issue is resolved with the release of RHN Satellite 5.5. 

As of September 20th 2012, RHN Satellite 5.5 has been generally available. 

Release Notes and other 5.5 documentation can be found here:

 https://access.redhat.com/knowledge/docs/Red_Hat_Network_Satellite/

The associated Errata for the 5.5 release are:

5.5 Satellite GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1296.html

5.5 Upgrade Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1298.html

5.5 RHN Proxy GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1297.html

5.5 RHN Tools GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1299.html

Regards,
Clifford
- Engineering Manager, Satellite


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