[Spacewalk-list] Error During Remote Command

[Jan Pazdziora]

On Thu, Aug 25, 2011 at 10:59:37AM -0600, Jeremy Davis wrote:
> Hello List,
> 
> We are updating some password hashes on our servers using Spacewalk and for
> some reason I started receiving traceback error logs when performing remote
> commands on the servers. The following is a SQL error from the Traceback. If
> you need the full traceback let me know I will need to remove all company
> related information which might take some time :).
> 
> SQL Error generated: (1400, 'ORA-01400: cannot insert NULL into
> ("SPACEWALK"."RHNSERVERACTIONSCRIPTRESULT"."START_DATE")\n', "insert into
> rhnServerActionScriptResult ( server_id, action_script_id, output,
> start_date, stop_date, return_code ) values ( :server_id, (select
> ascript.idfrom rhnActionScript ascript where ascript.action_id =
> :action_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) returning
> output into :output_blob")
> 
> Any ideas as to what is going on here?

Can you schedule the remote command and pick it up with

	rhn_check -vv

? We'd need to figure out why that process_start value is not set.

Also, more info about when/where it happens (after Spacewalk upgrade,
after client upgrades, only some OS, is this nightly or released code
on server and client) would be useful.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat