Spare Parts Import Error: "Could Not Insert"This article explains how to fix the associated importing error.Oct 14, 2026Article
InformationTitleSpare Parts Import Error: "Could Not Insert"ContentContentWhen importing Parts onto a Spare Part List, the Spare Part import, the import will fail if the Parts on the import sheet are already associated with the Spare Part List or if the same Part ID appears more than once for a specific Spare Part List ID within the import sheet. The error message that will be displayed is: "could not insert: [CMMSdg.Plant.MappingObjects.SparePart][SQL: INSERT INTO tblSpareParts (SparePartsListId, PartId, Quantity, DateCreated, DateEdited, CreatedBy, EditedBy) VALUES (?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()]". To correct this error, check the Spare Part List in MVP One to find any Parts listed there that are on your import sheet. Remove them from the import sheet and try the process again. Alternately identify any duplicated Part IDs within Spare Part Lists on your import sheet. Remove these duplicated values and try the process again.URL NameCould-Not-Insert-Error-on-Spare-Parts-Import