Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error Message "DB_Restore_ConverPage" when restoring a project backup in Promis.e CONNECT.
    • 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
        • +Administration Features - Promis.e CONNECT
        • +Automation Features - Promis.e CONNECT
        • +Component Features - Promis.e CONNECT
        • +Component Management - Promis.e CONNECT
        • +Database Platform Support - Promis.e CONNECT
        • +Drawing Management - Promis.e Connect
        • +Installation_Configuration - Promis.e CONNECT Edition
        • +Maintenance Features - Promis.e CONNECT
        • +Migration - Promis.e CONNECT
        • +OS & Hardware Support - Promis.e CONNECT
        • +Panel Layout Mode - Promis.e CONNECT
        • +Power Platform Support - Promis.e CONNECT
        • +Print and Plot features Promis.e CONNECT
        • -Project Management - Promis.e CONNECT
          • -Backup & Restore Project - Promis.e CONNECT Project Management
            • Backup Project - Promis.e CONNECT Edition
            • Cannot Restore Project: dbo.Page table .... - Promis.e CONNECT
            • Error Message "DB_Restore_ConverPage" when restoring a project backup in Promis.e CONNECT.
            • Error on Backup - You still have page(s) active belong to the project - Promis.e CONNECT Edition
            • How to Restore a Project in Promis.e CONNECT
            • The Insert statement conflicts with the FOREIGN KEY constraint "FK_page_PageFormat" ........... Promis.e CONNECT
          • Message while creating a page: The Current DGN is authorized by ....... Promis.e CONNECT
          • Opening Pages slow for some of the pages due to Pending Changes in the Database - Promis.e CONNECT
          • +Project Manager - Project Management - Promis.e CONNECT
          • Remove Unplaced Devices - Promis.e CONNECT
          • Terminal Number changing when Maintain Terminal Number checked during Renumbering of a Page in Promis.e CONNECT
        • +ProjectWise Integration - Promis.e CONNECT
        • +Reports_Output Features - Promis.e CONNECT
        • +Resolved issues in Promis.e Releases
        • +Wire Numbering - Promis.e CONNECT
        • +Wiring Feature - Promis.e CONNECT
      • 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
      • 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 Message "DB_Restore_ConverPage" when restoring a project backup in Promis.e CONNECT.

    -

      Product(s): Promis.e CONNECT Edition
      Version(s):  10.00.XX.XX to 10.12.XX.XX
      Environment:  NA
      Area:  Backup & Restore Project
      Subarea:  NA

    Background:

    The user in some cases may get the below Error Message when Restoring a Project. This message indicates that there are some pages in the Project which have entries of duplicate pages with different Installation / Location / Drawing Set. Some of the duplicate pages will be having Installation / Location / Drawing Set. This Wiki Article focuses on how to find the pages that have duplicate entries for pages.



    Important Note: The for following the below steps the user needs to have Microsoft Access Installed on the machine. Also, they should create backup of the Project Backup so that in case of any issues user can refer to the backup file.

    Steps to Accomplish

    1. Browse to the location where the Project Backup file is for which the issue being faced is located using Windows Explorer. 


    2. Right-click on the Project Backup file and select 7-Zip >> Open Archive.




    3. Now in the &-Zip Dialog select the "ECADProject.mdb" file and use the Copy Option to create a copy of the file on the local machine. 




    4. Go to the location where the MDB file is copied and then open it with Microsoft Access.


    5. After opening the file in Access go to Create >> Query Wizard >> in New Query dialog select Find Duplicate Query Wizard.




    6. Now for the results table select Table: Page >> Next. 




    7. Now select "File Name" to check for Duplicate-Value Fields.





    8. Select all the Available Fields select Finish.





    9. In the Result Table if there are entries then there are duplicate records in database for a single drawing. The user can decide which record to delete by referring the Drawing Set / Installation / Location. In the below screen shot example it can be seen that all the Drawing Set Ids from the page table are not present in "Drawing Set" table. But the users need to check other tables as well as well like Installation / Location / Page Format if the issue is not in Drawing Set.






    10. After identifying the record which is duplicate the duplicate records need to be deleted. This can be done by Right Click on the record and select Delete Record. 




    11. After Deleting all the duplicate records, Save the file. 


    12. Now Drag and Drop the MDB file into the 7-Zip dialog Step 3 and say Yes in the dialog. after copying close the 7-Zip dialog.




      Original Author: Satish Saptasagar
    • Backup and Restore Project
    • promise CONNECT
    • error message
    • en
    • Project Management
    • Share
    • History
    • More
    • Cancel
    • Satish Saptasagar Created by Bentley Colleague Satish Saptasagar
    • When: Thu, Apr 20 2023 2:26 PM
    • Revisions: 1
    • 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