[Spacewalk-list] Error displaying package details
Thomas Foster
thomas.foster80 at gmail.com
Wed Aug 21 18:46:14 UTC 2013
Have you tried a different way to see if it's just the way you view the
packages from that option....In SW you can do the same task multiple
ways....Can you try click Channel and the to the far right you will see a
hyperlink for the number of packages, and click that hyperlink to see if
that will allow you to see the packages in the channel.
On Wed, Aug 21, 2013 at 2:24 PM, Sajesh Singh <ssingh at amnh.org> wrote:
> 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
> ]]****
>
> 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****
>
> ** **
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130821/bb2b74ff/attachment.htm>
More information about the Spacewalk-list
mailing list