[Spacewalk-list] Installed Systems within Package page - 500 Internal Server Error

[Martin Eggen]

Are you running 1.4 ? I experienced the same problem, it was solved after upgrading to 1.5.

Martin

Fra: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110823/83834f4a/attachment.htm>