Bug 665321

Summary:	Error listing user's systems
Product:	[Community] Spacewalk	Reporter:	David Hrbáč <david>
Component:	WebUI	Assignee:	Justin Sherrill <jsherril>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	high	Docs Contact:
Priority:	low
Version:	1.2	CC:	JDavis4102, slukasik
Target Milestone:	---	Keywords:	Regression
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-04-26 09:11:10 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	674675

Description David Hrbáč 2010-12-23 08:57:56 UTC

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.

Comment 1 JDavis4102 2011-01-21 17:53:37 UTC

I am also having this issue.

Comment 2 JDavis4102 2011-01-21 17:54:31 UTC

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

Comment 3 JDavis4102 2011-03-29 18:41:43 UTC

Issue resolved in 1.3

Comment 4 Šimon Lukašík 2011-03-31 07:05:43 UTC

Based on comment 3, I am moving this to MODIFIED state.

Thanks JDavis.

Comment 5 Miroslav Suchý 2011-04-11 07:45:26 UTC

Mass moving to ON_QA before release of Spacewalk 1.4

Comment 6 David Hrbáč 2011-04-11 08:36:20 UTC

I confirm as resolved in 1.3
Thanks,
David Hrbáč

Comment 7 Miroslav Suchý 2011-04-26 09:11:10 UTC

Spacewalk 1.4 has been released