Bug 1006739

Description of problem:

 When browsing to Systems -> Select a Solaris x86 box -> Software ->
 Patches, an ISE is reported.  The Tomcat and PostgreSQL logs are
 below.

(https://www.redhat.com/archives/spacewalk-list/2012-September/msg00064.html)

Version-Release number of selected component (if applicable):
spacewalk-java

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:
> 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


Expected results:


Additional info:
https://www.redhat.com/archives/spacewalk-list/2012-November/msg00196.html
https://www.redhat.com/archives/spacewalk-list/2013-January/msg00177.html
https://www.redhat.com/archives/spacewalk-list/2013-February/msg00019.html