My Oracle Support Banner

Spatialize Command Fails With "ORA-01031: insufficient privileges" Error (Doc ID 2871396.1)

Last updated on MAY 23, 2022

Applies to:

Oracle Utilities Network Management System - Version 2.5.0.1.0 to 2.5.0.2.0 [Release 2.5]
Information in this document applies to any platform.

Symptoms

On : 2.5.0.1.0 version, Installation

Running the command "Spatialize -resetgeometryconnections" fails and these errors appear in the DBService log:

 

04/18/22 10:11:17: dbrdwr:50422
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'drop index diagram_objects_ll_idx;'
ORA-01418: specified index does not exist
parse offset = 11[diagram_objects_ll_]
04/18/22 10:11:17: 0x7fda0982d700,ctp=0x159b698,"sql" sql error: (drop index diagram_objects_ll_idx;) from (1/4:42691.0), result=-1
ORA-01418: specified index does not exist

04/18/22 10:11:17: dbrdwr:50422
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'ALTER TABLE diagram_objects DROP COLUMN
LL_GEOMETRY;'
ORA-00942: table or view does not exist
parse offset = 0
04/18/22 10:11:17: 0x7fda09729700,ctp=0x159b698,"sql" sql error: (ALTER TABLE
 diagram_objects DROP COLUMN LL_GEOMETRY;) from (1/4:42691.0), result=-1
ORA-00942: table or view does not exist

04/18/22 10:11:17: dbrdwr:50422
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'ALTER TABLE diagram_objects ADD (LL_GEOMETRY
MDSYS.SDO_GEOMETRY)'
ORA-00942: table or view does not exist
parse offset = 0
04/18/22 10:11:17: 0x7fda06bb0700,ctp=0x159b698,"sql" sql error: (ALTER TABLE
 diagram_objects ADD (LL_GEOMETRY MDSYS.SDO_GEOMETRY)) from (1/4:42691.0), result=-1
 ORA-00942: table or view does not exist

04/18/22 10:11:17: dbrdwr:50422
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'create index diagram_objects_ll_idx on
diagram_objects(ll_geometry) indextype is MDSYS.SPATIAL_INDEX;'
ORA-01031: insufficient privileges
parse offset = 39[diagram_objects(ll_]
04/18/22 10:11:17: 0x7fda06bb0700,ctp=0x159b698,"sql" sql error: (create
index diagram_objects_ll_idx on diagram_objects(ll_geometry) indextype is
MDSYS.SPATIAL_INDEX;) from (1/4:42691.0), result=-1
ORA-01031: insufficient privileges


The issue can be reproduced at will with the following steps:

  1. Run "Spatialize -resetGeometryColumns"
  2. Check $NMS_LOG_DIR/DBS* for ORA errors

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
 Fix Description
 Migration
References


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