Are you running 1.4 ? I experienced the same problem, it was solved after upgrading to 1.5.
Martin Fra: [email protected] [mailto:[email protected]] På vegne av Jeremy Davis Sendt: 23. august 2011 17:31 Til: Spacewalk List Emne: [Spacewalk-list] Installed Systems within Package page - 500 Internal Server Error Hello List, I have another issue as well. It seems that when I am within an individual package page and click "Installed Systems" I get a 500 Internal Server Error. Below you will find the traceback logs generated from this error. If anyone has any ideas as to how to resolve this it would be much appreciated. The following exception occurred while executing this request: GET /network/software/packages/system_list.pxt?pid=31040 HTTP/1.1 (from browser) /network/software/packages/system_list.pxt (from Apache) Date: Tue Aug 23 08:25:00 2011 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.3 Accept-Encoding: gzip,deflate,sdch Accept-Language: en-US,en;q=0.8 Connection: keep-alive Cookie: pxt-session-cookie=194278x53700a92f83c93ab6de74fd0855c4710 Host: <FQDN removed> Referer: https://<FQDN<https://%3cFQDN> removed>/rhn/software/packages/Details.do?pid=31040 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari/535.1 Form variables: pid => 31040 User Information: User <user account removed> (id 2, org_id 1) Error notes: (none) Initial Request: Yes Error message: RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00904: "P"."PACKAGE_ARCH_ID": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 144 in ' SELECT SP.server_id AS id FROM rhnServerPackage SP WHERE P.id = :pid AND P.name_id = SP.name_id AND P.evr_id = SP.evr_id AND <*>P.package_arch_id = SP.package_arch_id AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = :user_id AND USP.server_id = SP.server_id) ') [for Statement " SELECT SP.server_id AS id FROM rhnServerPackage SP WHERE P.id = :pid AND P.name_id = SP.name_id AND P.evr_id = SP.evr_id AND P.package_arch_id = SP.package_arch_id AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = :user_id AND USP.server_id = SP.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::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 108 RHN::DB::DataSource::run_query Sniglets::ListView::List /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 1211 RHN::DataSource::execute_query 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 524 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) Thanks, Jeremy This email originates from Steria AS, Biskop Gunnerus' gate 14a, N-0051 OSLO, http://www.steria.no. This email and any attachments may contain confidential/intellectual property/copyright information and is only for the use of the addressee(s). You are prohibited from copying, forwarding, disclosing, saving or otherwise using it in any way if you are not the addressee(s) or responsible for delivery. If you receive this email by mistake, please advise the sender and cancel it immediately. Steria may monitor the content of emails within its network to ensure compliance with its policies and procedures. Any email is susceptible to alteration and its integrity cannot be assured. Steria shall not be liable if the message is altered, modified, falsified, or even edited.
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
