Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki The Insert statement conflicts with the FOREIGN KEY constraint "FK_page_PageFormat" ........... OpenUtilities Substation
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • -OpenUtilities Substation
      • -CONNECT Edition - OpenUtilities Substation
        • +3D Layout Features - OpenUtilities-Substation
        • +Administration Features - OpenUtilities Substation
        • +Automation Feature
        • +Component management - OpenUtilities Substation CONNECT
        • +Components Features - Substation CONNECT
        • +Construction Drawing - Openutilities Substation CONNECT
        • +Database Platform Support - OpenUtilities Substation
        • +Drawing Managment - OpenUtilities Substation
        • +Installation_Configuration - Bentley Substation CONNECT Edition
        • +Maintenance Feature - Open Utilities Substation CONNECT
        • +Migration - OpenUtilities Substation CONNECT
        • +OS & Hardware Support - OpenUtilities Substation CONNECT
        • +Panel Layout- Substation CONNECT
        • +Power Platform Support - Substation CONNECT
        • +Print and Plot feature
        • +Print and Publish feature
        • -Project Management - OpenUtilities Substation CE
          • -Backup & Restore Projects - OpenUtilities Substation CE
            • Backup Project - OpenUtilities Substation CONNECT Edition
            • Cannot Restore Project: dbo.Page table .... - OpenUtilities Substation CONNECT
            • Error on Backup - You still have page(s) active belong to the project - OpenUtilities Substation Edition
            • How to Restore a Project in OpenUtilities Substation CONNECT
            • The Insert statement conflicts with the FOREIGN KEY constraint "FK_page_PageFormat" ........... OpenUtilities Substation
          • How to remove Unplace Device from OpenUtilities Substation
          • Message while creating a page: The Current DGN is authorized by ....... OpenUtilities Substation
          • +Project Manager - Project Management - OpenUtilities Substation CE
          • ProjectWise Project - Project Management
        • +ProjectWise Integration - OpenUtilities Substation CONNECT
        • +Replace Device ID - Find_Replace - OpenUtilities Substation
        • +Reports_Output Features - OpenUtilities Substation CONNECT
        • +Resolved issues in OpenUtilities Substation Releases
        • +Wire Numbering - Substation CONNECT
        • +Wiring Feature - OpenUtilities Substation
      • +3D Layout Features - Bentley Substation
      • About Bentley Substation
      • +Administration Features - Bentley Substation
      • +Automation Features - Bentley Substation
      • +Component Management - Bentley Substation
      • +Construction Drawings - Bentley Substation
      • +Database Platform Support - Bentley Substation
      • +Grounding Grid - Bentley Substation
      • How to log Service Request
      • +Installation_Configuration - Bentley Substation
      • +Interoperability - Bentley Substation
      • +PowerPlatform Support - Bentley Substation
      • +Project Management - Bentley Substation
      • +ProjectWise Integration - Bentley Substation
      • Working from home with OpenUtilities Substation
    • Promis.e Paths
    • +Promis.e Wiki
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

     
     Questions about this article, topic, or product? Click here. 

    The Insert statement conflicts with the FOREIGN KEY constraint "FK_page_PageFormat" ........... OpenUtilities Substation

      Product(s): OpenUtilities Substation CONNECT Edition
      Version(s):  10.00.XX.XX to 10.13.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 Page Format listed in the Page Format 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: PageFormat >> Next. 





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



    9. Now in results you will find pages that don't have the correct PageFormat_id or the PageFormat_id is missing in the PageFormat Table. 



    10. Now update the Page Table's PageFormat_Id Column in the MDB file for the pages that don't have the correct PageFormat_Id with the correct id by referring to the Page Format table's Id column.
    Note: Also make sure the DGN with the name from File Name exists in the Project Backup by browsing the 7-Zip dialog from step 3 for the file.



    11. After making the changes to the Page Format 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
    • error
    • error message
    • en
    • Project Management
    • OpenUtilities Substation
    • Share
    • History
    • More
    • Cancel
    • Satish Saptasagar Created by Bentley Colleague Satish Saptasagar
    • When: Thu, Oct 20 2022 9:00 AM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Fri, Oct 21 2022 5:23 AM
    • Revisions: 2
    • 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