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 - ExecuteSQL error...Syntax error in INSERT INTO RW_Int_ExitPoint
    • Sign in
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • -OpenUtilities Substation
      • +CONNECT Edition - 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
        • -Backup and Restore Project - Project Management - Bentley Substation
          • Error on backup - ExecuteSQL error...Syntax error in INSERT INTO RW_Int_ExitPoint
          • Reduce Project Backup Size
          • Restore Project or Import Catalog always appears at start up
        • How to rename a Project/Workset in Substation CONNECT
        • +Project Manager - Project Management - Bentley Substation
        • Remove Unplaced Devices
      • +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. 

    Error on backup - ExecuteSQL error...Syntax error in INSERT INTO RW_Int_ExitPoint

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

    Error or Warning Message

    When attempting to backup a particular project, the following error messages occur or similar are displayed and the project is not backed up.

    Information
    System Exception: ExecuteSQL error, insert into RW_Int_ExitPoint (ID, Name, X, Y, Z, Handle, RegionId, PageId, Description)
    values (123,'X',0,0,0,'',456,,'')
    Syntax error in INSERT INTO statement.  --> System.Data.OleDb.OleDbException:  Syntax error in INSERT INTO statement.
       at MDBProxy.ConnectionManager.ExecuteSQL(Int32, nConnectionID, String strSQL)
       at MDBProxy.LocalTools.ExecuteSQL(Int32, nConnectionID, String strSQL)
       --- End of inner exception stack trace ---
       at MDBProxy.LocalTools.ExecuteSQL(Int32, nConnectionID, String strSQL)
       at ECT.ECAD.DAL.BackupData.BackupMSSQLProject(Int32 projectId, String connectString, String path)

    Explanation

    The "Syntax error in INSERT INTO statement" portion of the messages indicate the problem is occurring as the software is trying to insert data from the SQL project database into the database in the backup file. The problem could be that the data violates some constraint, causing the insertion to fail.

    In the example messages above, there is no value present to be inserted into the PageId column of the RW_Int_ExitPoint table, which violates a constraint of the database. The RW_Int_ExitPoint table is related to exit points of regions used by the Run Shortest Distance tool. The above example message indicates that there is an exit point in the project not associated with any page, which should not be the case.

    How to Avoid

    Option 1 - Copy the project

    This is known to have worked for one user.

    1. Use Project Manager to copy the project.
    2. Back up the copy.

    Option 2 - Copy the pages into a new project

    1. Open Project Manager.
    2. Create a new project based on the same project options as the problem project.
    3. Select all the pages in the problem project.
    4. Right-click the selection and choose Copy.
    5. Specify the new project as the destination project and set remaining options. Generally in this situation, choose Keep Existing and Maintain / Complete where applicable.
    6. Click OK.
    7. Back up the new project.

    Option 3 - Remove the problem exit point from the database.

    Executing the following script will remove exit points not associated with any page for the project with an ID value of 9999.

    1. Modify the following script to replace "promise" with the true name of the project database and replace "9999" with the true project id value. The project id can be found on the first line in the ect.fid file, which can viewed using Notepad, and is not the same as the project name.
    2. Execute the script using SQL Server Management Studio. This may need to be done by a database administrator.

      USE promise
      DELETE FROM RW_Int_ExitPoint WHERE PageId is null AND ProjectId=9999;

    3. Back up the project.

      Original Author: Matt_P
    • Backup and Restore Project
    • promis.e
    • error message
    • Bentley Substation
    • en
    • Project Management
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Thu, Nov 5 2015 3:11 PM
    • Michael Kelley Last revision by Bentley Colleague Michael Kelley
    • When: Mon, May 11 2020 4:18 PM
    • 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