Ora-29532 Edge Id 337 Not Found In Cache In Sdo_topo_map.Move_node (Doc ID 1392555.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 10.2.0.4 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms


Moving a node results in ORA-29532


SDO_TOPO_MAP.MOVE_NODE('MOVEND',206,myedgearr);
ORA-29532: Java call terminated by uncaught Java exception:
oracle.spatial.topo.TopoEntityNotFoundException: Edge ID 337 not found in cache


1. For some moves sdo_topo_map.move_node will only succeed when the entire topology is in cache:
SDO_TOPO_MAP.CREATE_TOPO_MAP('MOVEND','MOVENDMAP');
SDO_TOPO_MAP.LOAD_TOPO_MAP('MOVENDMAP', 'TRUE','TRUE');
SDO_TOPO_MAP.MOVE_NODE(NULL,206,myedgearr);

2.The error is thrown when move_node is called with the signature that includes the topology name:
MOVE_NODE('MOVEND',206,myedgearr);

3.The error is also thrown with a NULL topology and a topomap that includes a reasonable window

4.The edge id identified in the error is not near the node or edges being moved by the move_node call

Cause

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 hundreds of Community platforms