The following exception is generated when attempting to install a package on a system, which is a pretty basic function for Spacewalk. I believe it was reported before at https://www.redhat.com/archives/spacewalk-list/2011-November/msg00055.html.
[Thu Jan 12 11:12:34 2012] [error] Execution of /var/www/html/network/software/packages/install_confirm.pxt failed at Thu Jan 12 11:12:34 2012: RHN::Exception: DBD::Pg::st execute failed: ERROR: function evr_t(unknown, integer, integer) does not exist\nLINE 23: AND SP.evr_id = PE.id), EVR_T(NULL, 0, ...\n ^\nHINT: No function matches the given name and argument types. You might need to add explicit type casts.\n RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 228 Gurjeet Singh suggested a fix for the instantiation of the EVR_T at: http://www.redhat.com/archives/spacewalk-devel/2009-February/001536.html --- Scheduler.pm.orig 2012-01-06 08:05:25.000000000 -0500 +++ Scheduler.pm 2012-01-12 11:49:27.820683130 -0500 @@ -660,7 +660,7 @@ FROM rhnServerPackage SP, rhnPackageEvr PE WHERE SP.name_id = P.name_id AND SP.server_id = S.id - AND SP.evr_id = PE.id), ${rhn_class}EVR_T(NULL, 0, 0)) + AND SP.evr_id = PE.id), ${rhn_class}(NULL, 0, 0)::EVR_T) < (SELECT EVR FROM rhnPackageEVR PE WHERE PE.id = P.evr_id) ) Fixing DB/Scheduler.pm gets around that issue and EVR_T is instantiated fine. However, a new issue pops up: [Thu Jan 12 11:49:37 2012] [error] Execution of /var/www/html/network/software/packages/install_confirm.pxt failed at Thu Jan 12 11:49:37 2012: RHN::Exception: DBD::Pg::st execute failed: ERROR: function nvl(evr_t, evr_t) does not exist\nLINE 19: AND ( (NVL((SELECT MAX(PE.evr)\n ^\nHINT: No function matches the given name and argument types. You might need to add explicit type casts. Any input? How to reproduce: - Go to a package - Go to target systems - Select any number of systems - Confirm - Exception occurs after the final confirmation /aron _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel