Bug 504670 - Alter channel subscriptions page is broken
Summary: Alter channel subscriptions page is broken
Keywords:
Status: CLOSED DUPLICATE of bug 504652
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: WebUI
Version: 530
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Jay Dobies
QA Contact: Brandon Perkins
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-06-08 18:36 UTC by Jay Dobies
Modified: 2009-06-08 22:17 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-06-08 18:43:24 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jay Dobies 2009-06-08 18:36:01 UTC
Description of problem:
Page throws ISE.

Version-Release number of selected component (if applicable):
Any Spacewalk/Satellite build after 6/1/09

How reproducible:
Always

Steps to Reproduce:
1. Click on the SDC > Alter Channel Subscriptions
  
Actual results:
ISE (detail below)

Expected results:
Alter channel subs page

Additional info:
Looks like it was a result of the schema change 121-rhnReleaseChannelMap.sql. In that change, the rhnReleaseChannelMap is_default column was removed. However, at least one of the queries that the alter channel subscriptions page setup uses (Channel_queries.base_eus_channels_by_version_channel_arch) still references the is_default column, causing an exception reading:

java.sql.SQLException: ORA-00904: "RCM"."IS_DEFAULT": invalid identifier

Comment 1 Jay Dobies 2009-06-08 18:43:24 UTC
The real issue here is that I need to learn how to search bugzilla better. Already filed as 504652.

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


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