[Spacewalk-list] Spacewalk 1.5, Remote Commands, ORA-00904: "X"."NAME": invalid identifier

[Michael Mraka]

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