Hi everyone,

 

Our SDP Server crashed a few days ago and we're trying to install a new server.

 

We have got backup files which has extensions as ".data" .

 

Our server was running on Windows 2008 R2 x64 Enterprise Server and the db was MySql.

 

Build was 8.2 with 8211 build number.

 

 

Now, we have installed a fresh copy of Windows 2008 R2 x64 Enterprise. We have downloaded the latest version of SDP (8212 build) and installed it with the MS SQL 2008 Std Server config. (We have realized that there was no option for MySql with the latest build install package)

 

When we try to restore the backup file with the related .bat file under \bin directory then we're having the problem like the detailed passage below;

 

What could be the reason and solution?

 

 

 

========================================================================

D:\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 29, 2013 5:53:06 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
Sep 29, 2013 5:53:06 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
Sep 29, 2013 5:53:09 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .
Sep 29, 2013 5:53:09 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=8.2.0}, BUILD={number=8212}}
Sep 29, 2013 5:53:09 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:\manage_engine_install\backupfiles\backup_mysql_8
211_fullbackup_09_25_2013_12_12.data
File name is :  C:\manage_engine_install\backupfiles\backup_mysql_8211_fullbacku
p_09_25_2013_12_12.data
Sep 29, 2013 5:53:35 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
Sep 29, 2013 5:53:35 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
Sep 29, 2013 5:53:35 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .
Sep 29, 2013 5:53:35 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=8.2.0}, BUILD={number=8212}}
Sep 29, 2013 5:53:35 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

*************************************************************.\backup_info.xml
         Backpup data    : Wed Sep 25 12:12:12 EEST 2013
         Database name   : servicedesk
         Total Tables    : 1226
         Database Server : mysql
         Build Number    : 8211
*************************************************************

Sep 29, 2013 5:54:18 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Sep 29, 2013 5:54:18 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Sep 29, 2013 5:54:18 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]

Sep 29, 2013 5:54:18 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Sep 29, 2013 5:54:18 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Sep 29, 2013 5:54:18 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: extractLocation : file:/D:/ManageEngine/ServiceDesk/applications/extracted
/
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: startDBServer :: [true]
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: jndiName :: [MSSQLDS]
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: Final setdbhomearg :: [false]
Sep 29, 2013 5:54:19 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 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: db.home :: [D:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Sep 29, 2013 5:54:19 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://databases0:1433;DatabaseName=servicedesk;Tds
=8.0;PrepareSql=3;XaEmulation=false;]
Sep 29, 2013 5:54:19 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Sep 29, 2013 5:54:19 PM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIden
tifierFile
WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
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 29, 2013 5:54:19 PM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
SEVERE: Start DBServer operation is not supported
Active DB Server = mssql
Database connectionProp : null
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGener
ator java.lang.InstantiationException: com.adventnet.db.adapter.SQLGenerator
Database started
Backup build number not compatible with existing build
Backup build number not compatible with existing build

Sep 29, 2013 5:54:25 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@6e05b24c], sta
rtDBServer :: [true], dbProp :: {BlockingTimeoutMillis=30000, ManagedConnectionF
actoryProperties=
, Criteria=ByContainer, LocalTransactions=true, MinSize=0, Password=Password1, J
ndiName=MSSQLDS, MaxSize=20, SecurityDomainJndiName=DBPwdEncrypt, DriverClass=ne
t.sourceforge.jtds.jdbc.Driver, TrackConnectionByTx=true, IdleTimeoutMinutes=15,
 UserName=sa, ConnectionURL=jdbc:jtds:sqlserver://databases0:1433;DatabaseName=s
ervicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;}
Sep 29, 2013 5:54:25 PM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForce
Fully
SEVERE: Stop DBServer operation is not supported in Jdbc20DBAdapter
Sep 29, 2013 5:54:25 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Sep 29, 2013 5:54:25 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Sep 29, 2013 5:54:30 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB

D:\ManageEngine\ServiceDesk\bin>
========================================================================