Data Restore Failed...

Data Restore Failed...

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'.













C:\ManageEngine\ServiceDesk\bin>

                  New to ADSelfService Plus?