I am trying to move ServiceDesk plus from one server to another. I keep getting the error below. I have tried multiple backup files and make sure the configs were the same. The only difference is the new server has the install on the D drive and the old server had the install on C:.
D:\AdventNet\ME\ServiceDesk\bin>restoreData.bat
*********************************************************************************
Restore DB Setup Wizard
*********************************************************************************
Execute Restore DB Utility from command prompt
For Windows users :
bin>restoreData -c [backup file]
For Linux users :
bin]#sh restoreData.sh -c [backup file]
*********************************************************************************
You chose to open this file: C:\root\source\ServiceDesk\backup_servicedesk_7509_fullbackup_09_05_2009_20_10.da
ta
File name is : C:\root\source\ServiceDesk\backup_servicedesk_7509_fullbackup_09_05_2009_20_10.data
requestScheme is http
Please wait extracting backup file
Sep 5, 2009 9:45:16 PM com.adventnet.j2ee.deployment.service.internal.JarExtractor extract
INFO: Extraction for C:\root\source\ServiceDesk\backup_servicedesk_7509_fullbackup_09_05_2009_20_10.data to D
:\AdventNet\ME\ServiceDesk\bin\..
Active DB Server = mysql
Database connectionProp : useUnicode=true
characterEncoding=UTF-8
Database started
*************************************************************
Backpup data : Sat Sep 05 20:10:15 EDT 2009
Database name : servicedesk
Total Tables : 851
DB - Server : mysql
Build Number : 7509
*************************************************************
Sep 5, 2009 9:45:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: ..
Sep 5, 2009 9:45:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=7.5.0}, BUILD={number=7509}}
Sep 5, 2009 9:45:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=AdventNet ManageEngine ServiceDesk Plus}, ADMA
NAGER={name=ADManager}}
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
======================================QUERY = INSERT INTO softwarelist (SOFTWAREID,SOFTWARENAME,FILEVENDOR,FIL
EVERSION,PRODUCTNAME,PRODUCTVERSION,COMPANYNAME,SOFTWARETYPEID,SOFTWARECATEGORYID,CURRENTLYMETERED,DESCRIPTION
,SWCOMPLIANCETYPEID) VALUES(14127, N'GrindEQ Math Utilities (remove only)', N'-', N'-', N'-', N'-', N'-', 1, 9
, 0, N'-', 2);
java.sql.BatchUpdateException: null, message from server: "Duplicate entry ''Compare Database' for key 2"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:338)
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 ''Compare Database' for key 2"
D:\AdventNet\ME\ServiceDesk\bin>
New to ADSelfService Plus?