Model Build is Failing with "GEO_GEOMETRY": invalid identifier error (Doc ID 1573537.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.11.0.4 and later
Oracle Network Management for Utilities - DMS - Version 1.11.0.4 and later
Information in this document applies to any platform.

Symptoms

An update to a new patch bundle has apparently caused the model build to stop working.  There are several ORACLE_ERRORs reported in the MBDBService log during the build:

-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'alter index diagram_objects_geo_idx parameters  ('index_status=deferred')'
ORA-01418: specified index does not exist
parse offset = 0
07/29 10:58:44: 0x7f357b3f1700,ctp=0x7f356800ea08,"sql" sql error: (alter index diagram_objects_geo_idx parameters  ('index_status=deferred')) from (1/93:3759.0), result=-1 ORA-01418: specified index does not exist

07/29 10:58:45: dbrdwr:27889
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'update diagram_objects set geo_geometry = SDO_GEOMETRY(2001, :geo_srid, SDO_POINT_TYPE(1913898.084678,14548530.254099, NULL), NULL, NULL) where h_cls = 15021 and h_idx = 205800 and diagram_id = 11625 and active in ('Y', 'A')  and birth_patch = 239863 and partition = 11625'
ORA-00904: "GEO_GEOMETRY": invalid identifier
parse offset = 27[geo_geometry = SDO_]
07/29 10:58:44: 0x7f357b454700,ctp=0x7f3560041098,"sql" sql error: ( update diagram_objects set geo_geometry = SDO_GEOMETRY(2001, :geo_srid, SDO_POINT_TYPE(1913898.084678,14548530.254099, NULL), NULL, NULL) where h_cls = 15021 and h_idx = 205800 and diagram_id = 11625 and active in ('Y', 'A')  and birth_patch = 239863 and partition = 11625) from (1/93:3759.0), result=-1 ORA-00904: "GEO_GEOMETRY": invalid identifier

Changes

 A patch bundle was applied and the customer-specific configuration files were updated.

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