<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"> Spacewalk 2.0 <o:p></o:p> CentOS 5.9<o:p></o:p> Oracle Database 11g Release 11.2.0.1.0 - 64bit Production<o:p></o:p> <o:p> </o:p> When trying to view package details either by browsing the channel or listing the installed packages from a spacewalk client I get the following traceback. Has anyone ever come across this issue before?<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> The following exception occurred while executing this request:<o:p></o:p> GET /rhn/software/packages/Details.do<o:p></o:p> <o:p> </o:p> Date:8/20/13 11:45:58 PM EDT<o:p></o:p> Headers:<o:p></o:p> host: hostname.tld<o:p></o:p> user-agent: Mozilla/5.0 (X11; Linux x86_64; rv:19.0) Gecko/20100101 Firefox/19.0<o:p></o:p> accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8<o:p></o:p> accept-language: en-US,en;q=0.5<o:p></o:p> accept-encoding: gzip, deflate<o:p></o:p> DNT: 1<o:p></o:p> referer: <a href="https://hostname.tld/rhn/software/packages/NameOverview.do?package_name=thttpd&channel_arch=channel-ia32&channel_arch=channel-ia64&channel_arch=channel-x86_64&channel_arch=channel-s390&channel_arch=channel-s390x&channel_arch=channel-ppc&channel_arch=channel-sparc-sun-solaris&channel_arch=channel-i386-sun-solaris&search_subscribed_channels=no&channel_filter"> https://hostname.tld/rhn/software/packages/NameOverview.do?package_name=thttpd&channel_arch=channel-ia32&channel_arch=channel-ia64&channel_arch=channel-x86_64&channel_arch=channel-s390&channel_arch=channel-s390x&channel_arch=channel-ppc&channel_arch=channel-sparc-sun-solaris&channel_arch=channel-i386-sun-solaris&search_subscribed_channels=no&channel_filter</a>=<o:p></o:p> cookie: JSESSIONID=CA2B59CC66B37BAF5FBB9FDC9CC6A84D; DWRSESSIONID=xyb*hxwgsSgwVFsjrraash$Wu3k; pxt-session-cookie=22393xb227c8339044a874261d7d0b5066717c<o:p></o:p> connection: keep-alive<o:p></o:p> <o:p> </o:p> Request:<o:p></o:p> Local Name = hostname.tld<o:p></o:p> Server Name = hostname.tld<o:p></o:p> Requested Session Id came from Cookie<o:p></o:p> Requested Session Valid = true<o:p></o:p> Session = <a href="mailto:org.apache.catalina.session.StandardSessionFacade@2368e4dd[session=StandardSession[CA2B59CC66B37BAF5FBB9FDC9CC6A84D"> org.apache.catalina.session.StandardSessionFacade@2368e4dd[session=StandardSession[CA2B59CC66B37BAF5FBB9FDC9CC6A84D</a>]]<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, javax.servlet.jsp.jstl.fmt.timeZone.request, package_name, javax.servlet.request.key_size, pid, isDebuginfo, pack, requestedUri, type, url, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, packArches, package_key, session, description, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE, <o:p></o:p> <o:p> </o:p> <o:p> </o:p> User Information:<o:p></o:p> User username (id 2, org_id 1)<o:p></o:p> <o:p> </o:p> Exception:<o:p></o:p> javax.servlet.ServletException: could not initialize a collection: [com.redhat.rhn.domain.rhnpackage.Package.publishedErrata#106267]<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:102)<o:p></o:p> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)<o:p></o:p> at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)<o:p></o:p> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)<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:127)<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(PageFilter.java: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:100)<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:57)<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:679)<o:p></o:p> Caused by: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.redhat.rhn.domain.rhnpackage.Package.publishedErrata#106267]<o:p></o:p> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)<o:p></o:p> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<o:p></o:p> at org.hibernate.loader.Loader.loadCollection(Loader.java:2001)<o:p></o:p> at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)<o:p></o:p> at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)<o:p></o:p> at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)<o:p></o:p> at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)<o:p></o:p> at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)<o:p></o:p> at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)<o:p></o:p> at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:109)<o:p></o:p> at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:146)<o:p></o:p> at com.redhat.rhn.frontend.action.rhnpackage.PackageDetailsAction.execute(PackageDetailsAction.java:138)<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.SQLSyntaxErrorException: ORA-00904: "PUBLISHEDE1_"."ERRATA_FROM": invalid identifier<o:p></o:p> <o:p> </o:p> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:765)<o:p></o:p> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:662)<o:p></o:p> at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546)<o:p></o:p> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)<o:p></o:p> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)<o:p></o:p> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)<o:p></o:p> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)<o:p></o:p> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)<o:p></o:p> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:440)<o:p></o:p> at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)<o:p></o:p> at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)<o:p></o:p> at org.hibernate.loader.Loader.doQuery(Loader.java:674)<o:p></o:p> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)<o:p></o:p> at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)<o:p></o:p> ... 50 more<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Regards,<o:p></o:p> <o:p> </o:p> Sajesh Singh<o:p></o:p> <o:p> </o:p> </div> </body> </html>