[Spacewalk-list] Error displaying package details
Thomas Foster
thomas.foster80 at gmail.com
Wed Aug 21 20:46:23 UTC 2013
log into the server and try satellite-restart.
On Wed, Aug 21, 2013 at 4:24 PM, Sajesh Singh <ssingh at amnh.org> wrote:
> ** **
>
> I am able to see the packages in the channel, but when I click on an
> idividual package to get its details then that I receive the Internal
> Server Error page and the traceback.****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* spacewalk-list-bounces at redhat.com [mailto:
> spacewalk-list-bounces at redhat.com] *On Behalf Of *Thomas Foster
> *Sent:* Wednesday, August 21, 2013 2:46 PM
> *To:* spacewalk-list at redhat.com
> *Subject:* Re: [Spacewalk-list] Error displaying package details****
>
> ** **
>
> 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****
>
> ** **
>
> _______________________________________________
> 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/39ce2fe3/attachment.htm>
More information about the Spacewalk-list
mailing list