[Spacewalk-list] FW: Spacewalk 1.1 Cannot Create Kickstart Distribution -- Internal Server Error

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>