[Spacewalk-list] Issues viewing Solaris patches in Spacewalk

[Jan Pazdziora]

On Mon, Sep 17, 2012 at 05:36:53PM -0500, Kenny Van Alstyne wrote:
> I'm just curious if anyone else is having the below issue --
> 
> When browsing to Systems -> Select a Solaris x86 box -> Software ->
> Patches, an ISE is reported.  The Tomcat and PostgreSQL logs are
> below.
> 
> 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

I suspect you have patches with the same name-version in more than
one channel in your Spacewalk. Is that so?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat