Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Error on Backup - The field is too small
    • Sign in
    • +OpenUtilities
    • +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
      • +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
        • -Backup and Restore Project - Project Management - Promis.e
          • Backup Project
          • Backup Your Data
          • Error - DB_Restore_BlkInfo on project restore
          • Error - Project was created in database version
          • Error - There are error during restore, rebuild this project to fix it
          • Error - Unable to restore project, project's database version is newer
          • Error on backup - ExecuteSQL error...Syntax error in INSERT INTO Device_Partnumber
          • Error on backup - ODBC connection
          • Error on Backup - The field is too small
          • Error on Backup - You still have page(s) active belong to the project
          • Error on Backup and Restore: System cannot find the file specified
          • Error on project restore - index outside bounds of array
          • Install SQL Server Management Studio
          • Moving Projects
          • Restore Project
          • Restore Sample Projects
          • Submittal Bill Of Materials (SBOM)
        • +BOM Explorer - Project Management - Promis.e
        • +Project Manager - 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 on Backup - The field is too small

      Product(s): Promis.e, Bentley Substation
      Version(s): 08.11.08.xx
      Environment: N/A
      Area: Project Management
      Subarea: Backup and Restore Project

    Error or Warning Message

    "Field too small" error on backup. When part numbers longer than fifty (50) characters are used in a project, attempting to backup the project results in the error message below and an incomplete or missing backup file.

    Internal Error
    Error Message: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
    TargetSite: Void ExecuteSQL(Int32, System.String)
    DeclaringType: MDBProxy.LocalTools
    Attributes: public
    MemberType: Method

    Explanation

    The schema of the template database used to create the database within the backup file does not match the project database. Specifically, in the template database, a particular field in several tables is too small.

    How to Avoid

    The error can be resolved by using Microsoft Access to increase the length of the "partnumber" field to 255 characters in the Device_Partnumber, PartNumberData, and SymbolPartNo tables of the ECADProject.mdb database. The ECADProject.mdb file can be found in the Config subfolder of the program data folder, which is as follows:

    Program data folder - Promis.e

    Program data folder - Substation

    This issue was resolved in a later release of the software. Consider upgrading to the latest version.

      Original Author: Bhargav

    D-85571

    • Backup and Restore Project
    • promis.e
    • error message
    • Bentley Substation
    • Project Management
    • Share
    • History
    • More
    • Cancel
    • Bhargav Created by Bhargav
    • When: Wed, Dec 9 2015 7:23 AM
    • Siddharaj Talawar Last revision by Bentley Colleague Siddharaj Talawar
    • When: Fri, Apr 3 2020 6:53 AM
    • Revisions: 7
    • 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