ManageEngine ServiceDesk-PLUS: Restore Data backup failed

ManageEngine ServiceDesk-PLUS: Restore Data backup failed

Hello,
I have problem in restoring data backup when made a new fresh install at new Server with using version 8100.
Is there any way to resolve this issue?

Attached here is error copy from command:

[root@localhost bin]# sh restoreData.sh
*********************************************************************************
             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]

*********************************************************************************
Nov 17, 2016 2:56:24 AM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Nov 17, 2016 2:56:24 AM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Nov 17, 2016 2:56:26 AM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Nov 17, 2016 2:56:26 AM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=8.1.0}, BUILD={number=8100}}
Nov 17, 2016 2:56:26 AM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
You chose to open this file: /opt/ManageEngine/ServiceDesk/backup/backup_servicedesk_8100_fullbackup_09_28_2016_15_58.data
File name is :  /opt/ManageEngine/ServiceDesk/backup/backup_servicedesk_8100_fullbackup_09_28_2016_15_58.data
Nov 17, 2016 2:56:42 AM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Nov 17, 2016 2:56:42 AM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Nov 17, 2016 2:56:42 AM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Nov 17, 2016 2:56:42 AM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=8.1.0}, BUILD={number=8100}}
Nov 17, 2016 2:56:42 AM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
Extracting backup file....

Please wait extracting backup file
java.io.FileNotFoundException: ./bin/startDB.bat (No such file or directory)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.<init>(Unknown Source)
    at java.io.FileReader.<init>(Unknown Source)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:179)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:131)
    at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:186)
    at java.lang.Thread.run(Unknown Source)
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Does not contain SYSTEM in the line
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server/default/conf/datasource-configuration.xml_tmp]
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: extractLocation : file:/opt/ManageEngine/ServiceDesk/applications/extracted/
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: startDBServer :: [true]
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: jndiName :: [MySqlDS]
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: Final setdbhomearg :: [false]
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: properties sent to adapter initialization :: {jndiname=MySqlDS, name=mysql, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mysql.MysqlSQLGenerator}
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: db.home :: [/opt/ManageEngine/ServiceDesk/bin/../mysql] finally
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [useUnicode=true
characterEncoding=UTF-8
]
Nov 17, 2016 2:56:43 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:mysql://localhost:33366/servicedesk?&useUnicode=true&characterEncoding=UTF-8]
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mysql.MysqlSQLGenerator javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
Nov 17, 2016 2:56:43 AM com.adventnet.db.adapter.DBInitializer startDBServer
INFO: Command to start DB server [sh, ./bin/startDB.sh, 33366, /opt/ManageEngine/ServiceDesk/mysql/tmp]
DBHOME IS /opt/ManageEngine/ServiceDesk/mysql
DB_HOME /opt/ManageEngine/ServiceDesk/mysql   DB_PORT 33366   TMP_HOME /opt/ManageEngine/ServiceDesk/mysql/tmp
161117  2:56:43 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
161117  2:56:43 [Note] Plugin 'FEDERATED' is disabled.
161117  2:56:43  InnoDB: Started; log sequence number 0 33103672
161117  2:56:43 [ERROR] mysql.user has no `Event_priv` column at position 29
161117  2:56:43 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
161117  2:56:43 [Note] /opt/ManageEngine/ServiceDesk/mysql/bin/mysqld: ready for connections.
Version: '5.1.50-enterprise-commercial-pro'  socket: '/opt/ManageEngine/ServiceDesk/mysql/tmp/mysql.sock'  port: 33366  MySQL Enterprise Server - Pro Edition (Commercial)
Active DB Server = mysql
Database connectionProp : useUnicode=true
characterEncoding=UTF-8

Database started

*************************************************************./backup_info.xml
     Backpup data    : Mon Aug 29 15:58:03 MYT 2016
     Database name   : servicedesk
     Total Tables    : 1028
     Database Server : mysql
     Build Number    : 8100
*************************************************************



Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)


Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
==QUERY = INSERT INTO accountdefinition (ORG_ID,LOG_LOGO,HEAD_LOGO,ORG_NAME,HASATTACHMENT,LOGIN_URI,SUPPORT_EMAIL,DEFAULTSITEID) VALUESnull
java.sql.BatchUpdateException: null,  message from server: "Unknown column 'DEFAULTSITEID' in 'field list'"
    at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:709)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:278)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:131)
    at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:186)
    at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: null,  message from server: "Unknown column 'DEFAULTSITEID' in 'field list'"
    at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:709)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:278)
    at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:131)
    at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:186)
    at java.lang.Thread.run(Unknown Source)
Unable to restore database : null,  message from server: "Unknown column 'DEFAULTSITEID' in 'field list'"
null,  message from server: "Unknown column 'DEFAULTSITEID' in 'field list'"

Nov 17, 2016 2:56:52 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mysql.MysqlDBAdapter@1f9f0f2], startDBServer :: [true], dbProp :: {Password=null, ConnectionProperties=useUnicode=true
characterEncoding=UTF-8
, TransactionIsolation=TRANSACTION_READ_COMMITTED, DriverClass=org.gjt.mm.mysql.Driver, UserName=root, ConnectionURL=jdbc:mysql://localhost:33366/servicedesk}
Nov 17, 2016 2:56:52 AM com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownDB
INFO: connectionURL :: [jdbc:mysql://localhost:33366/servicedesk], userName :: [root], password :: [null]
Nov 17, 2016 2:56:52 AM com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownDB
INFO: Stopping MySQL Server ...
Nov 17, 2016 2:56:52 AM com.adventnet.db.adapter.DBInitializer stopDBServer
INFO: Command to stop DB server [sh, ./bin/stopDB.sh, 33366, root, /opt/ManageEngine/ServiceDesk/mysql/tmp]
161117  2:56:52 [Note] /opt/ManageEngine/ServiceDesk/mysql/bin/mysqld: Normal shutdown

161117  2:56:52  InnoDB: Starting shutdown...
161117  2:56:54  InnoDB: Shutdown completed; log sequence number 0 34148339
161117  2:56:54 [Note] /opt/ManageEngine/ServiceDesk/mysql/bin/mysqld: Shutdown complete

Nov 17, 2016 2:56:55 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Nov 17, 2016 2:56:55 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Nov 17, 2016 2:57:00 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB

                New to ADManager Plus?

                  New to ADSelfService Plus?