Yes, I am sorry I forgot to put that I am running 1.4. Thanks for the update on this issue. Do you by chance have the code that resolved it? I am not sure I will be able to upgrade to 1.5 for a few months.
On Tue, Aug 23, 2011 at 9:39 AM, Martin Eggen <[email protected]> wrote: > 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 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 > -- Kind regards, Jeremy Davis, GCIH
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
