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

Last updated on JUNE 02, 2024

Applies to:

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

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