<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Has anyone seen this problem:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Spacewalk 1.6<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have a CentOS 5 system profile that I can’t join to certain system groups. Some groups work, some don’t. I can’t see what the difference is.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Here’s a TRACEBACK email:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoPlainText>The following exception occurred while executing this request:<o:p></o:p></p><p class=MsoPlainText>POST /rhn/systems/details/groups/Add.do<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Date:2/8/12 11:47:23 AM PST<o:p></o:p></p><p class=MsoPlainText>Headers:<o:p></o:p></p><p class=MsoPlainText> host: spacewalk.cucbc.com<o:p></o:p></p><p class=MsoPlainText> user-agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1<o:p></o:p></p><p class=MsoPlainText> accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8<o:p></o:p></p><p class=MsoPlainText> accept-language: en-us,en;q=0.5<o:p></o:p></p><p class=MsoPlainText> accept-encoding: gzip, deflate<o:p></o:p></p><p class=MsoPlainText> accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7<o:p></o:p></p><p class=MsoPlainText> connection: keep-alive<o:p></o:p></p><p class=MsoPlainText> referer: <a href="https://spacewalk.cucbc.com/rhn/systems/details/groups/Add.do?sid=1000013123">https://spacewalk.cucbc.com/rhn/systems/details/groups/Add.do?sid=1000013123</a><o:p></o:p></p><p class=MsoPlainText> cookie: JSESSIONID=C7861FB86EB15A500EF4FEED5B4BF84C; pxt-session-cookie=434641x38daaae3f405b5594fd186052e8fa00c<o:p></o:p></p><p class=MsoPlainText> content-type: application/x-www-form-urlencoded<o:p></o:p></p><p class=MsoPlainText> content-length: 722<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Request:<o:p></o:p></p><p class=MsoPlainText>Local Name = spacewalk.cucbc.com<o:p></o:p></p><p class=MsoPlainText>Server Name = spacewalk.cucbc.com<o:p></o:p></p><p class=MsoPlainText>Requested Session Id came from Cookie<o:p></o:p></p><p class=MsoPlainText>Requested Session Valid = true<o:p></o:p></p><p class=MsoPlainText>Session = <a href="mailto:org.apache.catalina.session.StandardSessionFacade@8ce6014[session=StandardSession[C7861FB86EB15A500EF4FEED5B4BF84C">org.apache.catalina.session.StandardSessionFacade@8ce6014[session=StandardSession[C7861FB86EB15A500EF4FEED5B4BF84C</a>]]<o:p></o:p></p><p class=MsoPlainText>Protocol = https<o:p></o:p></p><p class=MsoPlainText>Request Locale = en_US<o:p></o:p></p><p class=MsoPlainText>Request Character Encoding = UTF-8<o:p></o:p></p><p class=MsoPlainText>Attribute Names = rhnActiveLang, javax.servlet.jsp.jstl.fmt.timeZone.request, javax.servlet.error.status_code, javax.servlet.error.servlet_name, javax.servlet.request.key_size, requestedUri, list_1154021400_selected_amt, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, system, javax.servlet.error.message, session, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, javax.servlet.error.exception, javax.servlet.error.request_uri, org.apache.struts.action.mapping.instance, all, org.apache.struts.action.MODULE, <o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Form Variables:<o:p></o:p></p><p class=MsoPlainText> csrf_token: 6791022838737766610<o:p></o:p></p><p class=MsoPlainText> 1154021400_PAGE_SIZE_LABEL_SELECTED: null<o:p></o:p></p><p class=MsoPlainText> list_1154021400_parent_is_an_element: true<o:p></o:p></p><p class=MsoPlainText> 1154021400_PAGE_SIZE_LABEL: 25<o:p></o:p></p><p class=MsoPlainText> list_1154021400_all: false<o:p></o:p></p><p class=MsoPlainText> list_1154021400_filterby: Group Name<o:p></o:p></p><p class=MsoPlainText> sid: 1000013123<o:p></o:p></p><p class=MsoPlainText> list_1154021400_filterclass: com.redhat.rhn.frontend.taglibs.list.ColumnFilter<o:p></o:p></p><p class=MsoPlainText> list_1154021400_sortdir: <o:p></o:p></p><p class=MsoPlainText> list_1154021400_sortby: <o:p></o:p></p><p class=MsoPlainText> list_1154021400_search_child: false<o:p></o:p></p><p class=MsoPlainText> list_1154021400_filterval: web<o:p></o:p></p><p class=MsoPlainText> list_1154021400_filterattr: name<o:p></o:p></p><p class=MsoPlainText> list_1154021400_items: 41<o:p></o:p></p><p class=MsoPlainText> submitted: true<o:p></o:p></p><p class=MsoPlainText> list_1154021400_sel: 41<o:p></o:p></p><p class=MsoPlainText> list_1154021400_sel_all: on<o:p></o:p></p><p class=MsoPlainText> list_1154021400_none: false<o:p></o:p></p><p class=MsoPlainText> list_1154021400_oldfilterval: web<o:p></o:p></p><p class=MsoPlainText> dispatch: Join Selected Groups<o:p></o:p></p><p class=MsoPlainText> list_1154021400_search_parent: true<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>User Information:<o:p></o:p></p><p class=MsoPlainText>User jfillman (id 321, org_id 3)<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Exception:<o:p></o:p></p><p class=MsoPlainText>javax.servlet.ServletException: ERROR: function update_perms_for_user(numeric) does not exist<o:p></o:p></p><p class=MsoPlainText> at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)<o:p></o:p></p><p class=MsoPlainText> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)<o:p></o:p></p><p class=MsoPlainText> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99)<o:p></o:p></p><p class=MsoPlainText> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)<o:p></o:p></p><p class=MsoPlainText> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)<o:p></o:p></p><p class=MsoPlainText> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)<o:p></o:p></p><p class=MsoPlainText> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:91)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></p><p class=MsoPlainText> at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)<o:p></o:p></p><p class=MsoPlainText> at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<o:p></o:p></p><p class=MsoPlainText> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<o:p></o:p></p><p class=MsoPlainText> at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)<o:p></o:p></p><p class=MsoPlainText> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<o:p></o:p></p><p class=MsoPlainText> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)<o:p></o:p></p><p class=MsoPlainText> at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)<o:p></o:p></p><p class=MsoPlainText> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)<o:p></o:p></p><p class=MsoPlainText> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<o:p></o:p></p><p class=MsoPlainText> at java.lang.Thread.run(Thread.java:636)<o:p></o:p></p><p class=MsoPlainText>Caused by: com.redhat.rhn.common.db.WrappedSQLException: ERROR: function update_perms_for_user(numeric) does not exist<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.domain.server.ServerFactory.addServerToGroup(ServerFactory.java:185)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.manager.system.SystemManager.addServerToServerGroup(SystemManager.java:300)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.manager.system.ServerGroupManager.addServers(ServerGroupManager.java:336)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.action.systems.groups.AddGroupsAction.commitAction(AddGroupsAction.java:71)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.frontend.action.DispatchedAction.execute(DispatchedAction.java:48)<o:p></o:p></p><p class=MsoPlainText> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)<o:p></o:p></p><p class=MsoPlainText> ... 40 more<o:p></o:p></p><p class=MsoPlainText>Caused by: org.postgresql.util.PSQLException: ERROR: function update_perms_for_user(numeric) does not exist<o:p></o:p></p><p class=MsoPlainText> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)<o:p></o:p></p><p class=MsoPlainText> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)<o:p></o:p></p><p class=MsoPlainText> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)<o:p></o:p></p><p class=MsoPlainText> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)<o:p></o:p></p><p class=MsoPlainText> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)<o:p></o:p></p><p class=MsoPlainText> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)<o:p></o:p></p><p class=MsoPlainText> at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)<o:p></o:p></p><p class=MsoPlainText> at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)<o:p></o:p></p><p class=MsoPlainText> ... 48 more<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Cheers,<o:p></o:p></p><p class=MsoNormal>--james<o:p></o:p></p></div></body></html>