Team,

I'm running into an error trying to delete a few "kickstartable distributions" 
... here's the trace... looks like I've another inconsistency in my database.  
Has anyone seen this?


Exception:

javax.servlet.ServletException: Executing query Channel.findByIdAndUserId with 
params {userId=21, cid=null} failed

      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:99)

      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:117)

      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:662)

Caused by: com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing 
query Channel.findByIdAndUserId with params {userId=21, cid=null} failed

      at 
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)

      at 
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)

      at 
com.redhat.rhn.domain.channel.ChannelFactory.lookupByIdAndUser(ChannelFactory.java:92)

      at 
com.redhat.rhn.frontend.action.kickstart.tree.BaseTreeAction.processCommandSetters(BaseTreeAction.java:105)

      at 
com.redhat.rhn.frontend.action.BaseEditAction.execute(BaseEditAction.java:61)

      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 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)

      at 
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)

      ... 45 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: 
expected NUMBER got BINARY



      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)

      ... 53 more


Andy Speagle
System & Storage Administrator
UCATS - Wichita State University

P: 316.978.3869
C: 316.617.2431

_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to