When browsing to Systems -> Select a Solaris x86 box -> Software -> Patches, the below ISE is reported: 2012-09-17 09:07:45,345 [TP-Processor5] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT PN.id as ID, PN.id || '|' || PE.id AS ID_COMBO, PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE, PN.name AS name, PE.version, PE.release, PE.epoch, PN.id AS NAME_ID, PE.id AS EVR_ID, nvl( (select spt.name from rhnSolarisPatchType spt, rhnSolarisPatch RSP, rhnPackage p where RSP.package_id = p.id and P.name_id = SP.name_id and P.evr_id = SP.evr_id and P.package_arch_id = SP.package_arch_id and RSP.patch_type = spt.id), 'unknown') as PATCH_TYPE FROM rhnPackageName PN, rhnPackageEVR PE, rhnServerPackage SP WHERE SP.server_id = ? AND SP.name_id = PN.id AND SP.evr_id = PE.id AND EXISTS ( SELECT 1 FROM rhnPackageArch PA, rhnArchType AT WHERE PA.id = SP.package_arch_id AND AT.id = PA.arch_type_id AND AT.label = 'solaris-patch' ) ORDER BY UPPER(PN.name), UPPER(evr_t_as_vre_simple(PE.evr)) com.redhat.rhn.common.db.WrappedSQLException: ERROR: more than one row returned by a subquery used as an expression at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:54) at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:44) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430) 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.solarispackage.SolarisManager.solarisPackageHelper(SolarisManager.java:43) at com.redhat.rhn.manager.solarispackage.SolarisManager.systemPatchList(SolarisManager.java:83) at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.getDataResult(PatchListSetupAction.java:81) at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.execute(PatchListSetupAction.java:58) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99) 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:91) 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:679) Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138) ... 52 more 2012-09-17 09:07:45,348 [TP-Processor5] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.redhat.rhn.common.db.WrappedSQLException 2012-09-17 09:07:45,348 [TP-Processor5] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back javax.servlet.ServletException: ERROR: more than one row returned by a subquery used as an expression 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:99) 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:91) 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:679) Caused by: com.redhat.rhn.common.db.WrappedSQLException: ERROR: more than one row returned by a subquery used as an expression at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:54) at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:44) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430) 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.solarispackage.SolarisManager.solarisPackageHelper(SolarisManager.java:43) at com.redhat.rhn.manager.solarispackage.SolarisManager.systemPatchList(SolarisManager.java:83) at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.getDataResult(PatchListSetupAction.java:81) at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.execute(PatchListSetupAction.java:58) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) ... 40 more Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138) ... 52 more 2012-09-17 09:07:45,350 [TP-Processor5] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430) 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.solarispackage.SolarisManager.solarisPackageHelper(SolarisManager.java:43) at com.redhat.rhn.manager.solarispackage.SolarisManager.systemPatchList(SolarisManager.java:83) at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.getDataResult(PatchListSetupAction.java:81) at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.execute(PatchListSetupAction.java:58) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99) 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:91) 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:679) 2012-09-17 09:07:45,355 [RHN Message Dispatcher] WARN com.redhat.rhn.common.messaging.SmtpMail - MessagingException while trying to send email: javax.mail.SendFailedException: Send failed; nested exception is: javax.mail.MessagingException: Connection refused; nested exception is: java.net.ConnectException: Connection refused 2012-09-17 09:07:45,356 [RHN Message Dispatcher] ERROR com.redhat.rhn.common.messaging.ActionExecutor - com.redhat.rhn.common.messaging.JavaMailException: MessagingException while trying to send email: javax.mail.SendFailedException: Send failed; nested exception is: javax.mail.MessagingException: Connection refused; nested exception is: java.net.ConnectException: Connection refused com.redhat.rhn.common.messaging.JavaMailException: MessagingException while trying to send email: javax.mail.SendFailedException: Send failed; nested exception is: javax.mail.MessagingException: Connection refused; nested exception is: java.net.ConnectException: Connection refused at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:145) at com.redhat.rhn.frontend.events.BaseMailAction.execute(BaseMailAction.java:43) at com.redhat.rhn.common.messaging.ActionExecutor.run(ActionExecutor.java:69) at com.redhat.rhn.common.messaging.MessageDispatcher.run(MessageDispatcher.java:58) at java.lang.Thread.run(Thread.java:679) Caused by: javax.mail.SendFailedException: Send failed; nested exception is: javax.mail.MessagingException: Connection refused; nested exception is: java.net.ConnectException: Connection refused at javax.mail.Transport.doSend(Transport.java:231) at javax.mail.Transport.send(Transport.java:75) at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:139) ... 4 more Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-1] ERROR: more than one row returned by a subquery used as an expression Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-2] STATEMENT: SELECT PN.id as ID, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-3] PN.id || '|' || PE.id AS ID_COMBO, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-4] PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-5] PN.name AS name, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-6] PE.version, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-7] PE.release, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-8] PE.epoch, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-9] PN.id AS NAME_ID, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-10] PE.id AS EVR_ID, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-11] nvl( (select spt.name from rhnSolarisPatchType spt, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-12] rhnSolarisPatch RSP, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-13] rhnPackage p Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-14] where RSP.package_id = p.id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-15] and P.name_id = SP.name_id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-16] and P.evr_id = SP.evr_id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-17] and P.package_arch_id = SP.package_arch_id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-18] and RSP.patch_type = spt.id), Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-19] 'unknown') as PATCH_TYPE Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-20] FROM rhnPackageName PN, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-21] rhnPackageEVR PE, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-22] rhnServerPackage SP Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-23] WHERE SP.server_id = $1 Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-24] AND SP.name_id = PN.id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-25] AND SP.evr_id = PE.id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-26] AND EXISTS ( SELECT 1 Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-27] FROM rhnPackageArch PA, Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-28] rhnArchType AT Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-29] WHERE PA.id = SP.package_arch_id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-30] AND AT.id = PA.arch_type_id Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-31] AND AT.label = 'solaris-patch' ) Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-32] ORDER BY UPPER(PN.name), UPPER(evr_t_as_vre_simple(PE.evr)) Sep 17 09:43:59 spacewalkserver postgres[27756]: [7-1] ERROR: current transaction is aborted, commands ignored until end of transaction block