Re: [Spacewalk-list] ORA-00904 When Attempting to View Installed Systems Page for Any Package
> >> 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 isn't good. Looks like your isn't in the best shape. Figured out this problem. I was logged into my DB as sys instead of spacewalk. All the appropriate tables are intact. > Correct! > Thanks! Fix will be available in spacewalk nightly (spacewalk-web-1.5.3-1). > > Thank you! > Tomas Thanks for the help. ___ 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. ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] ORA-00904 When Attempting to View Installed Systems Page for Any Package
On 04/29/2011 08:36 AM, Jan Pazdziora wrote: 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 isn't good. Looks like your isn't in the best shape. 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. Tomáš, can you investigate? It looks like 557f4c9b0131e31707a9b51227302d00dc1e1692 caused this. Correct! Thanks! Fix will be available in spacewalk nightly (spacewalk-web-1.5.3-1). Thank you! Tomas -- Tomas Lestach RHN Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] ORA-00904 When Attempting to View Installed Systems Page for Any Package
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 -> -> Packages -> -> 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 ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list