[Spacewalk-list] error creating new kickstart profile

[Michael Mraka]

% I'm setting up a new spacewalk server for the first time (v1.3 on F14),
% and following along in the documentation until I get more oriented. I'm
% on to the directions at
% https://fedorahosted.org/spacewalk/wiki/HowToKickstartCobbler
% 
% Creating a cobbler distro went fine, but I hit a snag while creating the
% kickstart profile for the distro. My steps are below.
...
% 2011-03-29 13:57:59,999 [TP-Processor2] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 2F005
% 2011-03-29 13:58:00,000 [TP-Processor2] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: control reached end of trigger procedure without RETURN
%   Where: PL/pgSQL function "rhn_ks_session_history_trigger_fun"
% 2011-03-29 13:58:00,000 [TP-Processor2] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not insert: [com.redhat.rhn.domain.kickstart.KickstartSession]

rhn_ks_session_history_trigger_fun issue has been fixed in nightly by
http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=a14b2f07e579a3d47aac1f76006f8f7f9f767ca9

As for current Spacewalk 1.3 installation - you can fix it manually by applying 
http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/007-rhn_ks_session_history_trigger_fun.sql.postgresql;h=cce4dab8d438a80cc384fb77464b72bc6b573deb;hb=a14b2f07e579a3d47aac1f76006f8f7f9f767ca9
directly to your postgresql schema.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat