Migration Error During Ces_setup.ces
(Doc ID 2823979.1)
Last updated on NOVEMBER 30, 2021
Applies to:Oracle Utilities Network Management System - Version 220.127.116.11.0 and later
Oracle Network Management for Utilities - DMS - Version 18.104.22.168.0 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
EXECUTE IMMEDIATE '
INSERT INTO mobile_permissions(
''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