My Oracle Support Banner

Model Patch Failed with a "Patch #### could not be committed. Error: -1" (Doc ID 2433422.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Utilities Network Management System - Version to [Release 2.3]
Oracle Network Management for Utilities - DMS - Version to [Release 2.3]
Information in this document applies to any platform.


On : Oracle Network Management System (NMS), version,

Issue posting a update to the model.  The $OPERATIONS_MODELS/errors/Patch###.log ended with


Message: <CODE> location: MBService::submit Severity: E
  Patch #### could not be committed. Error: -1
  Time: 07/16/18 10:28

Inspection of the MBDBService log did uncover a failed update:

07/18/18 08:26:50: dbrdwr:22433
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'update diagram_objects do  set do.ll_geometry = sdo_cs.transform(    do.geo_geometry,8307)  where = 'Y'  and ( SDO_GEOM.RELATE( do.ll_geometry, 'EQUAL', sdo_cs.transform(    do.geo_geometry,8307),0.1) = 'FALSE' or do.ll_geometry is null)   and do.geo_geometry is not null  and do.partition = 123123;'
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-13199: Unable to bind end
ORA-29400: data cartridge error
ORA-01036: illegal variable name/number
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 523





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

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