Ross,
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: Hibernate: select legacyrhnu0_.id as id235_4_, legacyrhnu0_.login as login235_4_, legacyrhnu0_.login_uc as login3_235_4_, legacyrhnu0_.password as password23 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 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 232_0_, personalin1_.title as title232_0_, personalin1_.phone as phone232_0_, personalin1_.fax as fax232_0_, personalin1_.email as email232_0_, personalin1_. 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 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 _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 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_, 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 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 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_ CONTACT legacyrhnu0_, WEB_USER_PERSONAL_INFO personalin1_, WEB_CUSTOMER orgimpl2_, rhnRegTokenOrgDefault orgimpl2_1_, rhnOrgEntitlements entitlemen3_, RHNORG ENTITLEMENTTYPE orgentitle4_, rhnTrustedOrgs trustedorg5_, WEB_CUSTOMER orgimpl6_, rhnRegTokenOrgDefault orgimpl6_1_ where legacyrhnu0_.id=personalin1_.web_u 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 gentitle4_.id(+) and orgimpl2_.id=trustedorg5_.org_id(+) and trustedorg5_.org_trust_id=orgimpl6_.id(+) and orgimpl6_.id=orgimpl6_1_.org_id(+) and legacyrhnu0 _.id=? 2008-12-15 10:23:14,157 [TP-Processor3] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 942, SQLState: 42000 2008-12-15 10:23:14,157 [TP-Processor3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist 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_;' >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. Aric From: [email protected] [mailto:[email protected]] On Behalf Of Ross Sent: Friday, December 19, 2008 12:37 PM To: [email protected] Subject: RE: [Spacewalk-list] unregister clients or remove pacakges fromchannel Hi Aric After bumping up the debugging, the error I get: 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 2008-12-19 12:29:20,849 [TP-Processor3] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back javax.servlet.ServletException: ORA-00942: table or view does not exist and further down: Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-00942: table or view does not exist and even further: 2008-12-19 12:29:20,941 [TP-Processor3] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[ac tion] - Servlet.service() for servlet action threw exception java.sql.SQLException: ORA-00942: table or view does not exist Version 0.4, is that from SVN? Thanks Ross 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 [email protected], and delete the original message. Your cooperation is appreciated.
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
