[Spacewalk-list] unregister clients or remove pacakges fromchannel

[Aric Morgan]

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: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Ross
Sent: Friday, December 19, 2008 12:37 PM
To: spacewalk-list at redhat.com
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 abuse at rackspace.com, and delete the original message.
Your cooperation is appreciated.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20081219/4c32ff68/attachment.htm>