Michael, Thanks for the reply. I am using spacewalk 1.6 (upgraded from 1.5) on fedora 15 with postgresql 9.0. When I get my dev server back up I can work on reproducing the error in more detail. I looked back in my prod logs and I think I may have found the corresponding error in /var/log/tomcat6/catalina.out. This could have been from one of the other errors though. I seemed to have a lot of group related errors when I had multiple users with different group restrictions.If there is a different log I should look in let me know. Thanks for your help. 2012-02-06 09:23:44,788 [TP-Processor3] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back javax.servlet.ServletException: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function update_perms_for_user(numeric) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Where: PL/pgSQL function "update_perms_for_server_group" line 22 at PERFORM SQL statement "SELECT rhn_cache.update_perms_for_server_group(server_group_id_in)" PL/pgSQL function "insert_into_servergroup" line 39 at PERFORM SQL statement "SELECT rhn_server.insert_into_servergroup(sgm.server_id, sgm.server_group_id)" PL/pgSQL function "insert_into_servergroup_maybe" line 19 at PERFORM at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:679) Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: function update_perms_for_user(numeric) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Where: PL/pgSQL function "update_perms_for_server_group" line 22 at PERFORM SQL statement "SELECT rhn_cache.update_perms_for_server_group(server_group_id_in)" PL/pgSQL function "insert_into_servergroup" line 39 at PERFORM SQL statement "SELECT rhn_server.insert_into_servergroup(sgm.server_id, sgm.server_group_id)" PL/pgSQL function "insert_into_servergroup_maybe" line 19 at PERFORM at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:3267) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115) at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511) at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34) at com.redhat.rhn.domain.server.ServerFactory.addServerToGroup(ServerFactory.java:185) at com.redhat.rhn.manager.system.SystemManager.addServerToServerGroup(SystemManager.java:300) at com.redhat.rhn.manager.system.ServerGroupManager.addServers(ServerGroupManager.java:336) at com.redhat.rhn.frontend.action.systems.groups.AddGroupsAction.commitAction(AddGroupsAction.java:71) at com.redhat.rhn.frontend.action.DispatchedAction.execute(DispatchedAction.java:48) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) ... 40 more Caused by: org.postgresql.util.PSQLException: ERROR: function update_perms_for_user(numeric) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Where: PL/pgSQL function "update_perms_for_server_group" line 22 at PERFORM SQL statement "SELECT rhn_cache.update_perms_for_server_group(server_group_id_in)" PL/pgSQL function "insert_into_servergroup" line 39 at PERFORM SQL statement "SELECT rhn_server.insert_into_servergroup(sgm.server_id, sgm.server_group_id)" PL/pgSQL function "insert_into_servergroup_maybe" line 19 at PERFORM at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381) at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:3253) ... 49 more rpm -qa | grep spacew spacewalk-taskomatic-1.6.101-1.fc15.noarch spacewalk-backend-libs-1.6.66-1.fc15.noarch spacewalk-java-postgresql-1.6.101-1.fc15.noarch spacewalk-backend-xmlrpc-1.6.66-1.fc15.noarch spacewalk-selinux-1.6.2-1.fc15.noarch spacewalk-backend-package-push-server-1.6.66-1.fc15.noarch spacewalk-search-1.6.8-1.fc15.noarch spacewalk-monitoring-1.4.1-1.fc15.noarch spacewalk-common-1.5.1-1.fc15.noarch spacewalk-config-1.6.4-1.fc15.noarch spacewalk-backend-sql-1.6.66-1.fc15.noarch spacewalk-backend-tools-1.6.66-1.fc15.noarch spacewalk-backend-iss-export-1.6.66-1.fc15.noarch spacewalk-postgresql-1.5.1-1.fc15.noarch spacewalk-base-1.6.37-1.fc15.noarch spacewalk-certs-tools-1.6.7-1.fc15.noarch spacewalk-java-config-1.6.101-1.fc15.noarch spacewalk-backend-sql-postgresql-1.6.66-1.fc15.noarch spacewalk-backend-applet-1.6.66-1.fc15.noarch spacewalk-jpp-workaround-1.0.1-1.fc15.noarch spacewalk-backend-xml-export-libs-1.6.66-1.fc15.noarch spacewalk-schema-1.6.42-1.fc15.noarch spacewalk-java-1.6.101-1.fc15.noarch spacewalk-slf4j-1.6.1-1.fc13.noarch spacewalk-base-minimal-1.6.37-1.fc15.noarch spacewalk-pxt-1.6.37-1.fc15.noarch spacewalk-java-lib-1.6.101-1.fc15.noarch spacewalk-backend-config-files-common-1.6.66-1.fc15.noarch spacewalk-backend-xp-1.6.66-1.fc15.noarch spacewalk-monitoring-selinux-1.6.2-1.fc15.noarch spacewalk-grail-1.6.37-1.fc15.noarch spacewalk-backend-app-1.6.66-1.fc15.noarch spacewalk-setup-jabberd-1.6.5-1.fc15.noarch spacewalk-backend-config-files-tool-1.6.66-1.fc15.noarch spacewalk-backend-iss-1.6.66-1.fc15.noarch spacewalk-sniglets-1.6.37-1.fc15.noarch spacewalk-repo-1.6-1.fc15.noarch spacewalk-admin-1.6.3-1.fc15.noarch spacewalk-backend-1.6.66-1.fc15.noarch spacewalk-backend-server-1.6.66-1.fc15.noarch spacewalk-backend-config-files-1.6.66-1.fc15.noarch spacewalk-html-1.6.37-1.fc15.noarch spacewalk-doc-indexes-1.1.1-1.fc15.noarch spacewalk-branding-1.6.4-1.fc15.noarch spacewalk-setup-1.6.5-1.fc15.noarch rpm -qa | grep postgres spacewalk-java-postgresql-1.6.101-1.fc15.noarch postgresql-server-9.0.6-1.fc15.x86_64 spacewalk-postgresql-1.5.1-1.fc15.noarch spacewalk-backend-sql-postgresql-1.6.66-1.fc15.noarch postgresql-libs-9.0.6-1.fc15.x86_64 postgresql-jdbc-9.0.801-4.fc15.x86_64 postgresql-9.0.6-1.fc15.x86_64