[Spacewalk-list] Database Error: Oracle 11g

Eric linux_4_u at yahoo.com
Fri Feb 19 18:45:05 UTC 2010


A colleague of mine is trying to setup the database manually (don't ask why) using rhn/oracle/main.sql from spacewalk-schema-0.8.12-1.el5.noarch.rpm.

Trying to populate the database on Oracle 11g (11.2.0.1.0) and he is getting the following error:

SQL> INSERT INTO rhn_schedule_days
  2       (recid, schedule_id, ord, start_1, end_1, start_2, end_2, start_3, end_3, start_4, end_4, last_update_user, last_update_date)
  3  VALUES
  4       (rhn_schedule_days_recid_seq.nextval, 1, 0, to_date('08-SEP-2000 12:00:02 AM', 'DD-MON-YYYY HH:MI:SS AM'), to_date('09-SEP-2000 12:00:00 AM', 'DD-MON-YYYY HH:MI:SS AM'), null, null, null, null, null, null, 'system', null);
INSERT INTO rhn_schedule_days
*
ERROR at line 1:
ORA-02291: integrity constraint (RHNSAT.RHN_SCHDY_SCHED_SCHEDULE_ID_FK) violated - parent key not found

Any ideas?

Thanks,

-Eric



      




More information about the Spacewalk-list mailing list