Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki NSG Loader: ESU could not be re-opened. ORA-20000: NET-0012. End date is out of range of parent.
    • Sign In
    • -Exor - Wiki
      • +ALIM Document Manager
      • An Attempt to Reset Your Password Has Failed
      • +AWLRS
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • +Exor Network Manager
      • +Exor Oracle
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • -Exor Street Gazetteer Manager
        • Cannot see usrns on map
        • Change Datasource Name setting
        • +Export - Exor Street Gazetteer Manager
        • -Import - Exor Street Gazetteer Manager
          • Batch of NSG files not loading
          • District details do not update when OD file is loaded
          • Exor NSG Error Loading Gazetter
          • How to load an OD File
          • Load Does Not Start
          • NSG batch load, ORA-06519: active autonomous transaction detected and rolled back
          • NSG batch load: Interested Authority does not exist as an Organisation.
          • NSG load "ORA-01555: snapshot too old....."
          • NSG Load error: "OD101.001 Dist_Ftp_Directory Is Null”
          • NSG load not updated street data
          • NSG Load: ORA-20001: HIG-0197: SDO Metadata for layer not found
          • NSG LOAD: Gazetteer load times have doubled
          • NSG load: how to find the error message.
          • NSG loader not running
          • NSG Loader: ESU could not be re-opened. ORA-20000: NET-0012. End date is out of range of parent.
          • NSG Loader: File cannot be used.
          • NSG0040 NSG Loader Batches: ORA-2001 HIG-0197: SDO Metadata for layer not found
          • OD file does not load properly
          • ORA-29532 in NSG Loader Batches form
          • ORA-29913 error when loading gazetteer files
        • +Install/Upgrade - Exor Street Gazetteer Manager
        • +NSG Gazetteer - Exor Street Gazetteer Manager
        • NSG: Unable to load NSG batch, process hangs on Type 17.
        • Route ASD data not loaded
        • Street gazetteer files failed Geoplace validation
        • Unable to view Type 13 records following an NSG load
        • Unable to view Type 14 records in the load summary
        • User cannot delete/remove ESU within USRN
      • Exor Streetworks Manager
      • Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • Remove @ from the AWLRS Local Password Policy
      • +Transportation Intelligence Gateway
      • Unable to connect to Power BI dataset
      • +Video Series for Exor
      • Working From Home with Exor
    • +AssetWise ALIM for Transportation
    • How To Import SSL Certificate 11g Weblogic

     
     Questions about this article, topic, or product? Click here. 

    NSG Loader: ESU could not be re-opened. ORA-20000: NET-0012. End date is out of range of parent.

      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

    1. 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
    • NSG LOADER
    • NET-0012
    • Share
    • History
    • More
    • Cancel
    • NT Created by Bentley Colleague NT
    • When: Thu, Nov 22 2018 4:51 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Thu, Mar 21 2019 9:18 AM
    • Revisions: 5
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies