7504 Restore Issue
Attempting to restore a 7504 backup to a newly installed testing server and I get this:
I see that in old posts that manual full backups would indicate that it was deleting multiple entries in the WordMap table - is that no longer occurring? Is there a way around this? If there isn't, all of my backups are probably useless.
-gjaynes
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
===================================================QUERY = INSERT INTO WordMap (
APPLICATIONID,WORD) VALUES(1, N'own');
java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'WM_PK'. Cann
ot insert duplicate key in object 'dbo.WordMap'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:311)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:141)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:91)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a: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'.
C:\AdventNet\ME\ServiceDesk\bin>
I see that in old posts that manual full backups would indicate that it was deleting multiple entries in the WordMap table - is that no longer occurring? Is there a way around this? If there isn't, all of my backups are probably useless.
-gjaynes