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.
Internal ErrorError Message: ExecuteSQL error, insert into Device_Partnumber(id,device_id,partnumber,quantity,mainpartnoflag,balloon,bomflag) values(123,,'MyPart Number',1,1,'','')Syntax error in INSERT INTO statement.TargetSite: Void BackupMSSQLProject(Int32, System.String, System.String)DeclaringType: ECT.ECAD.DAL.BackupDataAttributes: privateMemberType: Method
InformationSystem Exception: ExecuteSQL error, insert into Device_Partnumber(id,device_id,partnumber,quantity,mainpartnoflag,balloon,bomflag) values (123,,'MyPart Number',1,1,'','')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 device_id column, which violates a constraint of the database. It also indicates that an instance of the part number exists in the project with no association to any device ID, which should not be the case.
Perform the steps described in the Remove Unplaced Devices article.
Back up the project.