My Oracle Support Banner

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

Last updated on JULY 02, 2021

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

For releases 2.5.0.0 and later, running "nms-setup" results in this error:

ISQL loading [$NMS_SQL_FILES]/nms_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.

 

For releases 2.4.0.1 and earler, running "ces_setup.ces results in this error:

ISQL.ces loading[$CES_SQL_FILES]/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

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
Symptoms
Changes
Cause
Solution
References


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