Foreign Key SWMAN_STEP__CONTROL_ACT Causing Errors During Setup (Doc ID 2724479.1)

Last updated on NOVEMBER 19, 2020

Applies to:

Goal

Runnin ces_setup.ces -offline.    Several foreign keys get added to the SWMAN_STEP table by product_retain_web_swsheets.sql,
and then the insert to SWMAN_STEP for the Misc Log

Subsequent runs of ces_setup.ces fail  trying to run product_control.sql because the delete from CONTROL_ACT fails because of the SWMAN_STEP_CONTROL_ACT foreign key. Then every attempted insert into CONTROL_ACT fails due to unique constraint violations.


I was wondering why I didn't see this in an OPAL environment, and there the SWMAN_STEP table didn't have any foreign keys on it.
I ran ces_setup.ces -offline there, and my SWMAN_STEP table still didn't have any foreign keys on it.
It didn't get the foreign keys until I ran product_retain_web_swsheets.sql by hand on it.

Running that in by hand caused the insert to SWMAN_STEP for the Misc Log stuff to fail.
So, subsequent runs of ces_setup.ces in OPAL did not produce the errors with CONTROL_ACT because there are no rows in SWMAN_STEP.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.