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
Time: Tue Apr 12 16:16:15 2011
Exception type .server.rhnSQL.sql_base.SQLStatementPrepareError
Exception while handling function queue.submit
Request object information:
URI: /XMLRPC
Remote Host: gdmsdwk11.vancpower.com
Server Name: idmssat00.vancpower.com:0
Headers passed in:
Accept-Encoding: identity
Content-Length: 3088
Host: idmssat00.vancpower.com
content-type: text/xml
user-agent: rhn.rpclib.py/$Revision$
x-client-version: 1
x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
x-rhn-client-capability:
osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1
x-rhn-transport-capability: follow-redirects=3
x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc
(version $Revision$)
x-up2date-version: 1.3.12-1.el5
Extra information about this error:
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, '-MM-DD HH24:MI:SS'),
TO_DATE(:process_end, '-MM-DD HH24:MI:SS'), :return_code from
rhnActionScript ascript where ascript.action_id = :action_id returning output
into :output_blob")
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages//server/apacheRequest.py",
line 119, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 467, in submit
action_type=action_type)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 512, in
process_extra_data
result = method(self.server_id, action_id, data=data)
File
"/usr/lib/python2.4/site-packages//server/action_extra_data/script.py",
line 83, in run
output=output
File
"/usr/lib/python2.4/site-packages//server/rhnSQL/sql_base.py", line
163, in execute
return apply(self._execute_wrapper, (self._execute, ) + p, kw)
File
"/usr/lib/python2.4/site-packages//server/rhnSQL/driver_cx_Oracle.py",
line 116, in _execute_wrapper
raise apply(sql_base.SQLStatementPrepareError, args)
SQLStatementPrepareError: ('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, '-MM-DD HH24:MI:SS'),
TO_DATE(:process_end, '-MM-DD HH24:MI:SS'), :return_code from
rhnActionScript ascript where ascript.action_id = :action_id returning output
into :output_blob")
Local variables by frame
Frame _execute_wrapper in
/usr/lib/python2.4/site-packages//server/rhnSQL/driver_cx_Oracle.py
at line 116
orig_blob_var = output
function = @//localhost/XE>>>
e = ORA-00933: SQL command not
properly ended
errno = 933
new_blob_var = output_blob
args = (933, 'ORA-00933: SQL command not
properly ended\n', "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, '-MM-DD
HH24:MI:SS'), TO_DATE(:process_end, '-MM-DD HH24:MI:SS'), :return_code from
rhnActionScript ascript where ascript.action_id = :action_id returning output
into :output_blob")
modified_params = []
value = 1067
p = ()
params = 'server_id':
110029,'process_end': '2011-04-12 16:16:14','return_code': 0,'output':
"make: Entering directory `/etc/mail'\nmake: Nothing to be done for
`all'.\nmake: Leaving directory `/etc/mail'\nShutting down sm-client: [ OK
]\r\nShutting down sendmail: [ OK ]\r\nStarting sendmail: [ OK
]\r\nStarting sm-c