Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error - Field types do not match and cannot be mapped
    • 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
        • +Command Protection - Administration Features - Promis.e
        • +Language Database Manager - Administration Features - Promis.e
        • +Mode Manager - Administration Features - Promis.e
        • +Options - Administration Features - Promis.e
        • -Setup - Administration Features - Promis.e
          • Add Catalog Path
          • Catalog Management Tips [FAQ]
          • Catalog Paths
          • Error - "database is used by another user" when creating parts database path
          • Error - Field types do not match and cannot be mapped
          • Error - Title block name is invalid
          • Error creating part database path, DBNETLIB
          • How to Create a new catalog in Bentley Substation and Promis.e
          • Rename a catalog
          • Setup
          • Switch electrical standard used by the software
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +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 - Field types do not match and cannot be mapped

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.57
      Environment: N\A
      Area: Administration Features
      Subarea: Setup

    Error or Warning Message

    When creating a parts database path on Setup, the following error message or similar is displayed:

    Warning
    The field types for the following fields do not match and cannot be mapped:
    Field Part_Number do not match to field Part_Number
    Field IsEquipment do not match to field IsEquipment
    Field Additional_Part do not match to field Additional_Part
    ...

    Explanation

    The software checks to make sure the properties of the fields/columns in the parts database being mapped match the project database fields to avoid potential problems when the data from the parts database gets copied to the project database during design work. The fields called out in the error message have been found to be the wrong data type or the wrong length.

    How to Avoid

    Compare the field properties in the parts database being mapped to a table supplied with the software and make changes accordingly.

    If creating a parts database path to an Access-style .MDB file, compare the properties of the fields in question to the properties of the fields in the parts_database table of the ANSI-IEEE_parts_database.mdb or iec_parts_database.mdb file using Microsoft Access.  These files are typically found in the Databases subfolder of the Promise Data folder and Substation Data folder.  Vanilla versions of these files can be found in the .zip file containing the default Data folder contents if necessary.

    If creating a parts database path to a table in a SQL database, compare the properties of the fields in question to the properties of the fields in the parts_database table of the project database. This can be done using SQL Server Management Studio or by examining the "CREATE TABLE parts_database" section of the SqlServerProject.sql script file that creates the project database schema. The script can be found in the Promis.e program folder and in the Substation program folder on the workstation that has promis.e/Bentley Substation installed.

    See Also

    Converting to an SQL Parts Database

    Creating and Updating the Project Database

      Original Author: Matt_P
    • Setup
    • parts database
    • promis.e
    • Bentley Substation
    • en
    • Administration Features
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Tue, Jul 19 2016 2:19 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Thu, Apr 16 2020 8:57 AM
    • 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