Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki Adding new standard item causes HIG-0169 Database constraint violated CNI_INDEX_P1
    • 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
        • Adding a BOQ causes FRM-40200:Field is protected against update
        • Adding new standard item causes HIG-0169 Database constraint violated CNI_INDEX_P1
        • +Budgets - Exor Maintenance Manager
        • Can't Instruct Defects
        • Cannot amend instructed work orders
        • Changing v2 Asset Type Attributes on MAI1400
        • Complete defect manually when interfaces on
        • Could not create map in locator
        • Create new budgets after financial year start
        • +Cyclic Maintenance - Exor Maintenance Manager
        • Defect details changed after load
        • Defect priority list
        • +Defects - Exor Maintenance Manager
        • Duplicate defects created
        • +E5 Payment Run - Exor Maintenance Manager
        • Erroneous defect repair dates
        • Error during Inspection Loader Part 2
        • Error instructing Work Orders M_MGR-0267
        • Error message ‘REP-271468672: A temporary file cannot be created’ is appearing.
        • Error messages HIG-0530 and HIG-0556 on inspection loading
        • Exor MAI M_MGR-0234 in cyclic work orders
        • Forced to add road group when adding standard item to contract
        • HIG-0067 when query cyclic work orders
        • +Hosting/Accessibility - Exor Maintenance Manager
        • How to find MAP Viewer log files
        • How to restart MapViewer Service
        • Illegal Activity Area Code in inspection by group form
        • In Map, zooming in takes a lot of time
        • Inspection Date less on loading RDI files
        • Inspection Loader 'could not read file content'
        • Inspection upload failure (from MCP to Exor MAI)
        • +Inspections - Exor Maintenance Manager
        • +Interface - Exor Maintenance Manager
        • Invalid path when running interfaces
        • Loader creates doc assoc record but doesnt move files post load
        • +Loaders - Inspection - Exor Maintenance Manager
        • +Loaders - Inventory - Exor Maintenance Manager
        • +Locator - Exor Maintenance Manager
        • Method to clear older defect at zero cost
        • Missing Financial Code EXORR feeder
        • Missing LOCATION keyword when single quote in filename
        • M_MGR-0090 date raised must be <= todays date
        • Notify field on defects form
        • On loading Work Order Invoice (WI) file an error ‘ORA-06502’ appears
        • On scroll BOQ items error “FRM-41050:You cannot update this record” appears
        • ORA 00001 IC PK violation when processing WC file
        • ORA-01400: cannot insert NULL into ("HIGHWAYS"."BOQ_ITEMS"."BOQ_EST_DIM1")
        • ORA-06502: PL/SQL: numeric or value error: character string buffer too small
        • Prevent budget being selected mid way through financial year
        • +Reference - Inspections - Exor Maintenance Manager
        • Unable to run reports
        • Unknown Module MAI3620
        • +Work Orders - 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
      • +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. 

    Adding new standard item causes HIG-0169 Database constraint violated CNI_INDEX_P1

      Product(s): Exor Maintenance Manager
      Version(s): 4.4.0.0
      Environment: N/A
      Area: Contracts
      Subarea: N/A

    Problem

    Adding a new standard item into Standard Items form (MAI3888) causes HIG-0169 Database constraint violated CNI_INDEX_P1.

    Solution

    Item already existed in DUMCONCODE contract but did not exist in standard items form ( mai3888). So I removed the entry from the DUMCONCODE contract. Then I was able to enter the item code that was failing.

    Queried back item from standard items form to see if already existed - with the scenario investigated it did not. However, entering and saving new item caused HIG-0169 Database constraint violated CNI_INDEX_P1 to be displayed. Check Product Option DUMCONCODE, note the Contract assigned (DEFAULT). From Contracts form query back contract (DEFAULT). From contract items part of form check if item exists, if it does ( which it did for this scenario)  - remove by deleting record.Then return to standard items form to create item. Insert Trigger on standard items table caused the error.

    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
    • HIG-0169
    • standard item
    • UA
    • MAI
    • Exor Maintenance Manager
    • contract items
    • Share
    • History
    • More
    • Cancel
    • Sarah Willis-Culpitt Created by Bentley Colleague Sarah Willis-Culpitt
    • When: Thu, Sep 5 2013 1:02 PM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Wed, Mar 3 2021 6:46 AM
    • Revisions: 8
    • 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