Description of problem: We are not able to list users's systems. Users -> select user -> Systems Version-Release number of selected component (if applicable): jabberd-2.2.11-2.el5 jabberpy-0.5-0.17.el5 osad-5.9.44-1.el5 osa-dispatcher-5.9.44-1.el5 spacewalk-setup-1.2.16-1.el5 spacewalk-setup-jabberd-1.3.1-1.el5 Actual results: The following exception occurred while executing this request: GET /rhn/users/SystemsAdmined.do Date:12/23/10 9:23:31 AM CET Headers: host: spacewalk.vsb.cz user-agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; cs; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 (.NET CLR 3.5.30729) accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 accept-language: cs,en-us;q=0.7,en;q=0.3 accept-encoding: gzip,deflate accept-charset: windows-1250,utf-8;q=0.7,*;q=0.7 Keep-Alive: 115 connection: keep-alive referer: https://spacewalk.vsb.cz/rhn/users/UserDetails.do?uid=2 cookie: JSESSIONID=C69515E749077FDAA81717427F597759; __utma=17522726.890973742.1292942621.1292942621.1292942621.1; __utmc=17522726; __utmz=17522726.1292942621.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); pxt-session-cookie=253xc7c6d8abd4679570cef21cdc07d8e83c Request: Local Name = spacewalk.vsb.cz Server Name = spacewalk.vsb.cz Requested Session Id came from Cookie Requested Session Valid = true Session = org.apache.catalina.session.StandardSessionFacade@6326b183[session=StandardSession[C69515E749077FDAA81717427F597759]] Protocol = https Request Locale = en_US Request Character Encoding = UTF-8 Attribute Names = rhnActiveLang, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, javax.servlet.jsp.jstl.fmt.timeZone.request, session, targetuser, javax.servlet.request.key_size, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, requestedUri, org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE, User Information: User hrb33adm (id 1, org_id 1) Exception: javax.servlet.ServletException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X' 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:82) 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:101) 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:108) 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:55) 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:636) Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X' at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:84) at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:455) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:432) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:341) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:281) at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:109) at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57) at com.redhat.rhn.manager.user.UserManager.visibleSystems(UserManager.java:715) at com.redhat.rhn.frontend.action.user.VisibleSystemsListSetupAction.execute(VisibleSystemsListSetupAction.java:56) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) ... 40 more Caused by: java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X' at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602) at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138) ... 50 more Expected results: Just list the systems.
I am also having this issue.
I am getting an "Internal Server Error" when I am within a specific users settings and I click the "Systems" link. I receive the follow traceback error when I click that link. The following exception occurred while executing this request: GET /rhn/users/SystemsAdmined.do
Issue resolved in 1.3
Based on comment 3, I am moving this to MODIFIED state. Thanks JDavis.
Mass moving to ON_QA before release of Spacewalk 1.4
I confirm as resolved in 1.3 Thanks, David Hrbáč
Spacewalk 1.4 has been released