File name is : C:\ManageEngine\ServiceDesk\backup\backup_servicedesk_8008_fullb
ackup_03_01_2011_21_36.data
requestScheme is http
Please wait extracting backup file
Active DB Server = mssql
Database connectionProp : null
Database started
*************************************************************
Backpup data : Tue Mar 01 21:36:23 GMT 2011
Database name : servicedesk
Total Tables : 1012
Database Server : mysql
Build Number : 8008
*************************************************************
02-Mar-2011 16:32:08 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: ..
02-Mar-2011 16:32:08 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=8.0.0}, BUILD={number=8008}}
02-Mar-2011 16:32:08 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser
viceDesk Plus}, ADMANAGER={name=ADManager}}
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 departmentdefinition (DEPTID,DEPTNAME,DEPTH
EADID,PHONENO,FAX,SITEID,DEPTDESC,ISDELETED) VALUES(8428, N'Head Office (Riversi
de House)', NULL, NULL, NULL, 9005, NULL, 0);
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'DepartmentDef
inition_UK'. Cannot insert duplicate key in object 'dbo.departmentdefinition'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:402)
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 : Violation of UNIQUE KEY constraint 'DepartmentDefin
ition_UK'. Cannot insert duplicate key in object 'dbo.departmentdefinition'.