<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style></style></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1>Running sw 1.3 with oracle 11g backend database.<o:p></o:p><o:p> </o:p>When I try to delete old systems from the web ui I receive an Internal Server Error and then a web traceback email.<o:p></o:p><o:p> </o:p>The following exception occurred while executing this request:<o:p></o:p>POST /rhn/systems/details/DeleteConfirm.do<o:p></o:p><o:p> </o:p>Date:12/5/11 11:33:57 AM EST<o:p></o:p>Headers:<o:p></o:p> host: myspacewalk.none.com<o:p></o:p> connection: keep-alive<o:p></o:p> content-length: 36<o:p></o:p> Cache-Control: max-age=0<o:p></o:p> Origin: https://myspacewalk.none.co<o:p></o:p> user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2<o:p></o:p> content-type: application/x-www-form-urlencoded<o:p></o:p> accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8<o:p></o:p> referer: https://myspacewalk.none.co/rhn/systems/details/DeleteConfirm.do?sid=1000011694<o:p></o:p> accept-encoding: gzip,deflate,sdch<o:p></o:p> accept-language: en-US,en;q=0.8<o:p></o:p> accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3<o:p></o:p> cookie: JSESSIONID=4D17674CB1401860CE2BDB5D7C2CD013; SMSESSION=Q/NEWYnL++4+DQq3DTV/pPylNcNuZl3jQ5jSYO6+12ewZk6WCjT1mNcGs269jprqYsWPtDNKJcfMAsaiGhM4nhGiPT+Kt5lGH5tddrXF6yJs55WK4E1ZpBLuij1ydJ7N07EC6jCp/BR/U4YYxRExwmCicxlTYbsq7P+6gu2ncI/RAQuy5ltqdlSvQtDTz8Z8PHOlVbodFUhl/Ic8C6hr1jXSPFW5I3kU0QA2184lvspM59biWEJYO8y/Sw7R6UrVzduvDQOJBgwMk5IT8NNQU43An+3DsTX2sw2S35n0wc1WL2snpvvm5NN+V+MDFBanJYl0eOmAusrYHRU17WifALQmF3ng5duVkObgKmbkKgdwzPeLY1LFaDj2v1XE4q7cqz/9GCaf7WAk7Dc6RVkLNcPRU+RZ0wq5Zug9ulSsMSPHe0gOk2KTi1YbP8oI0PIExrm59aCPmf2rt6/Qz6Qn5ToqQDsqjEDvVYOIkD99J0s8xAyLiP1Q7dcyPMRryiUloxTJfOMNjv5WxTo44DEP/Q07eP/doomgMMC9kyfQ4A+ZT/9KZRjqNMUfVUMJwCGFNn/E4k3UzufkMYHLiLzxzplQkrOre5aDVQdAHS+FsCjizimhIwnI6MB8/fTJSjPQNHLmStRBhgLzxfJ/lUL0j413pppOk8XaMMcl4S+XiOf25P8xOySuIolB7mi64BmvPLSLcvdELCGvygvC0FlScJ1AX5ZlBSA4qbo5E4gKsoGH626KDeIUXToTP5O+yGLVQk6Br/5E2GIWdmjaA8ipCxQMz5yIWuWVnvJ9csngzVY5IOoKjx7xJQX74J0hJijWISLj/UktRteBidQMcHpjuf1sUPoRi1Xd44mvBQeBz5dx2J43h/Kd/sW2CVjRRJ9j76E8GgH9gigTQxTv82ode87bB/PmXNBdWGZfBV5tSCDWpNbEiCCmNyGPNTcwgayA3vZD2EphsV/c/pos6AnQV1jNE1T8b5Xo1P3/NNUYDKEXVIlvfSg4Tvz9RN60BDFJtJJAAJEo2SpDxQFIaGTRSGbFcLoVh/MghZRiTU/4q+uQRMNhhOydDEXcQUdE3Fy0; pxt-session-cookie=369153xe82e395a65ec78e4c2f886b005a6cc6b<o:p></o:p><o:p> </o:p>Request:<o:p></o:p>Local Name = myspacewalk.none.co<o:p></o:p>Server Name = myspacewalk.none.co<o:p></o:p>Requested Session Id came from Cookie<o:p></o:p>Requested Session Valid = true<o:p></o:p>Session = org.apache.catalina.session.StandardSessionFacade@25201ad9[session=StandardSession[4D17674CB1401860CE2BDB5D7C2CD013]]<o:p></o:p>Protocol = https<o:p></o:p>Request Locale = en_US<o:p></o:p>Request Character Encoding = UTF-8<o:p></o:p>Attribute Names = rhnActiveLang, sid, __sitemesh__page, javax.servlet.jsp.jstl.fmt.timeZone.request, javax.servlet.error.status_code, javax.servlet.error.servlet_name, submittedForm, javax.servlet.request.key_size, requestedUri, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, system, javax.servlet.error.message, session, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, javax.servlet.error.exception, javax.servlet.error.request_uri, org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE, <o:p></o:p><o:p> </o:p>Form Variables:<o:p></o:p> submitted: true<o:p></o:p> sid: 1000011694<o:p></o:p> button: Delete Profile<o:p></o:p><o:p> </o:p><o:p> </o:p>User Information:<o:p></o:p>User swuser (id 2, org_id 1)<o:p></o:p><o:p> </o:p>Exception:<o:p></o:p>javax.servlet.ServletException: ORA-20238: (channel_unsubscribe_no_family) - Attempt to unsubscribe from a channel with no family<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_EXCEPTION", line 31<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 514<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 468<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 415<o:p></o:p>ORA-06512: at "SPACEWALK.DELETE_SERVER", line 86<o:p></o:p>ORA-06512: at line 1<o:p></o:p><o:p> </o:p> at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)<o:p></o:p> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)<o:p></o:p> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)<o:p></o:p> at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82)<o:p></o:p> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)<o:p></o:p> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)<o:p></o:p> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)<o:p></o:p> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p> at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p> at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)<o:p></o:p> at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilterjava:58)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p> at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p> at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p> at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p> at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)<o:p></o:p> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<o:p></o:p> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<o:p></o:p> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<o:p></o:p> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<o:p></o:p> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<o:p></o:p> at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<o:p></o:p> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<o:p></o:p> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<o:p></o:p> at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<o:p></o:p> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<o:p></o:p> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<o:p></o:p> at java.lang.Thread.run(Thread.java:636)<o:p></o:p>Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-20238: (channel_unsubscribe_no_family) - Attempt to unsubscribe from a channel with no family<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_EXCEPTION", line 31<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 514<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 468<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 415<o:p></o:p>ORA-06512: at "SPACEWALK.DELETE_SERVER", line 86<o:p></o:p>ORA-06512: at line 1<o:p></o:p><o:p> </o:p> at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:84)<o:p></o:p> at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)<o:p></o:p> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)<o:p></o:p> at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)<o:p></o:p> at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)<o:p></o:p> at com.redhat.rhn.domain.server.ServerFactory.delete(ServerFactory.java:373)<o:p></o:p> at com.redhat.rhn.manager.system.SystemManager.deleteServer(SystemManagerjava:269)<o:p></o:p> at com.redhat.rhn.frontend.action.systems.sdc.SystemDeleteConfirmAction.execute(SystemDeleteConfirmAction.java:81)<o:p></o:p> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)<o:p></o:p> ... 40 more<o:p></o:p>Caused by: java.sql.SQLException: ORA-20238: (channel_unsubscribe_no_family) - Attempt to unsubscribe from a channel with no family<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_EXCEPTION", line 31<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 514<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 468<o:p></o:p>ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 415<o:p></o:p>ORA-06512: at "SPACEWALK.DELETE_SERVER", line 86<o:p></o:p>ORA-06512: at line 1<o:p></o:p><o:p> </o:p> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)<o:p></o:p> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)<o:p></o:p> at oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:544)<o:p></o:p> at oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:727)<o:p></o:p> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)<o:p></o:p> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)<o:p></o:p> at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)<o:p></o:p> at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)<o:p></o:p> at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)<o:p></o:p> at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)<o:p></o:p> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)<o:p></o:p> ... 46 more<o:p></o:p><o:p> </o:p><o:p> </o:p></div></body></html>