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 APRIL 26, 2017

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 and later
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 and later
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.



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms