ORA-01422 Error When Running ces_setup.ces (Doc ID 2277255.1)

Last updated on JUNE 15, 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

Running ces_setup.ces results in this error:



ISQL.ces loading /home/nmsadmin/sql/product_ces_customers_updated_service_alert.sql

...
ERROR at line 1:
ORA-20001: An error was encountered - ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 86
....
ISQL Error encountered in file product_ces_customers_updated_service_alert.sql.






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