Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Cannot Restore Project: dbo.Page table .... - 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. 

    Cannot Restore Project: dbo.Page table .... - Promis.e CONNECT

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

    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 do not have any associated Drawing Sets listed in the DrawingSet table as per the data in the ECADProject.mdb file present in the Project Backup. 

    This Wiki Article focuses on how to find the pages that don't have drawing set associated with the pages listed. 

      


    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 Unmatched Query Wizard.



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


    7. Now for the select Table: DrawingSet >> Next. 





    8. Now For fields in Page Table select Document_id and then select Id for DrawingSet Table >> Select "<=>" to select the Matching Fields and select Finish. 




    9. Now in results you will find pages that don't have the correct Drawing Set Id. 




    10. Now update the Page Table's Document Id Column in the MDB file for the pages that don't have the correct Drawing Set Id with the correct Drawing Set id by referring to the Drawing Set table's Id column.



    11. After making the changes to the Document Id in the page table save the MDB 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.



    13. Now restore the project and check if works correctly. 

      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: Wed, Jul 28 2021 1:22 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