<div dir="ltr">sorry about that....spacewalk-service restart<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Aug 21, 2013 at 4:46 PM, Thomas Foster <span dir="ltr"><<a href="mailto:thomas.foster80@gmail.com" target="_blank">thomas.foster80@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">log into the server and try satellite-restart.<br></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra">
<br><br><div class="gmail_quote">On Wed, Aug 21, 2013 at 4:24 PM, Sajesh Singh <span dir="ltr"><<a href="mailto:ssingh@amnh.org" target="_blank">ssingh@amnh.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> [mailto:<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>]
<b>On Behalf Of </b>Thomas Foster<br>
<b>Sent:</b> Wednesday, August 21, 2013 2:46 PM<br>
<b>To:</b> <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a><br>
<b>Subject:</b> Re: [Spacewalk-list] Error displaying package details<u></u><u></u></span></p><div><div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Wed, Aug 21, 2013 at 2:24 PM, Sajesh Singh <<a href="mailto:ssingh@amnh.org" target="_blank">ssingh@amnh.org</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Spacewalk 2.0
<u></u><u></u></p>
<p class="MsoNormal">CentOS 5.9<u></u><u></u></p>
<p class="MsoNormal">Oracle Database 11g Release 11.2.0.1.0 - 64bit Production<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">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?<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p>The following exception occurred while executing this request:<u></u><u></u></p>
<p>GET /rhn/software/packages/Details.do<u></u><u></u></p>
<p> <u></u><u></u></p>
<p>Date:8/20/13 11:45:58 PM EDT<u></u><u></u></p>
<p>Headers:<u></u><u></u></p>
<p> host: hostname.tld<u></u><u></u></p>
<p> user-agent: Mozilla/5.0 (X11; Linux x86_64; rv:19.0) Gecko/20100101 Firefox/19.0<u></u><u></u></p>
<p> accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8<u></u><u></u></p>
<p> accept-language: en-US,en;q=0.5<u></u><u></u></p>
<p> accept-encoding: gzip, deflate<u></u><u></u></p>
<p> DNT: 1<u></u><u></u></p>
<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" target="_blank">
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>=<u></u><u></u></p>
<p> cookie: JSESSIONID=CA2B59CC66B37BAF5FBB9FDC9CC6A84D; DWRSESSIONID=xyb*hxwgsSgwVFsjrraash$Wu3k; pxt-session-cookie=22393xb227c8339044a874261d7d0b5066717c<u></u><u></u></p>
<p> connection: keep-alive<u></u><u></u></p>
<p> <u></u><u></u></p>
<p>Request:<u></u><u></u></p>
<p>Local Name = hostname.tld<u></u><u></u></p>
<p>Server Name = hostname.tld<u></u><u></u></p>
<p>Requested Session Id came from Cookie<u></u><u></u></p>
<p>Requested Session Valid = true<u></u><u></u></p>
<p>Session = <a href="mailto:org.apache.catalina.session.StandardSessionFacade@2368e4dd[session=StandardSession[CA2B59CC66B37BAF5FBB9FDC9CC6A84D" target="_blank">
org.apache.catalina.session.StandardSessionFacade@2368e4dd[session=StandardSession[CA2B59CC66B37BAF5FBB9FDC9CC6A84D</a>]]<u></u><u></u></p>
<p>Protocol = https<u></u><u></u></p>
<p>Request Locale = en_US<u></u><u></u></p>
<p>Request Character Encoding = UTF-8<u></u><u></u></p>
<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,
<u></u><u></u></p>
<p> <u></u><u></u></p>
<p> <u></u><u></u></p>
<p>User Information:<u></u><u></u></p>
<p>User username (id 2, org_id 1)<u></u><u></u></p>
<p> <u></u><u></u></p>
<p>Exception:<u></u><u></u></p>
<p>javax.servlet.ServletException: could not initialize a collection: [com.redhat.rhn.domain.rhnpackage.Package.publishedErrata#106267]<u></u><u></u></p>
<p> at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)<u></u><u></u></p>
<p> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)<u></u><u></u></p>
<p> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)<u></u><u></u></p>
<p> at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:102)<u></u><u></u></p>
<p> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)<u></u><u></u></p>
<p> at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)<u></u><u></u></p>
<p> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)<u></u><u></u></p>
<p> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<u></u><u></u></p>
<p> at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:127)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<u></u><u></u></p>
<p> at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)<u></u><u></u></p>
<p> at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<u></u><u></u></p>
<p> at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<u></u><u></u></p>
<p> at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:100)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<u></u><u></u></p>
<p> at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:57)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<u></u><u></u></p>
<p> at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<u></u><u></u></p>
<p> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<u></u><u></u></p>
<p> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)<u></u><u></u></p>
<p> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<u></u><u></u></p>
<p> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<u></u><u></u></p>
<p> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<u></u><u></u></p>
<p> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<u></u><u></u></p>
<p> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<u></u><u></u></p>
<p> at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<u></u><u></u></p>
<p> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<u></u><u></u></p>
<p> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<u></u><u></u></p>
<p> at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<u></u><u></u></p>
<p> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<u></u><u></u></p>
<p> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<u></u><u></u></p>
<p> at java.lang.Thread.run(Thread.java:679)<u></u><u></u></p>
<p>Caused by: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.redhat.rhn.domain.rhnpackage.Package.publishedErrata#106267]<u></u><u></u></p>
<p> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)<u></u><u></u></p>
<p> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<u></u><u></u></p>
<p> at org.hibernate.loader.Loader.loadCollection(Loader.java:2001)<u></u><u></u></p>
<p> at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)<u></u><u></u></p>
<p> at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)<u></u><u></u></p>
<p> at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)<u></u><u></u></p>
<p> at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)<u></u><u></u></p>
<p> at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)<u></u><u></u></p>
<p> at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)<u></u><u></u></p>
<p> at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:109)<u></u><u></u></p>
<p> at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:146)<u></u><u></u></p>
<p> at com.redhat.rhn.frontend.action.rhnpackage.PackageDetailsAction.execute(PackageDetailsAction.java:138)<u></u><u></u></p>
<p> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)<u></u><u></u></p>
<p> ... 40 more<u></u><u></u></p>
<p>Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "PUBLISHEDE1_"."ERRATA_FROM": invalid identifier<u></u><u></u></p>
<p> <u></u><u></u></p>
<p> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:765)<u></u><u></u></p>
<p> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:662)<u></u><u></u></p>
<p> at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546)<u></u><u></u></p>
<p> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)<u></u><u></u></p>
<p> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)<u></u><u></u></p>
<p> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)<u></u><u></u></p>
<p> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)<u></u><u></u></p>
<p> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)<u></u><u></u></p>
<p> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:440)<u></u><u></u></p>
<p> at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)<u></u><u></u></p>
<p> at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)<u></u><u></u></p>
<p> at org.hibernate.loader.Loader.doQuery(Loader.java:674)<u></u><u></u></p>
<p> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)<u></u><u></u></p>
<p> at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)<u></u><u></u></p>
<p> ... 50 more<u></u><u></u></p>
<p> <u></u><u></u></p>
<p> <u></u><u></u></p>
<p>Regards,<u></u><u></u></p>
<p><span style="color:#888888"> <u></u><u></u></span></p>
<p><span style="color:#888888">Sajesh Singh<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#888888"> <u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>