Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Error - DB_Restore_BlkInfo on project restore
    • 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
      • +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 - DB_Restore_BlkInfo on project restore

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

    Error or Warning Message

    When restoring a certain project backup file created in SELECTseries 7, an error message similar to the one below is displayed. Project restoration continues after acknowledging the error message.

    Internal Error
    DB_Restore_BlkInfo
    ProjectDB Error Message: XML parsing: line 29, character 31, A string literal was expected
    The data for table-valued parameter "@inputTable" doesn't conform to the table type of the parameter.
    The statement has been terminated.
    TargetSite: Boolean _InsertTable(System.Data.DataTable, Bentley.Electrical.Data.Db.TableNames, System.Data.DataTable By Ref)
    DeclaringType: ECT.ECAD.DAL.BulkInsert
    Attributes: private
    MemberType: Method
    StackTrace: C:\ProgramData\Bentley\Substation V8i\Config\LastError.txt
    Product Version: Substation V8i (SELECTseries 8)
    DB Version: SQLServer 8.1.33

    Explanation

    The "DB_Restore_BlkInfo" portion of the error message indicates the problem is related to the BlkInfo table. This can be caused by incomplete XML code in the blkSymXML field for at least one record in the BlkInfo table in the backup. The BlkInfo table contains symbol definition information.

    The project restore process has changed in SELECTseries 8 to reduce restore times. The tables are restored in bulk now instead of record-by-record. Therefore the error message prevents all records from being restored into the BlkInfo table in the project database.

    Similar error messages may indicate a problem with different table, but such messages have not been reported.

    How to Avoid

    Option 1

    Run Rebuild Project Database on the project after restoration completes. This has been found to populate missing data and fix incomplete data

    Option 2

    1. Run Rebuild Project Database on the source project.
    2. Create a new backup of the source project.
    3. Restore the backup into the new version.

    Troubleshooting details

    These details below are provided for reference. It is typically not necessary to find the problem records using the techniques below; running Rebuild Project Database on the restored project has fixed the issue in the known cases.

    Method 1

    To determine which record is the problem when the error message refers to BlkInfo, add the highlighted line below to the default.SystemOptions.xml file then restore the backup again. The default.SystemOptions.xml file is found in the \Promise Data\Config\Options or \Substation Data\Config\Options folder.

      <BulkDb>
        <MaxRows>100000</MaxRows>
        <TimeoutFactorRowsPerSecond>0</TimeoutFactorRowsPerSecond>
        <DebugTables>BlkInfo</DebugTables>
      </BulkDb>

    An additional error message should appear during the restore indicating the record id number and other details of the record.

    If there is more than one problem record, the error message will return only the first one encountered.

    Method 2

    The ECADProject.mdb file in the project backup can be opened in Microsoft Access and a query executed to select records in the BlkInfo table that have incomplete values in the blkSymXML column (they do not end in "</symbol>"). Such a query would be:

    SELECT * FROM BlkInfo WHERE ((BlkInfo.blkSymXML) Not Like '*symbol>*');

      Original Author: Matt_P

    Keywords: "equal expected", TFS 454723

    • Backup and Restore Project
    • promis.e
    • error message
    • Bentley Substation
    • en
    • Project Management
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Fri, Jun 10 2016 3:33 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Fri, Apr 3 2020 6:42 AM
    • Revisions: 4
    • 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