SDP 7.6 restore error
SDP 7.6 restore error
Hello,
I'm trying to restore a previous backup after a system crash but I get the following error:
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
================================================QUERY = INSERT INTO wordoccurrences (WORDHASHID,COLUMNID,WORDCOUNT) VALUESnull
java.sql.BatchUpdateException: null, message from server: "Duplicate entry '1960198957-11' for key 1"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:419)
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)
java.sql.BatchUpdateException: null, message from server: "Duplicate entry '1960198957-11' for key 1"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:419)
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 : null, message from server: "Duplicate entry '1960198957-11' for key 1"
anyone can help me ?