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 ADSelfService Plus?