My Oracle Support Banner

Running "ces_setup.ces -clean" Resets SEQ_USER_PERMISSION Causing Unique Constraint Violations on USER_PERMISSION_PK When product_login.sql Run (Doc ID 2170983.1)

Last updated on MARCH 23, 2019

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 to 2.3.0.0.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 to 2.3.0.0.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.

Symptoms

On : 1.12.0.3 version, Installation

Following a ces_setup.ces -clean (optionally with -reset), attempting to reload project or product_ceslogin.sql generates:

A sql statement or a block of plsql statements failed at input file line 22
 error = ORA-00001: unique constraint (NMS1.USER_PERMISSION_PK) violated

It transpires that a clean setup runs ces_apply_migrations.ces AFTER loading the config, which runs ces_omsutils.sql which always recreates the SEQ_USER_PERMISSION sequence. I don't believe it should always perform this.

A sql statement or a block of plsql statements failed at input file line 22
 error = ORA-00001: unique constraint (NMS1.USER_PERMISSION_PK) violated

The issue can be reproduced at will with the following steps:
1. Run "ces_setup.ces -clean"
2. Run ISQL.ces product_ceslogin.sql
3. Observe the error.



Cause

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
Symptoms
Changes
Cause
Solution
References


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