Product(s):	Exor Street Gazetteer Manager
	Version(s):	04.05.00.29
	Environment:	N\A
	Area:	NSG Gazetteer
	Subarea:	N\A

Error or Warning Message

When attempting to re-open a closed street in the Gazetteer form (NSG-0010), this error message appears and prevents the re-open completing:

NET-0107: Invalid type of node for network type. : start

Explanation

This normally occurs on streets closed some time ago and is probably because the start and end nodes of the street have been end-dated.

How to Avoid

To find out if the nodes are end-dated, log into SQL*Plus / SQL*Developer / TOAD as the Highways owner user and run the following query, entering the street USRN when prompted:

select no_node_name, no_start_date, no_end_date
from nm_nodes_all
where no_node_id in (SELECT ne_no_start
FROM nm_elements_all
WHERE ne_number = '&USRN'
UNION ALL
SELECT ne_no_end
FROM nm_elements_all
WHERE ne_number = '&USRN');

If any do have an end date, run this to remove it:

UPDATE nm_nodes_all
   SET no_end_date = NULL
 WHERE no_node_id IN (SELECT ne_no_start
                        FROM nm_elements_all
                       WHERE ne_number = '&USRN'
                      UNION ALL
                      SELECT ne_no_end
                        FROM nm_elements_all
                       WHERE ne_number = '&USRN');

 If the update runs without error, type COMMIT; to make the change permanent and try re-querying and re-opening the street again.  If there were any errors, or there aren't any end-dated nodes type ROLLBACK; and contact Support with full details to investigate further.

If the issue still exists though the update command above has been run successfully then un-end-dating a particular section (setting end_date to NULL in NM_ELEMENTS_ALL table) resolves the issue.

Original Author:

Sarah Williams