Migration Error During Ces_setup.ces (Doc ID 2823979.1)

Last updated on NOVEMBER 30, 2021

Applies to:

Goal

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:

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

Solution

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