When attempting to restore my database, the restoration process is failing. I am getting the following error:
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
==============================================QUERY = INSERT INTO WordMap (APPLICATIONID,WORD) VALUES(1, N'ti');
java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'WM_PK'. Cannot insert duplicate key in object 'dbo.WordMap'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:311)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:141)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:91)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of PRIMARY KEY constraint 'WM_PK'. Cannot
insert duplicate key in object 'dbo.WordMap'.
I could probably remove this manually from the extract, but I would rather find out what is causing the issue and fix it.
The database is from version 7509.