Spatial Errors (MBS-01087) in MBService Log After Model Build (Doc ID 2600214.1)

Last updated on JUNE 05, 2023

Applies to:

Goal

 MBService displays spatial related error message:

 0xb32,ctp=1103b1a68,"MBService::build" **ERROR** Message: MBS-01087 location: Spatializer::updatePartitionSpatialValues severity: E
 Database error updating spatial values for partition 1640, coordinate system 0.

Or, the MBService log has these errors:

 0x7f4f28872700,ctp=0x7f4f200037e8,"MBService::build" **ERROR** MBService::updatePartitionSpatialValues statement failed (-1): update diagram_objects do  set do.geo_geometry =mdsys.sdo_geometry(2002,41100,NULL,   mdsys.sdo_elem_info_array(1,2,1),   CAST(MULTISET(SELECT pc.COLUMN_VALUE       FROM point_coordinates pc,            TABLE(mdsys.sdo_ordinate_array(pc.x_coord,pc.y_coord)) pc       WHERE pc.h_cls = do.h_cls       and pc.h_idx = do.h_idx       and pc.partition = do.partition       and pc.diagram_id = do.diagram_id       and pc.active in ('Y','A')        AND EXISTS (SELECT 1 FROM point_coordinates pc2 WHERE pc2.h_cls = pc.h_cls        AND pc2.h_idx = pc.h_idx AND pc2.active = pc.active        AND (pc2.x_coord != pc.x_coord OR pc2.y_coord != pc.y_coord))        ORDER BY pc.sequence, rownum)   AS mdsys.sdo_ordinate_array))      where do.h_cls in (0,443,426,413)        and do.partition = 1000        and do.active in ('Y','A')        and ( do.geo_geometry is null or               SDO_GEOM.RELATE(do.geo_geometry,'EQUAL', mdsys.sdo_geometry(2002,41100,NULL,   mdsys.sdo_elem_info_array(1,2,1),   CAST(MULTISET(SELECT pc.COLUMN_VALUE       FROM point_coordinates pc,            TABLE(mdsys.sdo_ordinate_array(pc.x_coord,pc.y_coord)) pc       WHERE pc.h_cls = do.h_cls       and pc.h_idx = do.h_idx       and pc.partition = do.partition       and pc.diagram_id = do.diagram_id       and pc.active in ('Y','A')        AND EXISTS (SELECT 1 FROM point_coordinates pc2 WHERE pc2.h_cls = pc.h_cls        AND pc2.h_idx = pc.h_idx AND pc2.active = pc.active        AND (pc2.x_coord != pc.x_coord OR pc2.y_coord != pc.y_coord))        ORDER BY pc.sequence, rownum)   AS mdsys.sdo_ordinate_array))        ,0.1) = 'FALSE' );
10/08/22 09:02:00: 0x7f4f28872700,ctp=0x7f4f200037e8,"MBService::build" **ERROR** Message:  MBS-00174      Location:  MBService::submit      Severity:  E
      Patch 1 could not be committed.  Error: -1

Solution

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