Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Wrong part numbers listed in Select Part Number
    • Sign in
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +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
        • Adding Manufacturer Data
        • +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. 

    Wrong part numbers listed in Select Part Number

      Product(s): Promis.e, Bentley Substation
      Version(s): 08.11.xx.xx
      Environment: N/A
      Area: Component Management
      Subarea: Parts Database

    Problem Description

    When assigning a part number to a device, some of the part numbers listed on the Select Part Number dialog do not match the filter, and some part numbers that should be listed are missing.

    Explanation

    In a particular case, the default filter was cleared and changed to "Part Number like ABC*", but the resulting list did not include two recently added part numbers beginning with "ABC" while it included two part numbers that did not begin with "ABC". These non-matching part numbers appeared in the list where the two new part numbers should have, if sorted alphabetically. When the same filter is applied in the Parts Database Manager, the results are correct. Using Show Differences did not help. Same problems occurred in a brand new project. Creating and using a new parts database path did not help.

    For this particular case, when the parts database was opened in Microsoft Access, the OID field contained duplicate values even though the data type for the field is AutoNumber. The value in the OID field for part numbers that appeared incorrectly in the Select Part Number dialog matched the value for the respective part numbers that
    incorrectly did not appear.

    Steps to Resolve

    AutoNumber fields cannot be renumbered. To correct duplicate values in the OID field use the following process:

    1. Make a backup copy of the parts database. The active parts database can be determined by clicking the Edit button for the Parts database path field on Setup > System Paths.
    2. Open the database in MS Access.
    3. Open the table used for the parts database, typically 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: Matt_P

    Keywords: 39522, 500000066121

    • parts database
    • promis.e
    • Migrated
    • Bentley Substation
    • en
    • Problem Solving
    • Component Management
    • Component Features
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Fri, Mar 6 2015 3:46 PM
    • Matt_P Last revision by Communities MVP Matt_P
    • When: Wed, Feb 14 2018 12:45 PM
    • 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

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies