My Oracle Support Banner

Migration Error During Ces_setup.ces (Doc ID 2823979.1)

Last updated on NOVEMBER 30, 2021

Applies to:

Oracle Utilities Network Management System - Version and later
Oracle Network Management for Utilities - DMS - Version and later
Information in this document applies to any platform.


This covers a scenario that may occur when adding a new licensed product, such as the Operations Mobile App (OMA), to an existing implementation.


Running a setup and encountered an error on a migration that was already run and listed as having been completed.  The error is

ISQL.ces loading /nms/nmsadmin/migration/sql/pr27025082_migration.sql
Converting generic sql file to ORACLE file /nms/nmsadmin/logs/tmp/isql.nmsadmin.5636780
Error converting sql file [/nms/nmsadmin/migration/sql/pr27025082_migration.sql] - Check sql file format.
A sql statement or a block of plsql statements failed at input file line 20
error = ORA-00001: unique constraint (NMS.MOBILE_PERMISSIONS_PK) violated
ORA-06512: at line 3

The failed statement or block of statements are:

   IF omsutil.table_exists('MOBILE_PERMISSIONS') THEN
           INSERT INTO mobile_permissions(
            VALUES (
           ''Allow as-user Parameter'', ''Allow restful service calls with the as-user parameter where available'')


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.