Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki ORA-01427 error is appearing on running Automatic Pass
    • 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
      • Exor Streetworks Manager
      • Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • -Exor UKPMS
        • Error at point 14 when running a pass
        • +HMDIF Load - Exor UKPMS
        • +Network Selection - Exor UKPMS
        • REP-300 error
        • +Reports - Exor UKPMS
        • +Survey Load - Exor UKPMS
        • Survey tolerance errors
        • -UKPMS Pass - Exor UKPMS
          • Automatic Pass flagged to stop
          • Delete Auto Pass
          • Invalid path when opening .lis file
          • ORA-01427 error is appearing on running Automatic Pass
          • ORA-06502 when selecting network selection
      • +Transportation Intelligence Gateway
      • Unable to connect to Power BI dataset
      • +Video Series for Exor
      • Working From Home with Exor
    • +AssetWise ALIM for Transportation

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

    ORA-01427 error is appearing on running Automatic Pass

      Product(s): Exor UKPMS
      Version(s): 04.05.00.00
      Environment: N/A
      Area: Automatic Pass
      Subarea: N/A

    Problem Description

    On running UKPMS Automatic Pass the error message appeared : “Unknown error in Init Rating Defects to Inv .Debug info : ORA-01427: single-row subquery returns more than one row at point 1”

    Steps to resolve

    One of reasons causing this error is the duplicated inventory have been created in the system.

    It happens when the same data the same sections within the same chainages have been loaded into the system twice.

    To delete the duplicated inventory from the system run UKPDUPINV module from Fastpath and run Automatic Pass again.

      Original Author: Renatas M
    • UKP0003
    • inventory
    • Init Rating Defects
    • UA
    • UKPDUPINV
    • ORA-01427
    • SCRIM
    • Automatic Pass
    • Duplicate
    • duplicated
    • Share
    • History
    • More
    • Cancel
    • renatas Created by Bentley Colleague renatas
    • When: Wed, Mar 11 2015 3:49 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Thu, Mar 4 2021 10:55 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