[Spacewalk-list] OSA-00933 on Remote Command

[Michael Mraka]

Trevor T Kates wrote:
% List:
% 
% Spacewalk Version: 1.4 RC
% OS Version: CentOS 5.6
% 
% Problem: Receiving attached error after scheduling remote command via web interface
% 
% Thank you for any assistance with this problem.
% 
% _______________________________________________________________________________
% Trevor T. Kates
% 
% Exception reported from idmssat00.vancpower.com
...
% SQL Error generated: ('ORA-00933: SQL command not properly ended\n', 933, "insert into rhnServerActionScriptResult ( server_id, action_script_id, output, start_date, stop_date, return_code ) select :server_id, ascript.id, empty_blob(), TO_DATE(:process_start, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:process_end, 'YYYY-MM-DD HH24:MI:SS'), :return_code from rhnActionScript ascript where ascript.action_id = :action_id returning output into :output_blob")


Hi Trevor,

this is an error in blob insert routine; I've fixed it both in master
and spacewalk-1.4 branch (spacewalk-backend-1.4.37-1).

Thanks for the report.
Regards,

--
Michael Mráka
Satellite Engineering, Red Hat