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

[Jeremy Davis]

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 <mare at steria.no> wrote:

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



-- 
Kind regards,
Jeremy Davis, GCIH
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110823/cb736cfc/attachment.htm>