Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki On loading inventory stage 2 Constraint violated
    • 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
          • Invalid Initials For Inspector When Loading HMDIF Files
          • On loading inventory stage 2 Constraint violated
          • ORA-105101 error uploading files to server
          • Spooled Ouput View
          • UKP030 SQL-02112 SELECT..INTO returns too many rows
        • +Network Selection - Exor UKPMS
        • REP-300 error
        • +Reports - Exor UKPMS
        • +Survey Load - Exor UKPMS
        • Survey tolerance errors
        • +UKPMS Pass - Exor UKPMS
      • +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. 

    On loading inventory stage 2 Constraint violated

       
      Applies To 
       
      Product(s): Exor UKPMS
      Version(s): 04.05.00.00
      Environment:  N/A
      Area:  Inventory Loading
      Subarea: 
      Original Author:  Bentley Technical Support Group
       

     

     

     

     

     

     

     

    Error or Warning Message

    On loading stage 2 the error message is appearing:

    Error: Occured In process_ukp_assets While Inserting LJ Assets From HHINV_LOAD_2

    ORA-00001: unique constraint (HIGHWAYS.UKPMS_LJ_PK) violated

    ORA-00001: unique constraint (HIGHWAYS.UKPMS_LJ_PK) violated in "...' on line 0 of

     

    Solution

     

    Exor metadata is misconfigured. Open MAI1400 form for the asset type whose constrain was violated.

    In this case it is ‘LJ’. Check what are sequences of ‘LJ’ asset type (‘Check DCD’ button on MAI1400 form).

    Make changes as is shown below:

     

    • ukpms
    • constraint violated
    • mai1400
    • loading stage 2
    • Check DCD HHINV_LOAD_2
    • load inventory
    • Share
    • History
    • More
    • Cancel
    • renatas Created by Bentley Colleague renatas
    • When: Fri, Oct 17 2014 4:17 AM
    • renatas Last revision by Bentley Colleague renatas
    • When: Fri, Oct 17 2014 4:21 AM
    • Revisions: 2
    • 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