Network Disappears upon selection

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




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


 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.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:


l_shape mdsys.sdo_geometry;

l_last integer;


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>;



Alternatively, please contact support for further assistance.