[Spacewalk-list] traceback while trying to edit kickstart profile

[Marcus Moeller]

Hi all.

After upgrade to 1.3 I got the following traceback while trying to edit 
or create a kickstart profile:

Exception:
javax.servlet.ServletException: could not execute query
	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.doGet(ActionServlet.java:414)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	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: 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.frontend.action.kickstart.KickstartHelper.hasKickstartPackage(KickstartHelper.java:454) 

	at 
com.redhat.rhn.frontend.action.kickstart.KickstartHelper.verifyKickstartChannel(KickstartHelper.java:397) 

	at 
com.redhat.rhn.frontend.action.kickstart.KickstartHelper.verifyKickstartChannel(KickstartHelper.java:369) 

	at 
com.redhat.rhn.frontend.action.kickstart.BaseKickstartEditAction.execute(BaseKickstartEditAction.java:72) 

	at 
com.redhat.rhn.frontend.action.kickstart.KickstartDetailsEditAction.execute(KickstartDetailsEditAction.java:96) 

	at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) 

	... 40 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)
	... 56 more

Kind Regards
Marcus