Data Restoration
Hello,
Jedidia Andriamanampisoa
I've tried to restore database after installing a new version of service desk plus but I've faced of this error, could you please advise?
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
D:\Users\jandriam-ext>c:
C:\>cd ManageEngine
C:\ManageEngine>cd ServiceDesk
C:\ManageEngine\ServiceDesk>cd bin
C:\ManageEngine\ServiceDesk\bin>changeDBServer.bat
"========================================================"
""
"Usage : changeDBServer.bat --console [for non GUI user]"
"Usage : changeDBServer.bat [for GUI user]"
""
"========================================================"
Sep 19, 2013 2:22:06 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: C:\ManageEngine\ServiceDesk\bin\..\
Sep 19, 2013 2:22:06 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=8.1.0}, BUILD={number=8109}}
Sep 19, 2013 2:22:06 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser
viceDesk Plus}, ADMANAGER={name=ADManager}}
Available Instances : ♣^ ServerName;MGPSRVDSK03;InstanceName;MSSQLSERVER;IsClust
ered;No;Version;10.0.1600.22;tcp;1433;;
♣^ ServerName;MGPSRVDSK03;InstanceName;MSSQLSERVER;IsClustered;No;Version;10.0.1
600.22;tcp;1433
========================================================
database = servicedesk_upgrade
========================================================
========================================================
Product version from Installed location : 8109
Product version from database server : 8109
========================================================
C:\ManageEngine\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]
********************************************************************************
*
Sep 19, 2013 2:22:21 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
Sep 19, 2013 2:22:21 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
Sep 19, 2013 2:22:59 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .
Sep 19, 2013 2:22:59 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=8.1.0}, BUILD={number=8109}}
Sep 19, 2013 2:22:59 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser
viceDesk Plus}, ADMANAGER={name=ADManager}}
You chose to open this file: C:\ManageEngine\ServiceDesk\backup\backup_mssql_810
9_fullbackup_09_09_2013_13_07.data
File name is : C:\ManageEngine\ServiceDesk\backup\backup_mssql_8109_fullbackup_
09_09_2013_13_07.data
Sep 19, 2013 2:23:03 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
Sep 19, 2013 2:23:03 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
Sep 19, 2013 2:23:03 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .
Sep 19, 2013 2:23:03 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=8.1.0}, BUILD={number=8109}}
Sep 19, 2013 2:23:03 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser
viceDesk Plus}, ADMANAGER={name=ADManager}}
Extracting backup file....
Please wait extracting backup file
Replacing for Mysql 5.1.50
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: extractLocation : file:/C:/ManageEngine/ServiceDesk/applications/extracted
/
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: startDBServer :: [true]
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: jndiName :: [MSSQLDS]
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: Final setdbhomearg :: [false]
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql
, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mssql.MssqlSQLGenera
tor}
Sep 19, 2013 2:32:52 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: db.home :: [.\mysql] finally
Sep 19, 2013 2:32:54 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Sep 19, 2013 2:32:54 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://mgpsrvdsk03:1433;DatabaseName=servicedesk_up
grade;Tds=8.0;PrepareSql=3;XaEmulation=false;]
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.Ms
sqlSQLGenerator javax.naming.NoInitialContextException: Need to specify class na
me in environment or system property, or as an applet parameter, or in an applic
ation resource file: java.naming.factory.initial
Sep 19, 2013 2:32:54 PM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
SEVERE: Start DBServer operation is not supported
Active DB Server = mssql
Database connectionProp : null
Database started
java.lang.Exception: backup-info.xml not found : .\backup_info.xml
at com.adventnet.servicedesk.tools.RestoreSDBackup.getBuildInfo(RestoreS
DBackup.java:925)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:243)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:131)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:186)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : backup-info.xml not found : .\backup_info.xml
backup-info.xml not found : .\backup_info.xml
Sep 19, 2013 2:33:00 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@1192059], star
tDBServer :: [true], dbProp :: {Password=admin01, DriverClass=net.sourceforge.jt
ds.jdbc.Driver, UserName=sa, ConnectionURL=jdbc:jtds:sqlserver://mgpsrvdsk03:143
3;DatabaseName=servicedesk_upgrade;Tds=8.0;PrepareSql=3;XaEmulation=false;}
Sep 19, 2013 2:33:00 PM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForce
Fully
SEVERE: Stop DBServer operation is not supported in Jdbc20DBAdapter
Sep 19, 2013 2:33:00 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Sep 19, 2013 2:33:00 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Sep 19, 2013 2:33:05 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB
Thanks,