Seed data fails with ORA-02298 MDBADMIN.USM_R_R0000186B00000000

Products

• CA Service Catalog

Issue/Introduction

seed-data.log contains below error:

20XX/01/08 14.59.05.280 ERROR Exception while communicating with the database:ORA-20000: Error: ORA-02298: cannot validate (MDBADMIN.USM_R_R0000186B00000000) - parent keys not found 
ORA-06512: at "MDBADMIN.USM_TOGGLE_FK_TRIGGER_SP", line 69 
ORA-06512: at line 1

Environment

Release:  17.x
Component: CA Service Catalog (Oracle MDB)

Cause

Check if the tables below have needed data in them

select * from usm_task 
select * from usm_runtime_component 

The reason why such an error surfaces is because there are 0 records in usm_rumtime_component table, while usm_task has some records with Scheduler as the runtime_component. 

Resolution

To fix this, records that exist in usm_task needs to be inserted into usm_runtime_component
 

insert into usm_runtime_component 
VALUES ('Scheduler',NULL,NULL,NULL,NULL,NULL) 
commit 

 
Now enable the foreign keys again by:

call USM_TOGGLE_FK_TRIGGER_SP('ALL','ENABLE')