Running ces_setup.ces Fails With ORA-1720 Error
(Doc ID 1935856.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Network Management for Utilities - DMS - Version 188.8.131.52 to 184.108.40.206 [Release 1.12]
Oracle Utilities Network Management System - Version 220.127.116.11 to 18.104.22.168 [Release 1.12]
Information in this document applies to any platform.
When attempting to install NMS 22.214.171.124, ces_setup.ces fails on the file "product_schema_web_swsheets.sql".
The log file shows this:
ISQL.ces loading /opt/nms/nmsadmin/sql/product_schema_web_swsheets.sql Converting generic sql file to ORACLE file /opt/nms/nmsadmin/logs/tmp/isql.zdnmsadm.26005 Error converting sql file [product_schema_web_swsheets.sql] - Check sql file format. A sql statement or a block of plsql statements failed at input file line 203 error = ORA-01720: grant option does not exist for 'SYS.DUAL'
The failed statement or block of statements are:
CREATE OR REPLACE VIEW att_address (h_cls, h_idx, att_name, att_value) AS ( SELECT 0, 0, 'None', 'None - Need Project Version of View.' FROM dual ); 10/06 16:59:04: 0x7f7eb3739720,ctp=0x14b0bf8,"" cessql failed! ISQL Error encountered in file product_schema_web_swsheets.sql. ERROR A sql statement or a block of plsql statements failed at input file line 203 error = ORA-01720: grant option does not exist for 'SYS.DUAL'
The issue can be reproduced at will with the following steps:
Due to this issue, users cannot install the software
The Oracle RDBMS database was recently upgraded to 126.96.36.199.0
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