Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • More
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki ORA-01400 Error Loading NSG Gazetteer
    • Sign in
    • -Exor - Wiki
      • +AWLRS
      • Exor Accidents Manager
      • +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 create provisional street
        • Change Datasource Name setting
        • +Export - Exor Street Gazetteer Manager
        • +Import - Exor Street Gazetteer Manager
        • +Install/Upgrade - Exor Street Gazetteer Manager
        • +NSG Gazetteer - Exor Street Gazetteer Manager
        • NSG: Unable to load NSG batch, process hangs on Type 17.
        • ORA-01400 Error Loading NSG Gazetteer
        • Route ASD data not loaded
        • Some ESU's are missing when displaying Type 1 and 2 Streets Layer in Locator
        • Street gazetteer files failed Geoplace validation
        • Unable to load new OD file
        • 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 API and Web Service
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • ORA-20000: HIG-0230: Inconsistency detected error on login
      • +Transportation Intelligence Gateway
      • +Video Series for Exor
    • +ALIM Document Manager

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

    ORA-01400 Error Loading NSG Gazetteer

     

       
      Applies To 
       
      Product(s): Exor Street Gazetteer Manager
      Version(s): 04.05.00.00
      Environment:  N\A
      Area:  Import
      Subarea:  N\A
      Original Author: Lee Jackson, Bentley Technical Support Group
       

     

    Error or Warning Message

    When uploading NSG data into our test system, I have an error shown for several different autorities data.

    The Batch Schedule shows the following for example:

    14 | ASD Spatial Consolidation | Warning | ORA-01400: cannot insert NULL into ("EXOR"."NM_NIT_TP21_SDO"."GEOLOC")

    Explanation

    This messager is usually shown as the application can’t create a valid spatial shape for the record, causing it to try and insert a null value which then produces this error.

    If you open the Street Gazetteer Manager>Data>Administration>Generate ASD Placements NSG0025 form you can run a facility that checks the spatial records for all your additional data. Once the operation is performed, the form will give a list of all the records it couldn’t generate a spatial shape for.

    Below is an explanation of the most common messages:
    Success – ASD spatial record was drawn and stored successfully.
    No Path – This error is usually shown when the underlying street shape has a gap somewhere. This should be reported to the supplier of the gazetteer data who should then fix it for a future publication.
    No street elements close enough to the XY co-ordinates – This message is shown as at least one of the co-ordinates on the ASD record is more than 10 meters from the street. This should also be reported to the supplier of the gazetteer data.

    Apart from the above you should be ok to ignore the warning shown during the load

    • Exor
    • Street Gazetteer Manager
    • Gazetteer
    • NSG
    • ORA-01400
    • SGM
    • Share
    • History
    • More
    • Cancel
    • Lee Jackson Created by Bentley Colleague Lee Jackson
    • When: Mon, Nov 3 2014 9:52 AM
    • NT Last revision by Bentley Colleague NT
    • When: Thu, Apr 11 2019 5:36 AM
    • Revisions: 4
    • Comments: 0
    Anonymous
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • User Management
    • Licensing Manager
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

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