My Oracle Support Banner

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

Last updated on AUGUST 16, 2018

Applies to:

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

Symptoms

On : 2.3.0.2.0 version,

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

 

Message: MBS-00174 location: MBService::submit Severity: E
  Device:
  Patch #### could not be committed. Error: -1
  Context:
  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 do.active = '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

 

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!


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