Product(s):	Exor Street Gazetteer Manager
	Version(s):	N/A
	Environment:	4.5
	Area:	N/A
	Subarea:	N/A

In NSG Loader batches error message “ESU could not be re-opened. ORA-20000: NET-0012. End date is out of range of parent.” appears in Records tab as shown in screenshot below

Steps to Accomplish

1. run script below

SELECT s.ne_number     USRN,
       S.NE_START_DATE str_start_date,
       s.ne_end_date   str_end_date,
       E.NE_DESCR      ESU,
       E.NE_START_DATE esu_start_date,
       E.NE_END_DATE   esu_end_date
  FROM nm_elements_all s, nm_elements_all e, nm_members_all
 WHERE     nm_ne_id_in = s.ne_id
       AND nm_ne_id_of = e.ne_id
       AND e.ne_descr = 'NNNN';

         replace NNNN with ESU id

2. go to Street Gazetteer Manager> Data> NSG Gazetteer, query back street with USRN selected in step1 and check if ESU id is listed in ESU's tab.

If yes, then you can ignore this message. Otherwise send all information to Bentley Support.

Original Author:

NT