Environment
PlateSpin Recon 3.7
Situation
This article discusses on how to overcome the below error while trying to upgrade PlateSpin Recon Server.
Error Code: 1073741819
Error found in CustomActions.log: Violation of PRIMARY KEY constraint 'PK__Nodes__09A971A2'. Cannot insert duplicate key in object 'dbo.Nodes'
Resolution
During an upgrade of PlateSpin Recon Server with MS SQL Server as its database might experience an issue in cleaning up some entries and could cause the above error while trying to update the database during the install process.
Workaround/Resolution: Export snapshot to back up all data from the Recon Server. Uninstall SQL Server completely. Reboot the server once to install SQL server again and complete the PlateSpin Recon Server install now. Import snapshot.