[Spacewalk-list] Error populating database

[Michael Mraka]

Benedetto Vassallo wrote:
% Hi people,
% I am doing a fresh installation of spacewalk 1.1 and spacewalk-setup
% --disconnected fails populating database.
% 
% /var/log/rhn/populate_db.log says the following:
% 
% SQL> insert into
% rhn_schedule_days(recid,schedule_id,ord,start_1,end_1,start_2,
%   2  end_2,start_3,end_3,start_4,end_4,last_update_user,last_update_date)
%   3      values ( rhn_schedule_days_recid_seq.nextval,
%   4        ( select recid from rhn_schedules where customer_id is null and
% description = '24x7' ),0,
%   5      to_date('08-SEP-2000 12:00:02 AM','DD-MON-YYYY HH:MI:SS AM'),
%   6      to_date('09-SEP-2000 12:00:00 AM','DD-MON-YYYY HH:MI:SS AM'),
%   7      null,null,null,null,null,null,'system',null);
%     to_date('08-SEP-2000 12:00:02 AM','DD-MON-YYYY HH:MI:SS AM'),
%             *
% ERROR at line 5:
% ORA-01843: invalid month
% 
% Any idea?

Wrong NLS_LANG.

Anyway I changed it to ISO date format which is independent of NLS_LANG
settings.


% Thanks

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat