Problem Restoring DataBase Backup
Upgraded from v6.0.0.6 to v6.0.0.8
But the SD+ didn't start, installed it, resinstalled with latest version 6.0.0.8
After trying to restore latest v.6.0.0.8 backup it gives me this error:
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
=======================================QUERY = INSERT INTO softwarelist (SOFTWAR
EID,SOFTWARENAME,FILEVENDOR,FILEVERSION,PRODUCTNAME,PRODUCTVERSION,COMPANYNAME,S
OFTWARETYPEID,CURRENTLYMETERED,DESCRIPTION) VALUES(3684, N'Security Update for W
indows Server 2003 (KB924496)', N'Microsoft Corporation', N'1', N'-', N'-', N'-'
, 1, 0, N'-');
java.sql.BatchUpdateException: null, message from server: "Duplicate entry 'Ava
nce AC97 Audio' for key 2"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:306)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:121)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:81)
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 'Avanc
e AC97 Audio' for key 2"
and it stops.
Can someone help me? Is there any repair tool to check the DB integraty or repair this duplicated key?
Thanks in advance.
JJ
New to ADSelfService Plus?