Red Hat Bugzilla – Bug 504670
Alter channel subscriptions page is broken
Last modified: 2009-06-08 18:17:40 EDT
Description of problem:
Page throws ISE.
Version-Release number of selected component (if applicable):
Any Spacewalk/Satellite build after 6/1/09
Steps to Reproduce:
1. Click on the SDC > Alter Channel Subscriptions
ISE (detail below)
Alter channel subs page
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
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 ***