Network Disappears upon selection


  
 Applies To 
 Product(s):Exor SM Spatial Manager
 Version(s):ALL
 Environment: N/A
 Area: N/A
 Subarea: N/A
 Original Author:Bentley Technical Support Group
  

 

 

Problem

 Following a split action, the network does not appear within SM. 

Solution

 The reason for the issue is due to the geometry stored against the section, i.e. null values are being stored due to corruption of the data.  First, the ne_id needs to be obtained and used in the following query

select t.id, t.x, t.y, t.z
from <Spatial table>a, table (sdo_util.getvertices(GEOLOC)) t
where ne_id = <ne_id>;

Once you have confirmed some of coordinates contain null values, run the following to correct the issue:

declare

l_shape mdsys.sdo_geometry;

l_last integer;

begin

select geoloc into l_shape from <Spatial_Table>

where ne_id = 284762;

l_last := l_shape.sdo_ordinates.last;

l_shape.sdo_ordinates(l_last - 2 ) := <correct coordinates>;

l_shape.sdo_ordinates(l_last - 1 ) := <correct coordinates>;

update <Spatial_table>

set geoloc = l_shape

where ne_id = <ne_id>;

end;

commit;

Alternatively, please contact support for further assistance.