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

[Jeremy Davis]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110823/9e914119/attachment.htm>