Foreign Key SWMAN_STEP__CONTROL_ACT Causing Errors During Setup
(Doc ID 2724479.1)
Last updated on NOVEMBER 19, 2020
Applies to:Oracle Utilities Network Management System - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 2.4 to 2.5]
Oracle Network Management for Utilities - DMS - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 2.4 to 2.5]
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document