[Spacewalk-list] rhn-search crashing with java null pointer exception
Kenneth Ratliff
lists at noctum.net
Tue Feb 8 10:02:47 UTC 2011
On Feb 8, 2011, at 4:41 AM, Jan Pazdziora wrote:
> May I assume the ISE you get is different than the ISE I've responded
> to? We are aware of one more issue with creating kickstart profile
> which hits RHEL 5 (but not Fedoras and RHEL 6) and we do not have fix
> for that yet.
I'm not entirely sure, it looked the same to me, but I'll let you be the judge.
I turned on hibernate's SQL printing, so that's getting shown in the catalina.out. What follows is the entirety of the transaction when I hit Finish when creating a kickstart profile (i cleared catalina.out just prior to hitting Finish to make sure it was the only thing in the file).
I also tried running each query individually to see if I could figure out which one was generating the ORA-00942 error, but none of them did, so I'm a little stumped.
Hibernate: select websession0_.id as id232_0_, websession0_.value as value232_0_, websession0_.web_user_id as web3_232_0_, websession0_.expires as expires232_0_ from PXTSessions websession0_ where websession0_.id=?
Hibernate: select userimpl0_.id as id250_4_, userimpl0_.login as login250_4_, userimpl0_.login_uc as login3_250_4_, userimpl0_.password as password250_4_, userimpl0_.created as created250_4_, userimpl0_.modified as modified250_4_, userimpl0_.org_id as org7_250_4_, personalin1_.web_user_id as web1_248_0_, personalin1_.prefix as prefix248_0_, personalin1_.first_names as first3_248_0_, personalin1_.last_name as last4_248_0_, personalin1_.company as company248_0_, personalin1_.title as title248_0_, personalin1_.phone as phone248_0_, personalin1_.fax as fax248_0_, personalin1_.email as email248_0_, personalin1_.created as created248_0_, personalin1_.modified as modified248_0_, org2_.id as id147_1_, org2_.name as name147_1_, org2_.staging_content_enabled as staging3_147_1_, org2_.created as created147_1_, org2_.modified as modified147_1_, org2_1_.reg_token_id as reg2_150_1_, entitlemen3_.org_id as org1_6_, orgentitle4_.id as entitlem2_6_, orgentitle4_.id as id151_2_, orgentitle4_.l
abel as label151_2_, orgentitle4_.name as name151_2_, orgentitle4_.created as created151_2_, orgentitle4_.modified as modified151_2_, trustedorg5_.org_id as org1_7_, org6_.id as org2_7_, org6_.id as id147_3_, org6_.name as name147_3_, org6_.staging_content_enabled as staging3_147_3_, org6_.created as created147_3_, org6_.modified as modified147_3_, org6_1_.reg_token_id as reg2_150_3_ from WEB_CONTACT userimpl0_ inner join WEB_USER_PERSONAL_INFO personalin1_ on userimpl0_.id=personalin1_.web_user_id inner join WEB_CUSTOMER org2_ on userimpl0_.org_id=org2_.id left outer join rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id left outer join rhnOrgEntitlements entitlemen3_ on org2_.id=entitlemen3_.org_id left outer join RHNORGENTITLEMENTTYPE orgentitle4_ on entitlemen3_.entitlement_id=orgentitle4_.id left outer join rhnTrustedOrgs trustedorg5_ on org2_.id=trustedorg5_.org_id left outer join WEB_CUSTOMER org6_ on trustedorg5_.org_trust_id=org6_.id left outer join rhnRegTok
enOrgDefault org6_1_ on org6_.id=org6_1_.org_id where userimpl0_.id=?
Hibernate: select userinfo0_.user_id as user1_254_0_, userinfo0_.page_size as page2_254_0_, userinfo0_.use_pam_authentication as use3_254_0_, userinfo0_.email_notify as email4_254_0_, userinfo0_.show_system_group_list as show5_254_0_, userinfo0_.last_logged_in as last6_254_0_, userinfo0_.created as created254_0_, userinfo0_.modified as modified254_0_, userinfo0_.preferred_locale as preferred9_254_0_, userinfo0_.timezone_id as timezone10_254_0_ from RHNUSERINFO userinfo0_ where userinfo0_.user_id=?
Hibernate: select usergroups0_.user_id as user1_0_, usergroups0_.user_group_id as user2_0_ from rhnUserGroupMembers usergroups0_ where usergroups0_.user_id=?
Hibernate: select usergroupi0_.id as id156_0_, usergroupi0_.name as name156_0_, usergroupi0_.description as descript3_156_0_, usergroupi0_.current_members as current4_156_0_, usergroupi0_.org_id as org5_156_0_, usergroupi0_.created as created156_0_, usergroupi0_.modified as modified156_0_, usergroupi0_.group_type as group8_156_0_ from RHNUSERGROUP usergroupi0_ where usergroupi0_.id=?
Hibernate: select usergroupi0_.id as id156_0_, usergroupi0_.name as name156_0_, usergroupi0_.description as descript3_156_0_, usergroupi0_.current_members as current4_156_0_, usergroupi0_.org_id as org5_156_0_, usergroupi0_.created as created156_0_, usergroupi0_.modified as modified156_0_, usergroupi0_.group_type as group8_156_0_ from RHNUSERGROUP usergroupi0_ where usergroupi0_.id=?
Hibernate: select usergroups0_.org_id as org5_1_, usergroups0_.id as id1_, usergroups0_.id as id156_0_, usergroups0_.name as name156_0_, usergroups0_.description as descript3_156_0_, usergroups0_.current_members as current4_156_0_, usergroups0_.org_id as org5_156_0_, usergroups0_.created as created156_0_, usergroups0_.modified as modified156_0_, usergroups0_.group_type as group8_156_0_ from RHNUSERGROUP usergroups0_ where usergroups0_.org_id=?
Hibernate: select kickstarta0_.id as id113_3_, kickstarta0_.cobbler_id as cobbler2_113_3_, kickstarta0_.cobbler_xen_id as cobbler3_113_3_, kickstarta0_.base_path as base4_113_3_, kickstarta0_.label as label113_3_, kickstarta0_.last_modified as last6_113_3_, kickstarta0_.created as created113_3_, kickstarta0_.modified as modified113_3_, kickstarta0_.org_id as org9_113_3_, kickstarta0_.channel_id as channel10_113_3_, kickstarta0_.install_type as install11_113_3_, kickstarta0_.kstree_type as kstree12_113_3_, org1_.id as id147_0_, org1_.name as name147_0_, org1_.staging_content_enabled as staging3_147_0_, org1_.created as created147_0_, org1_.modified as modified147_0_, org1_1_.reg_token_id as reg2_150_0_, entitlemen2_.org_id as org1_5_, orgentitle3_.id as entitlem2_5_, orgentitle3_.id as id151_1_, orgentitle3_.label as label151_1_, orgentitle3_.name as name151_1_, orgentitle3_.created as created151_1_, orgentitle3_.modified as modified151_1_, trustedorg4_.org_id as org1_6_, org5
_.id as org2_6_, org5_.id as id147_2_, org5_.name as name147_2_, org5_.staging_content_enabled as staging3_147_2_, org5_.created as created147_2_, org5_.modified as modified147_2_, org5_1_.reg_token_id as reg2_150_2_ from rhnKickstartableTree kickstarta0_ left outer join WEB_CUSTOMER org1_ on kickstarta0_.org_id=org1_.id left outer join rhnRegTokenOrgDefault org1_1_ on org1_.id=org1_1_.org_id left outer join rhnOrgEntitlements entitlemen2_ on org1_.id=entitlemen2_.org_id left outer join RHNORGENTITLEMENTTYPE orgentitle3_ on entitlemen2_.entitlement_id=orgentitle3_.id left outer join rhnTrustedOrgs trustedorg4_ on org1_.id=trustedorg4_.org_id left outer join WEB_CUSTOMER org5_ on trustedorg4_.org_trust_id=org5_.id left outer join rhnRegTokenOrgDefault org5_1_ on org5_.id=org5_1_.org_id where kickstarta0_.id=?
Hibernate: select kickstartd0_.id as id95_, kickstartd0_.org_id as org3_95_, kickstartd0_.label as label95_, kickstartd0_.ks_type as ks2_95_, kickstartd0_.comments as comments95_, kickstartd0_.active as active95_, kickstartd0_.postLog as postLog95_, kickstartd0_.preLog as preLog95_, kickstartd0_.kscfg as kscfg95_, kickstartd0_.created as created95_, kickstartd0_.modified as modified95_, kickstartd0_.is_org_default as is12_95_, kickstartd0_.kernel_params as kernel13_95_, kickstartd0_.nonchrootpost as nonchro14_95_, kickstartd0_.no_base as no15_95_, kickstartd0_.ignore_missing as ignore16_95_, kickstartd0_.verboseup2date as verboseup17_95_, kickstartd0_.partition_data as partition18_95_, kickstartd0_.cobbler_id as cobbler19_95_ from RHNKSDATA kickstartd0_ where kickstartd0_.label=? and kickstartd0_.org_id=?
Hibernate: select kickstartv0_.id as id112_, kickstartv0_.label as label112_, kickstartv0_.name as name112_, kickstartv0_.created as created112_, kickstartv0_.modified as modified112_ from rhnKickstartVirtualizationType kickstartv0_ where kickstartv0_.label=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select channel0_.id as id35_1_, channel0_.basedir as basedir35_1_, channel0_.description as descript3_35_1_, channel0_.end_of_life as end4_35_1_, channel0_.gpg_key_url as gpg5_35_1_, channel0_.gpg_key_id as gpg6_35_1_, channel0_.gpg_key_fp as gpg7_35_1_, channel0_.label as label35_1_, channel0_.last_modified as last9_35_1_, channel0_.name as name35_1_, channel0_.summary as summary35_1_, channel0_.channel_access as channel12_35_1_, channel0_.maint_name as maint13_35_1_, channel0_.maint_email as maint14_35_1_, channel0_.maint_phone as maint15_35_1_, channel0_.support_policy as support16_35_1_, channel0_.last_synced as last17_35_1_, channel0_.created as created35_1_, channel0_.modified as modified35_1_, channel0_.org_id as org20_35_1_, channel0_.channel_arch_id as channel21_35_1_, channel0_.checksum_type_id as checksum22_35_1_, channel0_.parent_channel as parent23_35_1_, channel0_.channel_product_id as channel24_35_1_, channel0_.product_name_id as product25_35_1_, cha
nnel0_1_.original_id as original2_41_1_, case when channel0_1_.id is not null then 1 when channel0_.id is not null then 0 end as clazz_1_, comps1_.id as id48_0_, comps1_.relative_filename as relative2_48_0_, comps1_.channel_id as channel3_48_0_ from rhnChannel channel0_ left outer join rhnChannelCloned channel0_1_ on channel0_.id=channel0_1_.id left outer join rhnChannelComps comps1_ on channel0_.id=comps1_.channel_id where channel0_.id=?
Hibernate: select channelfam0_.channel_id as channel1_1_, channelfam0_.channel_family_id as channel2_1_, channelfam1_.id as id45_0_, channelfam1_.name as name45_0_, channelfam1_.label as label45_0_, channelfam1_.product_url as product4_45_0_, channelfam1_.created as created45_0_, channelfam1_.modified as modified45_0_, channelfam1_.org_id as org7_45_0_ from rhnChannelFamilyMembers channelfam0_ left outer join rhnChannelFamily channelfam1_ on channelfam0_.channel_family_id=channelfam1_.id where channelfam0_.channel_id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select kickstartc0_.id as id94_0_, kickstartc0_.name as name94_0_, kickstartc0_.uses_arguments as uses3_94_0_, kickstartc0_.sort_order as sort4_94_0_, kickstartc0_.required as required94_0_ from rhnKickstartCommandName kickstartc0_ where kickstartc0_.id=?
Hibernate: select cryptokey0_.id as id114_, cryptokey0_.description as descript2_114_, cryptokey0_.key as key114_, cryptokey0_.org_id as org4_114_, cryptokey0_.crypto_key_type_id as crypto5_114_ from rhnCryptoKey cryptokey0_ where cryptokey0_.org_id=?
Hibernate: select cryptokeyt0_.id as id115_0_, cryptokeyt0_.label as label115_0_, cryptokeyt0_.description as descript3_115_0_, cryptokeyt0_.created as created115_0_, cryptokeyt0_.modified as modified115_0_ from rhnCryptoKeyType cryptokeyt0_ where cryptokeyt0_.id=?
Hibernate: select RHN_KS_SESSION_ID_SEQ.nextval from dual
Hibernate: select RHN_KS_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: select RHN_KSCOMMAND_ID_SEQ.nextval from dual
Hibernate: SELECT ugm.user_id as user_id
FROM rhnUserGroupMembers ugm, web_contact wc
WHERE ugm.user_group_id = (SELECT id
FROM rhnUserGroup
WHERE org_id = ?
AND group_type = ?)
AND wc.id = ugm.user_id
ORDER BY wc.id
Hibernate: SELECT c.id as id35_0_, c.basedir as basedir35_0_, c.description as descript3_35_0_, c.end_of_life as end4_35_0_, c.gpg_key_url as gpg5_35_0_, c.gpg_key_id as gpg6_35_0_, c.gpg_key_fp as gpg7_35_0_, c.label as label35_0_, c.last_modified as last9_35_0_, c.name as name35_0_, c.summary as summary35_0_, c.channel_access as channel12_35_0_, c.maint_name as maint13_35_0_, c.maint_email as maint14_35_0_, c.maint_phone as maint15_35_0_, c.support_policy as support16_35_0_, c.last_synced as last17_35_0_, c.created as created35_0_, c.modified as modified35_0_, c.org_id as org20_35_0_, c.channel_arch_id as channel21_35_0_, c.checksum_type_id as checksum22_35_0_, c.parent_channel as parent23_35_0_, c.channel_product_id as channel24_35_0_, c.product_name_id as product25_35_0_, c_1_.original_id as original2_41_0_, case when c_1_.id is not null then 1 when c.id is not null then 0 end as clazz_0_
FROM rhnChannel c
LEFT OUTER JOIN rhnChannelCloned c_1_ ON c.id = c_1_.id
WHERE parent_channel = ?
AND rhn_channel.get_org_access(c.id, ?) = 1
UNION
SELECT c.id as id35_0_, c.basedir as basedir35_0_, c.description as descript3_35_0_, c.end_of_life as end4_35_0_, c.gpg_key_url as gpg5_35_0_, c.gpg_key_id as gpg6_35_0_, c.gpg_key_fp as gpg7_35_0_, c.label as label35_0_, c.last_modified as last9_35_0_, c.name as name35_0_, c.summary as summary35_0_, c.channel_access as channel12_35_0_, c.maint_name as maint13_35_0_, c.maint_email as maint14_35_0_, c.maint_phone as maint15_35_0_, c.support_policy as support16_35_0_, c.last_synced as last17_35_0_, c.created as created35_0_, c.modified as modified35_0_, c.org_id as org20_35_0_, c.channel_arch_id as channel21_35_0_, c.checksum_type_id as checksum22_35_0_, c.parent_channel as parent23_35_0_, c.channel_product_id as channel24_35_0_, c.product_name_id as product25_35_0_, c_1_.original_id as original2_41_0_, case when c_1_.id is not null then 1 when c.id is not null then 0 end as clazz_0_
FROM rhnChannel c,
rhnSharedChannelView sc,
LEFT OUTER JOIN rhnChannelCloned c_1_ ON c.id = c_1_.id
WHERE sc.parent_channel = ?
AND sc.org_trust_id = ?
AND sc.id = c.id
2011-02-07 23:23:36,781 [TP-Processor7] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 942, SQLState: 42000
2011-02-07 23:23:36,781 [TP-Processor7] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist
2011-02-07 23:23:36,781 [TP-Processor7] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class java.lang.reflect.InvocationTargetException
2011-02-07 23:23:36,782 [TP-Processor7] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException
at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:636)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at com.redhat.rhn.frontend.struts.wizard.WizardStep.invoke(WizardStep.java:116)
at com.redhat.rhn.frontend.struts.wizard.RhnWizardAction.dispatch(RhnWizardAction.java:103)
at com.redhat.rhn.frontend.struts.wizard.RhnWizardAction.execute(RhnWizardAction.java:89)
at com.redhat.rhn.frontend.action.kickstart.CreateProfileWizardAction.execute(CreateProfileWizardAction.java:104)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
... 40 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at com.redhat.rhn.common.hibernate.HibernateFactory.listObjectsByNamedQuery(HibernateFactory.java:265)
at com.redhat.rhn.common.hibernate.HibernateFactory.listObjectsByNamedQuery(HibernateFactory.java:206)
at com.redhat.rhn.domain.channel.ChannelFactory.getUserAcessibleChannels(ChannelFactory.java:327)
at com.redhat.rhn.manager.channel.ChannelManager.userAccessibleChildChannels(ChannelManager.java:763)
at com.redhat.rhn.manager.channel.ChannelManager.getToolsChannel(ChannelManager.java:1834)
at com.redhat.rhn.manager.kickstart.KickstartScheduleCommand.getToolsChannel(KickstartScheduleCommand.java:1041)
at com.redhat.rhn.manager.kickstart.KickstartSessionCreateCommand.<init>(KickstartSessionCreateCommand.java:94)
at com.redhat.rhn.manager.kickstart.KickstartSessionCreateCommand.<init>(KickstartSessionCreateCommand.java:53)
at com.redhat.rhn.manager.kickstart.KickstartWizardHelper.store(KickstartWizardHelper.java:181)
at com.redhat.rhn.domain.kickstart.builder.KickstartBuilder.create(KickstartBuilder.java:545)
at com.redhat.rhn.frontend.action.kickstart.CreateProfileWizardAction.runComplete(CreateProfileWizardAction.java:288)
... 49 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 66 more
2011-02-07 23:23:36,790 [TP-Processor7] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at com.redhat.rhn.common.hibernate.HibernateFactory.listObjectsByNamedQuery(HibernateFactory.java:265)
at com.redhat.rhn.common.hibernate.HibernateFactory.listObjectsByNamedQuery(HibernateFactory.java:206)
at com.redhat.rhn.domain.channel.ChannelFactory.getUserAcessibleChannels(ChannelFactory.java:327)
at com.redhat.rhn.manager.channel.ChannelManager.userAccessibleChildChannels(ChannelManager.java:763)
at com.redhat.rhn.manager.channel.ChannelManager.getToolsChannel(ChannelManager.java:1834)
at com.redhat.rhn.manager.kickstart.KickstartScheduleCommand.getToolsChannel(KickstartScheduleCommand.java:1041)
at com.redhat.rhn.manager.kickstart.KickstartSessionCreateCommand.<init>(KickstartSessionCreateCommand.java:94)
at com.redhat.rhn.manager.kickstart.KickstartSessionCreateCommand.<init>(KickstartSessionCreateCommand.java:53)
at com.redhat.rhn.manager.kickstart.KickstartWizardHelper.store(KickstartWizardHelper.java:181)
at com.redhat.rhn.domain.kickstart.builder.KickstartBuilder.create(KickstartBuilder.java:545)
at com.redhat.rhn.frontend.action.kickstart.CreateProfileWizardAction.runComplete(CreateProfileWizardAction.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at com.redhat.rhn.frontend.struts.wizard.WizardStep.invoke(WizardStep.java:116)
at com.redhat.rhn.frontend.struts.wizard.RhnWizardAction.dispatch(RhnWizardAction.java:103)
at com.redhat.rhn.frontend.struts.wizard.RhnWizardAction.execute(RhnWizardAction.java:89)
at com.redhat.rhn.frontend.action.kickstart.CreateProfileWizardAction.execute(CreateProfileWizardAction.java:104)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:636)
Hibernate: select userimpl0_.id as id250_4_, userimpl0_.login as login250_4_, userimpl0_.login_uc as login3_250_4_, userimpl0_.password as password250_4_, userimpl0_.created as created250_4_, userimpl0_.modified as modified250_4_, userimpl0_.org_id as org7_250_4_, personalin1_.web_user_id as web1_248_0_, personalin1_.prefix as prefix248_0_, personalin1_.first_names as first3_248_0_, personalin1_.last_name as last4_248_0_, personalin1_.company as company248_0_, personalin1_.title as title248_0_, personalin1_.phone as phone248_0_, personalin1_.fax as fax248_0_, personalin1_.email as email248_0_, personalin1_.created as created248_0_, personalin1_.modified as modified248_0_, org2_.id as id147_1_, org2_.name as name147_1_, org2_.staging_content_enabled as staging3_147_1_, org2_.created as created147_1_, org2_.modified as modified147_1_, org2_1_.reg_token_id as reg2_150_1_, entitlemen3_.org_id as org1_6_, orgentitle4_.id as entitlem2_6_, orgentitle4_.id as id151_2_, orgentitle4_.l
abel as label151_2_, orgentitle4_.name as name151_2_, orgentitle4_.created as created151_2_, orgentitle4_.modified as modified151_2_, trustedorg5_.org_id as org1_7_, org6_.id as org2_7_, org6_.id as id147_3_, org6_.name as name147_3_, org6_.staging_content_enabled as staging3_147_3_, org6_.created as created147_3_, org6_.modified as modified147_3_, org6_1_.reg_token_id as reg2_150_3_ from WEB_CONTACT userimpl0_ inner join WEB_USER_PERSONAL_INFO personalin1_ on userimpl0_.id=personalin1_.web_user_id inner join WEB_CUSTOMER org2_ on userimpl0_.org_id=org2_.id left outer join rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id left outer join rhnOrgEntitlements entitlemen3_ on org2_.id=entitlemen3_.org_id left outer join RHNORGENTITLEMENTTYPE orgentitle4_ on entitlemen3_.entitlement_id=orgentitle4_.id left outer join rhnTrustedOrgs trustedorg5_ on org2_.id=trustedorg5_.org_id left outer join WEB_CUSTOMER org6_ on trustedorg5_.org_trust_id=org6_.id left outer join rhnRegTok
enOrgDefault org6_1_ on org6_.id=org6_1_.org_id where userimpl0_.id=?
Hibernate: select userinfo0_.user_id as user1_254_0_, userinfo0_.page_size as page2_254_0_, userinfo0_.use_pam_authentication as use3_254_0_, userinfo0_.email_notify as email4_254_0_, userinfo0_.show_system_group_list as show5_254_0_, userinfo0_.last_logged_in as last6_254_0_, userinfo0_.created as created254_0_, userinfo0_.modified as modified254_0_, userinfo0_.preferred_locale as preferred9_254_0_, userinfo0_.timezone_id as timezone10_254_0_ from RHNUSERINFO userinfo0_ where userinfo0_.user_id=?
Hibernate: select usergroups0_.user_id as user1_0_, usergroups0_.user_group_id as user2_0_ from rhnUserGroupMembers usergroups0_ where usergroups0_.user_id=?
Hibernate: select usergroupi0_.id as id156_0_, usergroupi0_.name as name156_0_, usergroupi0_.description as descript3_156_0_, usergroupi0_.current_members as current4_156_0_, usergroupi0_.org_id as org5_156_0_, usergroupi0_.created as created156_0_, usergroupi0_.modified as modified156_0_, usergroupi0_.group_type as group8_156_0_ from RHNUSERGROUP usergroupi0_ where usergroupi0_.id=?
Hibernate: select usergroupi0_.id as id156_0_, usergroupi0_.name as name156_0_, usergroupi0_.description as descript3_156_0_, usergroupi0_.current_members as current4_156_0_, usergroupi0_.org_id as org5_156_0_, usergroupi0_.created as created156_0_, usergroupi0_.modified as modified156_0_, usergroupi0_.group_type as group8_156_0_ from RHNUSERGROUP usergroupi0_ where usergroupi0_.id=?
Hibernate: select usergroups0_.org_id as org5_1_, usergroups0_.id as id1_, usergroups0_.id as id156_0_, usergroups0_.name as name156_0_, usergroups0_.description as descript3_156_0_, usergroups0_.current_members as current4_156_0_, usergroups0_.org_id as org5_156_0_, usergroups0_.created as created156_0_, usergroups0_.modified as modified156_0_, usergroups0_.group_type as group8_156_0_ from RHNUSERGROUP usergroups0_ where usergroups0_.org_id=?
Hibernate: select websession0_.id as id232_0_, websession0_.value as value232_0_, websession0_.web_user_id as web3_232_0_, websession0_.expires as expires232_0_ from PXTSessions websession0_ where websession0_.id=?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110208/884f1723/attachment.htm>
More information about the Spacewalk-list
mailing list