restore failure to v 8026 "Duplicate entry"
I am trying to rebuild my Managenegine Server after upgrades caused it to go intoa fit of restarting.
I have backups of the database and have frashly installed v. 8026 (teh version it was last working on)
I get this errir when trying to restore the data:
How do I get oast this and force it to complete the restore?
__________________________________________________________________________________________
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
=====================================================
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
======================================QUERY = INSERT INTO softwarelist (SOFTWARE
ID,SOFTWARENAME,SWMANUFACTURERID,FILEVERSION,PRODUCTNAME,PRODUCTVERSION,COMPANYN
AME,SOFTWARETYPEID,SOFTWARECATEGORYID,CURRENTLYMETERED,DESCRIPTION,SWCOMPLIANCET
YPEID) VALUES(20121, N'Skype Click to Call', 112, N'-', N'-', N'-', N'-', 1, 9,
0, NULL, 2);
java.sql.BatchUpdateException: null, message from server: "Duplicate entry 'ACD
/Labs Software in C:\Program Files\ACDFREE11' for key 2"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:436)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:142)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:90)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : null, message from server: "Duplicate entry 'ACD/L
abs Software in C:\Program Files\ACDFREE11' for key 2"
--------------------------------------------------------------------------------------------------------------------------------------------------------
Thanks
John
New to ADSelfService Plus?