If a Patch Fails With Error MBS-01087, Restarting MBService Fails and Results in Error MBS-00210 (Doc ID 2882746.1)

Last updated on SEPTEMBER 02, 2022

Applies to:

Symptoms

On : 2.4.0.1.0 version, NMS Infrastructure

When attempting to build a certain map, the patch failed and MBService showed these errors:

07/07/22 15:55:15: MBService 0x7f9d65c8b700,ctp=0xeb2ec58,"MBService::build" **ERROR** MBService::updatePartitionSpatialValues statement failed (-1): update diagram_objects do  set do.ll_geometry = sdo_cs.transform(    do.geo_geometry,8307)  where do.partition = 17552  and do.active in ('Y','A')  and do.geo_geometry is not null  and ( do.ll_geometry is null or     SDO_GEOM.RELATE( do.ll_geometry, 'EQUAL', sdo_cs.transform(      do.geo_geometry,8307),0.1) = 'FALSE' );
07/07/22 15:55:15: MBService 0x7f9d65c8b700,ctp=0xeb2ec58,"MBService::build" **ERROR** Message:  MBS-01087      Location:  Spatializer::updatePartitionSpatialValues      Severity:  E
      Database error updating spatial values for partition 17552, coordinate system 0.

07/07/22 15:55:15: MBService 0x7f9d65c8b700,ctp=0xeb2ec58,"MBService::build" **ERROR** MBService::updatePartitionSpatialValues statement failed (-1): update diagram_objects do  set do.ll_geometry = sdo_cs.transform(    do.geo_geometry,8307)  where do.partition = 17552  and do.active in ('Y','A')  and do.geo_geometry is not null  and ( do.ll_geometry is null or     SDO_GEOM.RELATE( do.ll_geometry, 'EQUAL', sdo_cs.transform(      do.geo_geometry,8307),0.1) = 'FALSE' );
07/07/22 15:55:15: MBService 0x7f9d65c8b700,ctp=0xeb2ec58,"MBService::build" **ERROR** Message:  MBS-01087      Location:  Spatializer::updatePartitionSpatialValues      Severity:  E
      Database error updating spatial values for partition 17552, coordinate system 0.

07/07/22 15:55:16: MBService 0x7f9d65c8b700,ctp=0xeb2ec58,"MBService::build" **ERROR** Message:  MBS-00174      Location:  MBService::submit      Severity:  E
      Patch 73182 could not be committed.  Error: -1

When MBService was restarted the next day, it failed with these errors:

07/08/22 11:15:33: MBService 0x7fe7ad9dc700,ctp=0x1544928,"MBService::baseInitialize" AlternateViewManager::load()
07/08/22 11:15:43: MBService 0x7fe7ad9dc700,ctp=0x1544928,"MBService::baseInitialize" **ERROR** Message: MBS-00210 Location: AlternateViewManager::load Severity: E
  No active rows found in table network_components for object [DEVICE HANDLE 1].

07/08/22 11:15:43: MBService 0x7fe7ad9dc700,ctp=0x1544928,"MBService::baseInitialize" **ERROR** Message: MBS-00210 Location: AlternateViewManager::load Severity: E
  No active rows found in table network_components for object [DEVICE HANDLE 2].

07/08/22 11:15:43: MBService 0x7fe7ad9dc700,ctp=0x1544928,"MBService::baseInitialize" **ERROR** Message: MBS-00210 Location: AlternateViewManager::load Severity: E
  No active rows found in table network_components for object [DEVICE HANDLE 3].

07/08/22 11:15:43: MBService 0x7fe7ad9dc700,ctp=0x1544928,"MBService::baseInitialize" **FATAL** Message: MBS-00193 Location: MBService::initialize Severity: F
  Unable to load alternate views.

07/08/22 11:15:43: MBService 0x7fe7ad9dc700,ctp=0x1544928,"MBService::baseInitialize" **INFO*** [MBService-18368] for [HOSTNAME] exiting...

The issue can be reproduced at will with the following steps:
(These steps cannot be manually reproduced)
1. Build a map that deletes the primary view of an object and promotes an alternate view, but the patch then fails in spatializePatch()
2. Restart MBService
3. It will give errors MBS-00210 and MBS-00193

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.