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 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
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list