Trevor T Kates wrote: % List: % % After upgrading to Spacewalk 1.5, the attached traceback is being generated % when attempting to run remote commands via the System Set Manager when any % number of systems is selected. The backend database serving this instance of % Spacewalk is Oracle11gR2 XE. I'm trying to pin down whether this is an issue % with Oracle11g, but at the moment, I don't have an Oracle10g instance available % on which to test. % % Any assistance with this is greatly appreciated.
Hi Trevor, it's been fixed in master by c6d8dda49e05d687116685c1642ea03069b6605d. Fixed package spacewalk-base-1.6.4-1 should land in nightly repo in a while. It's also possible to apply the patch manually. Thanks for the report. Regards, Michael ... % > Error message: % > RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00904: "X"."NAME": % > invalid identifier (DBD ERROR: error possibly near <*> indicator at char 614 in % > ' % > select * from ( % > SELECT DISTINCT S.id, % > S.name AS SERVER_NAME % > FROM rhnServer S, % > rhnClientCapabilityName CCN, % > rhnClientCapability CC, % > rhnSet ST, % > rhnUserServerPerms USP % > WHERE USP.user_id = :user_id % > AND ST.user_id = :user_id % > AND ST.label = 'system_list' % > AND USP.server_id = ST.element % > AND EXISTS(SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id = % > ST.element AND SFV.label = 'ftr_remote_command') % > AND USP.server_id = CC.server_id % > AND CC.capability_name_id = CCN.id % > AND CCN.name = 'script.run' % > AND USP.server_id = S.id % > ) X % > ORDER BY UPPER(COALESCE(<*>X.name, '(none)')), X.id -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list