Error during database restoring
There was a necessity for transition from MYSQL DB Server to MSSQL. In ServiceDesk 7508 (MYSQL) the backup copy has been made. Then the program has been completely reinstalled. During the installation was configured to connect to the new database server. ServiceDesk with the default database starts successfully, but when restoring data from a backup error occurred (see log below).
********************************************************************************
* 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: D:\backup_servicedesk_7508_fullbackup_06_10_2009_14 _00.data
File name is : D:\backup_servicedesk_7508_fullbackup_06_10_2009_14_00.data
requestScheme is httpPlease wait extracting backup file
10.06.2009 14:37:23 com.adventnet.j2ee.deployment.service.internal.JarExtractorextract INFO: Extraction for D:\backup_servicedesk_7508_fullbackup_06_10_2009_14_00.data
to C:\AdventNet\ME\ServiceDesk\bin\..
Active DB Server = mssql
Database connectionProp : null
Database started
*************************************************************
Backpup data : Wed Jun 10 14:00:10 AZST 2009
Database name : servicedesk
Total Tables : 851
DB - Server : mysql
Build Number : 7508
*************************************************************
10.06.2009 14:37:38 com.adventnet.servicedesk.server.utils.SDDataManager
INFO: rootDir :: ..
10.06.2009 14:37:38 com.adventnet.servicedesk.server.utils.SDDataManager
INFO: netutilsData :: {RELEASE={version=7.5.0}, BUILD={number=7508}}
10.06.2009 14:37:38 com.adventnet.servicedesk.server.utils.SDDataManager
INFO: rebrandData :: {OPMANAGER={name=OpManager},
PRODUCT={name=AdventNet Manage Engine ServiceDesk Plus},
ADMANAGER={name=ADManager}}
Please wait !
Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
==================
QUERY = INSERT INTO holidaydefinition (HOLIDAYDEFINITIONID,HOLIDAYDATE,DESCRIPTION,SITEID,ISRECURRING) VALUESnull java.sql.BatchUpdateException: Data truncation
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:404)
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) java.sql.BatchUpdateException: Data truncation
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:404)
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 : Data truncation