[Spacewalk-list] ORA-00904 When Attempting to View Installed Systems Page for Any Package

[Trevor T Kates]

List:

SW Ver: 1.4
OS Ver: CentOS 5.6
DB Backend: Oracle XE 10g

When attempting to view a package's list of installed systems, the following
traceback is generated. I've checked through my oracle DB for the rhnServerPackage
table and it doesn't exist. This error occurs regardless of whether the package is
installed on a system or not. If more information is needed on this issue, please
let me know.

Steps to reproduce error:

Navigate to Channels -> <channel> -> Packages -> <package> -> Installed Systems
500 Error - ISE results

Thank you again.

> The following exception occurred while executing this request:
>  GET /network/software/packages/system_list.pxt?pid=2725 HTTP/1.1 (from browser)
>  /network/software/packages/system_list.pxt (from Apache)
> 
> Date:
>   Thu Apr 28 13:18:48 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.7
>   Accept-Encoding: gzip,deflate
>   Accept-Language: en-us,en;q=0.5
>   Connection: keep-alive
>   Cookie: pxt-session-cookie=18292xf9d45b654311fb882277c74c005be183
>   Host: spacewalk.example.com
>   Keep-Alive: 115
>   Referer:
> https://spacewalk.example.com/rhn/software/packages/Details.do?pid=2725
>   User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13)
> Gecko/20101209 CentOS/3.6-2.el5.centos Firefox/3.6.13
> 
> Form variables:
>   pid => 2725
> 
> User Information:
>   User userID (id 1, 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)

_______________________________________________________________________________
Trevor T. Kates

CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.