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

[Jan Pazdziora]

On Thu, Apr 28, 2011 at 01:38:36PM -0400, Trevor T Kates wrote:
> 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)

[...]

> > 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)

Tomáš,

can you investigate? It looks like

	557f4c9b0131e31707a9b51227302d00dc1e1692

caused this.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat