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 Cannot create provisional street
    • 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. 

    Cannot create provisional street

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

    Problem 

    The issue is that the user is unable to create a new provisional street on NSG0010, which is then used in TMA Manager. A user needs to create a new provisional street for several reasons, the main one being when they need to send an authority a notice for works on a new street which isn’t in the nsg gazetteer yet.

    The problem occurs when an error is shown when trying to enter coordinates. If you don’t enter any coordinates then the form gives another error saying that they are mandatory.
    To reproduce this I did the following:

    1. In NSG0010 entered all the provisional street details and removed the usrn number.
    2. Entered the start X and Y and then hit tab to move to the End X field but the first error is shown:
       FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-13226
    3. Click ok and can enter the coordinates, then click ok on the same message as you move to end Y.
    4. Now try to save the record and the following error is shown, which is the error the user reported:
       FRM-40735: POST-RECORD trigger raised unhandled exception ORA-13226
    5. The same POST-RECORD trigger error is shown if you try and click on the Type 21 field, before or after you try and save the provisional street record.

    Solution

    To fix this problem you may only need to rebuild the spatial indexes. This can be done by opening the NSG0010 form, then open the toolbox menu and select the Spatial Indexes option.
    Problem 59725

    If rebuilding the spatial indexes does not fix the issue, then it could be caused by missing spatial metadata. To check, run the following query in SQLPlus as the Highways Table Owner:

    SELECT * FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'NM_POINT_LOCATIONS' AND COLUMN_NAME = 'NPL_LOCATION';

    If this returns no records, run the following statements to create the missing metadata and related index:

    INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
    SELECT 'NM_POINT_LOCATIONS', 'NPL_LOCATION',NM3SDO.CALCULATE_TABLE_DIMINFO('NM_POINT_LOCATIONS', 'NPL_LOCATION'), NULL FROM DUAL;

    DROP INDEX NM_POINT_LOCATIONS_SPIDX;

    CREATE INDEX NM_POINT_LOCATIONS_SPIDX ON NM_POINT_LOCATIONS
    (NPL_LOCATION)
    INDEXTYPE IS MDSYS.SPATIAL_INDEX
    NOPARALLEL;

    See Also

    Product TechNotes and FAQs

    External Links

    Bentley Technical Support KnowledgeBase

    Bentley LEARN Server

    Comments or Corrections?

    Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

      Original Author: Bentley Technical Support Group
    • 59725
    • NSG Gazetteer
    • ora-13226
    • Provisional
    • Exor Street Gazetteer Manager
    • Share
    • History
    • More
    • Cancel
    • Elisabeth Pry Created by Bentley Colleague Elisabeth Pry
    • When: Tue, Sep 24 2013 11:53 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Thu, Mar 21 2019 8:17 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