[Spacewalk-list] Error displaying package details

Wed Aug 21 18:24:28 UTC 2013

Spacewalk 2.0
CentOS 5.9
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

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?

The following exception occurred while executing this request:

GET /rhn/software/packages/Details.do

Date:8/20/13 11:45:58 PM EDT

Headers:

  host: hostname.tld

  user-agent: Mozilla/5.0 (X11; Linux x86_64; rv:19.0) Gecko/20100101 Firefox/19.0

  accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

  accept-language: en-US,en;q=0.5

  accept-encoding: gzip, deflate

  DNT: 1

  referer: 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=

  cookie: JSESSIONID=CA2B59CC66B37BAF5FBB9FDC9CC6A84D; DWRSESSIONID=xyb*hxwgsSgwVFsjrraash$Wu3k; pxt-session-cookie=22393xb227c8339044a874261d7d0b5066717c

  connection: keep-alive

Request:

Local Name = hostname.tld

Server Name = hostname.tld

Requested Session Id came from Cookie

Requested Session Valid = true

Session = org.apache.catalina.session.StandardSessionFacade at 2368e4dd[session=StandardSession[CA2B59CC66B37BAF5FBB9FDC9CC6A84D<mailto:org.apache.catalina.session.StandardSessionFacade at 2368e4dd[session=StandardSession[CA2B59CC66B37BAF5FBB9FDC9CC6A84D>]]

Protocol = https

Request Locale = en_US

Request Character Encoding = UTF-8

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,

User Information:

User username (id 2, org_id 1)

Exception:

javax.servlet.ServletException: could not initialize a collection: [com.redhat.rhn.domain.rhnpackage.Package.publishedErrata#106267]

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

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

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

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

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

Caused by: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.redhat.rhn.domain.rhnpackage.Package.publishedErrata#106267]

                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)

                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

                at org.hibernate.loader.Loader.loadCollection(Loader.java:2001)

                at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)

                at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)

                at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)

                at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)

                at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)

                at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)

                at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:109)

                at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:146)

                at com.redhat.rhn.frontend.action.rhnpackage.PackageDetailsAction.execute(PackageDetailsAction.java:138)

                at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)

                ... 40 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "PUBLISHEDE1_"."ERRATA_FROM": invalid identifier

                at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:765)

                at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:662)

                at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546)

                at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)

                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)

                at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)

                at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)

                at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)

                at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:440)

                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.loadCollection(Loader.java:1994)

                ... 50 more

Regards,

Sajesh Singh

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130821/162849eb/attachment.htm>