[Spacewalk-list] Error displaying package details
Thomas Foster
thomas.foster80 at gmail.com
Wed Aug 21 20:48:01 UTC 2013
sorry about that....spacewalk-service restart
On Wed, Aug 21, 2013 at 4:46 PM, Thomas Foster <thomas.foster80 at gmail.com>wrote:
> 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/82d5ac3f/attachment.htm>
More information about the Spacewalk-list
mailing list