My Oracle Support Banner

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 to [Release 2.4 to 2.5]
Oracle Network Management for Utilities - DMS - Version to [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

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