[Spacewalk-list] ISE when rhnpushing Solaris Patches

[Pierre Casenove]

Hello,
Please find attached a second patch,  adressing an ISE encountered
when navigating to <Software Channel> --> <Child Channel> --> Target
Systems

Pierre


2012/7/4 Pierre Casenove <pcasenove at gmail.com>:
> Please find attached a patch to correct the following error on page
> /rhn/systems/details/packages/patchsets/PatchSetList.do:
> .redhat.rhn.common.db.WrappedSQLException: ERROR: function
> nvl(timestamp with time zone, timestamp with time zone) does not exist
>
> Which occurs when navigating to System --> Software --> Patch Clusters
> and that at least one patch cluster exists.
>
> I've also noticed a potential problem with the name of the patch cluster:
> The mpm file that has been generated for the patch cluster is:
> patch-cluster-solaris--20120412-1.sparc-solaris-patch-cluster.mpm
> (notice the two minus sign in the middle)
> In spacewalk GUI, the patch cluster is named:patch-cluster-solaris-
>
> Will all patch clusters be named patch-cluster-solaris- without any problem?
>
> Pierre
>
>
> 2012/7/4 Pierre Casenove <pcasenove at gmail.com>:
>> I've rhnpushed the complete patch cluster.
>>
>> thanks a lot for this fix!
>>
>>
>> 2012/7/4 Jan Pazdziora <jpazdziora at redhat.com>:
>>> On Wed, Jul 04, 2012 at 10:05:42AM +0200, Pierre Casenove wrote:
>>>> Hello list,
>>>> I have generated the 348 mpm files corresponding to the latest Solaris
>>>> 10 patch cluster, and I'm trying to rhnpush them.
>>>> rhnpush --username=administrator --password=<XXXXXXX>
>>>> --channel=solaris-10-sparc-patches --server=http://server/APP --dir
>>>> ./mpm
>>>> And I get the following error:
>>>> Error pushing /home/solaris/mpm/patch-solaris-143513-02-1.sparc-solaris-patch.mpm:
>>>> Error 500 (500)
>>>> Waiting 1 seconds and trying again...
>>>> Internal server error 500 Internal Server Error
>>>>
>>>> SQLStatementPrepareError: ('column "\'1.4 REV=2006.03.29\'" does not
>>>> exist\nCONTEXT:  Error occurred on dblink connection named "at_conn":
>>>> could not execute command.\nSQL statement "SELECT
>>>> dblink_exec(\'at_conn\',  $1 , true)"\nPL/pgSQL function
>>>> "pg_dblink_exec" line 4 at PERFORM\nSQL statement "SELECT
>>>> pg_dblink_exec( \'insert into rhnPackageEVR(id, epoch, version,
>>>> release, evr) values (\' ||  $1  || \', \' || coalesce(quote_literal(
>>>> $2 ), \'NULL\') || \', \' || coalesce(quote_literal( $3 ), \'NULL\')
>>>> || \', \' || coalesce(quote_literal( $4 ), \'NULL\') || \', \' ||
>>>> evr_t(coalesce(quote_literal( $2 ), \'NULL\'), coalesce(quote_literal(
>>>> $3 ), \'NULL\'), coalesce(quote_literal( $4 ), \'NULL\')) || \')\'
>>>> )"\nPL/pgSQL function "lookup_evr" line 14 at PERFORM\n', 0, 'select
>>>> LOOKUP_EVR(%(epoch)s, %(version)s, %(release)s) id from dual')
>>>>
>>>> I attached the complete stack trace.
>>>>
>>>> Any help would be greatly appreciated!
>>>
>>> Please update your lookup_evr in psql with the version from commit
>>> d13b56bc04cb17f7f7cf2ca40b98602547f85adb -- that should fix it.
>>>
>>> Thank you,
>>>
>>> --
>>> Jan Pazdziora
>>> Principal Software Engineer, Satellite Engineering, Red Hat
>>>
>>> _______________________________________________
>>> Spacewalk-list mailing list
>>> Spacewalk-list at redhat.com
>>> https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
From 947cb65ff241b2984e9c0762d62e1f39eaf2dcaa Mon Sep 17 00:00:00 2001
From:  <root at tu-spa-d15.cst.cnes.fr>
Date: Wed, 4 Jul 2012 11:34:31 +0000
Subject: [PATCH] cross-database references are not implemented: pe.evr.as_vre_simple

---

 .../rhn/RHN/DB/DataSource/xml/System_queries.xml   |    4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
index 805589a..89b388e 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -1191,7 +1191,7 @@ ORDER BY S.name, S.id
   <elaborator params="pid" multiple="t">
 SELECT SPP.server_id AS ID,
        PN.name AS PACKAGE_NAME,
-       PN.name || '-' || PE.evr.as_vre_simple() AS PACKAGE_NVRE,
+       PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS PACKAGE_NVRE,
        PN.id || '|' || PE.id AS PACKAGE_ID_COMBO
   FROM rhnPackageName PN,
        rhnPackageEVR PE,
@@ -1237,7 +1237,7 @@ ORDER BY S.name, S.id
   <elaborator params="pid" multiple="t">
 SELECT DISTINCT S.id,
        PN.name AS PACKAGE_NAME,
-       PN.name || '-' || PE.evr.as_vre_simple() AS PACKAGE_NVRE,
+       PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS PACKAGE_NVRE,
        PN.id || '|' || PE.id AS PACKAGE_ID_COMBO
   FROM rhnPackageName PN,
        rhnPackageEVR PE,
--
1.7.4.1