Bug 660606

Description of problem:

Can not access "Installed Systems" or "Target Systems" tabs in a Package Details View.

500 Error - Internal Server Error.

Version-Release number of selected component (if applicable):

Spacewalk 1.2 on CentOS 5.5.

How reproducible:


Steps to Reproduce:

1. Push new signed package into repo (rhnpush);
2. Search for this package and click on the pkg name;
3. Click on "Installed Systems" or "Target Systems" tabs.
  
Actual results:

500 Error - Internal Server Error

Expected results:

List view: Installed Systems or Target Systems

Additional info:


The following exception occurred while executing this request:
GET /network/software/packages/target_system_list.pxt?pid=16599 HTTP/1.1 (from browser)
/network/software/packages/target_system_list.pxt (from Apache)

Date:
 Tue Dec  7 10:53:43 2010

Headers:
 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
 Accept-Encoding: gzip,deflate
 Accept-Language: en-us,en;q=0.5
 Connection: keep-alive
 Cookie: pxt-session-cookie=114456x6099f8b68ee6e389f58acd545ead1ede
 Host: spacewalk.example.com
 Keep-Alive: 115
 Referer: https://spacewalk.example.com/rhn/software/packages/Details.do?pid=16599
 User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12

Form variables:
 pid => 16599

User Information:
 User admin (id 5, org_id 1)

Error notes:
 (none)

Initial Request:
 Yes

Error message:
 RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00904: "OV"."SERVER_ID": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 704 in '
 SELECT  SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA, OUTDATED_PACKAGES, SERVER_NAME,
         SERVER_ADMINS, GROUP_COUNT, NOTE_COUNT, MODIFIED, CHANNEL_LABELS, CHANNEL_ID, HISTORY_COUNT,
         LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE, SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
      ( SELECT  CASE
                  MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN 2 WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN 5 END)
                        WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 3 THEN 'UNKNOWN' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
        FROM  rhn_probe_state PS
        LEFT OUTER JOIN rhn_check_probe CP ON <*>OV.server_id = CP.host_id
         WHERE  PS.probe_id = CP.probe_id
        GROUP BY OV.server_id ) MONITORING_STATUS,
      COALESCE((SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id = OV.server_id AND SFV.label = 'ftr_system_grouping'), 0) AS SELECTABLE
   FROM  rhnServerOverview OV
  WHERE  server_id IN (:p2, :p5, :p3, :p1, :p0, :p4)
ORDER BY  UPPER(NVL(SERVER_NAME, '(none)')), SERVER_ID
') [for Statement "
 SELECT  SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA, OUTDATED_PACKAGES, SERVER_NAME,
         SERVER_ADMINS, GROUP_COUNT, NOTE_COUNT, MODIFIED, CHANNEL_LABELS, CHANNEL_ID, HISTORY_COUNT,
         LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE, SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
      ( SELECT  CASE
                  MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN 2 WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN 5 END)
                        WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 3 THEN 'UNKNOWN' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
        FROM  rhn_probe_state PS
        LEFT OUTER JOIN rhn_check_probe CP ON OV.server_id = CP.host_id
         WHERE  PS.probe_id = CP.probe_id
        GROUP BY OV.server_id ) MONITORING_STATUS,
      COALESCE((SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id = OV.server_id AND SFV.label = 'ftr_system_grouping'), 0) AS SELECTABLE
   FROM  rhnServerOverview OV
  WHERE  server_id IN (:p2, :p5, :p3, :p1, :p0, :p4)
ORDER BY  UPPER(NVL(SERVER_NAME, '(none)')), SERVER_ID
"]
 RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw
 RHN::DB::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 73 RHN::DB::handle_error
 RHN::DB::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 52 RHN::DB::DataSource::run_query
 RHN::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 144 RHN::DB::DataSource::run_complex_query
 Sniglets::ListView::List /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 1220 RHN::DataSource::elaborate
 Sniglets::ListView::List /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 908 Sniglets::ListView::List::default_provider
 Sniglets::Lists /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Lists.pm 119 Sniglets::ListView::List::render
 PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160 Sniglets::Lists::listview
 PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 72 PXT::Parser::expand_tag
 PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 522 PXT::Parser::expand_tags
 PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117 PXT::ApacheHandler::pxt_parse_data
 PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117 (eval)
 main -e 0 PXT::ApacheHandler::handler
 main -e 0 (eval)