[Spacewalk-list] FW: Spacewalk 1.1 Cannot Create Kickstart Distribution -- Internal Server Error
DD W
ddwx2 at hotmail.com
Wed Nov 3 22:12:45 UTC 2010
Here is some more information regarding this problem. Spacewalk requires cobbler-2.0.3. I installed cobbler 1.6.6 and when I installed the prerequisites cobbler was updated to 2.0.3 again. When I try to create a kickstart distribution using the GUI (systems->kickstart->distributions and selecting "create new distribution" I receive the Internal Serve Error page that says "The server experienced a problem which prevented your request from being filled out. It may not be possible to execute this action at this time. Please help us correct this problem by contacting us with details of how you received this message."
The log file /var/log/tomcat5/catalina.out shows the following message is issued at the time I select "create new distribution".
2010-11-03 08:03:44,067 [TP-Processor6] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception
java.sql.SQLException: ORA-00904: "C"."ID": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
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.domain.channel.ChannelFactory.getKickstartableChannels(ChannelFactory.java:645)
at com.redhat.rhn.manager.kickstart.tree.BaseTreeEditOperation.getKickstartableChannels(BaseTreeEditOperation.java:286)
at com.redhat.rhn.frontend.action.kickstart.tree.BaseTreeAction.processRequestAttributes(BaseTreeAction.java:55)
at com.redhat.rhn.frontend.action.BaseEditAction.execute(BaseEditAction.java:51)
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.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)
For the record when I select systems->kickstart->profiles I receive the same Internal Server Error page I described above. The kickstart options baremetal, GPG and SSL keys, file preservation, and kickstart snippets associated web pages all seem to display correctly.
-D
From: ddwx2 at hotmail.com
To: spacewalk-list at redhat.com
Subject: Spacewalk 1.1 Cannot Create Kickstart Distribution -- Internal Server Error
Date: Mon, 1 Nov 2010 16:27:38 -0700
Hi,
I have Spacewalk 1.1 installed on CentOS 5.5 (i386). The installation is a couple of weeks old. Cobbler 2.0.3.1-3.el5.noarch is installed. Some searching turned up a similar issue involving CentOS 5.4. The recommendation was to uninstall cobbler 2.0.3 and install cobbler-1.6.6. I was able to find cobbler-1.6.6. I stopped spacewalk and made sure cobblerd was also stopped. As a precaution I also stopped Oracle-xe.
I ran "yum remove cobbler" to find out what would be removed. In addition to cobbler it wants to remove the following dependencies:
osa-dispatcher-selinux noarch 5.9.42-1.el5 installed 213 k
spacewalk-admin noarch 1.2.6-1.el5 installed 30 k
spacewalk-backend-tools noarch 1.2.49-1.el5 installed 1.0 M
spacewalk-common noarch 1.2.3-1.el5 installed 30
spacewalk-java noarch 1.2.73-1.el5 installed 10 M
spacewalk-oracle noarch 1.2.3-1.el5 installed 63
spacewalk-schema noarch 1.2.55-1.el5 installed 5.7 M
spacewalk-selinux noarch 1.2.3-1.el5 installed 69 k
spacewalk-setup noarch 1.2.13-1.el5 installed 146 k
spacewalk-taskomatic noarch 1.2.73-1.el5 installed 9.3 k
I also ran "yum downgrade cobbler" to see if that would work and received:
Only Upgrade available on package: cobbler-2.0.3.1-3.el5.noarch
Nothing to do
For CentOS 5.5 should I proceed with removing cobbler and it's dependencies, install the 1.6.6 version of cobbler, and reinstall the dependencies or is there another solution to this problem.
-D
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20101103/39bf2977/attachment.htm>
More information about the Spacewalk-list
mailing list