Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error - Invalid Operation when adding a new part record - OID field
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • -Component Management - Promis.e
        • +Catalog Manager - Component Management - Promis.e
        • +Create Macro - Component Management - Promis.e
        • +Create Symbol - Component Management - Promis.e
        • +Family Creation - Component Management - Promis.e
        • -Parts Database - Component Management - Promis.e
          • Error - Invalid Operation when adding a new part record - OID field
          • Error - Object reference...CheckField on Parts Database Manager
          • Error - The value of Attribute_Text is invalid
          • No Browse button for custom mode symbols on Parts Database Manager
          • Parts database changes not reflected in project
          • Parts Database Manager
          • Parts Database Merge Utility
          • Quick Filtering in the Parts Database Manager
          • Quickly Navigate To Part Number Records in Promis.e Connect
          • Specify multiple symbols for one mode in a part number record
          • Unmapped fields cannot be moved on Parts Database Manager Customization
          • Wrong part numbers listed in Select Part Number
        • Sharing content across multiple sites
        • +Terminal_Pin_Plug Manager - Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Error - Invalid Operation when adding a new part record - OID field

      Product(s): promis.e, Bentley Substation
      Version(s): 08.11.08.XX
      Environment: N/A
      Area: Component Management
      Subarea: Parts Database

    Error or Warning Message

    When trying to create a new part record in the Parts Database Manager with the "Apply part information from the current record to new part number" option enabled, you get an error message saying:

    Warning
    Invalid Operation
    OK

    Explanation

    In some cases this error has been found to be caused by incorrect values in the OID field of the parts database. If that field is blank or is a duplicate of an already existing OID value, then you could get this error. The data type for the OID field is AutoNumber, so there should be a unique numeric value for each record. AutoNumber fields cannot be renumbered.

    How To Resolve

    To correct duplicate values in the OID field use the following process:

    1. Make a backup copy of the parts database.
    2. Open the database in MS Access.
    3. Open the table used for the parts database, probably the parts_database table.
    4. Switch to the Design View.
    5. Find the OID field and note the field properties.
    6. Delete the OID field.
    7. Create a new field named OID with the Data Type set to AutoNumber and with same properties as the original.
    8. Save and close the database.

      Original Author: Tani_S

    Keywords: 66767, 500000085365

    • parts database
    • promis.e
    • Migrated
    • error message
    • Bentley Substation
    • en
    • SELECTsupport
    • Component Management
    • Share
    • History
    • More
    • Cancel
    • Tani_S Created by Tani_S
    • When: Fri, Mar 6 2015 1:10 PM
    • Jesse Dringoli Last revision by Bentley Colleague Communities MVP Jesse Dringoli
    • When: Fri, Mar 27 2020 3:57 PM
    • Revisions: 3
    • 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