You are currently reviewing an older revision of this page.
When attempting to backup a particular project, the following error messages occur or similar are displayed and the project is not backed up.
InformationSystem 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)
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.
This is known to have worked for one user.
Executing the following script will remove exit points not associated with any page for the project with an ID value of 9999.
USE promiseDELETE FROM RW_Int_ExitPoint WHERE PageId is null AND ProjectId=9999;
Before executing the script, "promise" should be replaced with the true name of the project database, and "9999" should be replaced with the value on the first line in the ect.fid file, which can viewed using Notepad. The script can be executed by a database administrator using SQL Server Management Studio.