<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 12 (filtered medium)"> <style>  </style>  </head> <body bgcolor=white lang=EN-US link=blue vlink=purple> <div class=Section1> Ross,<o:p></o:p> <o:p> </o:p> So looking back at the changes I made the other day, I also added to /etc/rhn/default/rhn_hibernate.conf -- hibernate.show_sql=true. This should show you something like:<o:p></o:p> <o:p> </o:p> Hibernate: select legacyrhnu0_.id as id235_4_, legacyrhnu0_.login as login235_4_, legacyrhnu0_.login_uc as login3_235_4_, legacyrhnu0_.password as password23<o:p></o:p> 5_4_, legacyrhnu0_.created as created235_4_, legacyrhnu0_.modified as modified235_4_, legacyrhnu0_.org_id as org7_235_4_, personalin1_.web_user_id as web1_23<o:p></o:p> 2_0_, personalin1_.prefix as prefix232_0_, personalin1_.first_names as first3_232_0_, personalin1_.last_name as last4_232_0_, personalin1_.company as company<o:p></o:p> 232_0_, personalin1_.title as title232_0_, personalin1_.phone as phone232_0_, personalin1_.fax as fax232_0_, personalin1_.email as email232_0_, personalin1_.<o:p></o:p> created as created232_0_, personalin1_.modified as modified232_0_, orgimpl2_.id as id44_1_, orgimpl2_.name as name44_1_, orgimpl2_.oracle_customer_id as orac<o:p></o:p> le3_44_1_, orgimpl2_.oracle_customer_number as oracle4_44_1_, orgimpl2_.customer_type as customer5_44_1_, orgimpl2_.created as created44_1_, orgimpl2_.credit<o:p></o:p> _application_completed as credit7_44_1_, orgimpl2_.modified as modified44_1_, orgimpl2_1_.reg_token_id as reg2_47_1_, entitlemen3_.org_id as org1_6_, orgenti<o:p></o:p> tle4_.id as entitlem2_6_, orgentitle4_.id as id43_2_, orgentitle4_.label as label43_2_, orgentitle4_.name as name43_2_, orgentitle4_.created as created43_2_,<o:p></o:p> orgentitle4_.modified as modified43_2_, trustedorg5_.org_id as org1_7_, orgimpl6_.id as org2_7_, orgimpl6_.id as id44_3_, orgimpl6_.name as name44_3_, orgim<o:p></o:p> pl6_.oracle_customer_id as oracle3_44_3_, orgimpl6_.oracle_customer_number as oracle4_44_3_, orgimpl6_.customer_type as customer5_44_3_, orgimpl6_.created as<o:p></o:p> created44_3_, orgimpl6_.credit_application_completed as credit7_44_3_, orgimpl6_.modified as modified44_3_, orgimpl6_1_.reg_token_id as reg2_47_3_ from WEB_<o:p></o:p> CONTACT legacyrhnu0_, WEB_USER_PERSONAL_INFO personalin1_, WEB_CUSTOMER orgimpl2_, rhnRegTokenOrgDefault orgimpl2_1_, rhnOrgEntitlements entitlemen3_, RHNORG<o:p></o:p> ENTITLEMENTTYPE orgentitle4_, rhnTrustedOrgs trustedorg5_, WEB_CUSTOMER orgimpl6_, rhnRegTokenOrgDefault orgimpl6_1_ where legacyrhnu0_.id=personalin1_.web_u<o:p></o:p> ser_id and legacyrhnu0_.org_id=orgimpl2_.id and orgimpl2_.id=orgimpl2_1_.org_id(+) and orgimpl2_.id=entitlemen3_.org_id(+) and entitlemen3_.entitlement_id=or<o:p></o:p> gentitle4_.id(+) and orgimpl2_.id=trustedorg5_.org_id(+) and trustedorg5_.org_trust_id=orgimpl6_.id(+) and orgimpl6_.id=orgimpl6_1_.org_id(+) and legacyrhnu0<o:p></o:p> _.id=?<o:p></o:p> 2008-12-15 10:23:14,157 [TP-Processor3] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 942, SQLState: 42000<o:p></o:p> 2008-12-15 10:23:14,157 [TP-Processor3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist<o:p></o:p> <o:p> </o:p> I broke this query down a bit and checked it within Oracle and was able to duplicate the error with: ‘select trustedorg5_.org_id as org1_7_ from rhnTrustedOrgs trustedorg5_;’<o:p></o:p> <o:p> </o:p> From the git repo I saw in schema/spacewalk/upgrade/spacewalk-0.3-spacewalk-0.4 the file 116-rhnTrustedOrgs.sql which creates that table. Unfortunately I haven’t had the chance to get any further with this.<o:p></o:p> Aric<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <div> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'> From: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] On Behalf Of Ross Sent: Friday, December 19, 2008 12:37 PM To: spacewalk-list@redhat.com Subject: RE: [Spacewalk-list] unregister clients or remove pacakges fromchannel<o:p></o:p> </div> </div> <o:p> </o:p> Hi Aric After bumping up the debugging, the error I get:<o:p></o:p> <pre><tt>2008-12-19 12:29:20,665 [TP-Processor3] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.redhat.rhn.common.db.WrappedSQLException</tt><o:p></o:p></pre><pre><tt>2008-12-19 12:29:20,849 [TP-Processor3] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back</tt><o:p></o:p></pre><pre><tt>javax.servlet.ServletException: ORA-00942: table or view does not exist<o:p></o:p></tt></pre><pre><tt><o:p> </o:p></tt></pre> and further down:<o:p></o:p> <pre>Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-00942: table or view does not exist<o:p></o:p></pre><pre><o:p> </o:p></pre> and even further:<o:p></o:p> <pre>2008-12-19 12:29:20,941 [TP-Processor3] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception<o:p></o:p></pre><pre>java.sql.SQLException: ORA-00942: table or view does not exist<o:p></o:p></pre><pre><o:p> </o:p></pre> Version 0.4, is that from SVN? Thanks Ross<o:p></o:p> </div> <PRE> Confidentiality Notice: This e-mail message (including any attached or embedded documents) is intended for the exclusive and confidential use of the individual or entity to which this message is addressed, and unless otherwise expressly indicated, is confidential and privileged information of Rackspace. Any dissemination, distribution or copying of the enclosed material is prohibited. If you receive this transmission in error, please notify us immediately by e-mail at abuse@rackspace.com, and delete the original message. Your cooperation is appreciated. </PRE></body> </html>