Hi,

 

We have been using Service Desk Plus for years,now on our server we have SDP version 9 build 9002( last version ) with MSSQL database.

We have decided to change our server , therfore we installed the SDP version 9 build 9002 on new server (same version with same database config) and tried  to restore our backup from old server on the new one.

But it just starts with extractng backup file and finishes unexpectedly.

 

Please help in this regard,

 

the log file is as follows

 

********************************************************************************
*
                         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]

********************************************************************************
*
Mar 4, 2014 11:44:59 AM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
Mar 4, 2014 11:44:59 AM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
Mar 4, 2014 11:45:01 AM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .
Mar 4, 2014 11:45:01 AM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=9.0}, BUILD={number=9002}}
Mar 4, 2014 11:45:01 AM 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: \\servicedesk\backup\backup_mssql_9002_fullbackup_0
3_04_2014_10_53.data
File name is :  \\servicedesk\backup\backup_mssql_9002_fullbackup_03_04_2014_10_
53.data
Mar 4, 2014 11:45:31 AM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
Mar 4, 2014 11:45:31 AM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
Mar 4, 2014 11:45:31 AM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .
Mar 4, 2014 11:45:31 AM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=9.0}, BUILD={number=9002}}
Mar 4, 2014 11:45:31 AM 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    : Tue Mar 04 10:53:27 GMT+03:30 2014
         Database name   : servicedesk
         Total Tables    : 1317
         Database Server : mssql
         Build Number    : 9002
*************************************************************

Mar 4, 2014 12:06:39 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Mar 4, 2014 12:06:42 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Mar 4, 2014 12:06:46 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]

Mar 4, 2014 12:06:51 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Mar 4, 2014 12:06:54 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Mar 4, 2014 12:06:54 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Mar 4, 2014 12:06:54 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: extractLocation : file:/C:/ManageEngine/ServiceDesk/applications/extracted

Mar 4, 2014 12:06:54 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: startDBServer :: [true]
Mar 4, 2014 12:06:54 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: jndiName :: [MSSQLDS]
Mar 4, 2014 12:06:54 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Mar 4, 2014 12:06:54 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: Final setdbhomearg :: [false]
Mar 4, 2014 12:06:54 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}
Mar 4, 2014 12:06:55 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstan
tiateDB
INFO: db.home :: [C:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally
Mar 4, 2014 12:06:56 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Mar 4, 2014 12:06:56 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://spdb:1433;DatabaseName=servicedesk2;Tds=8.0;
PrepareSql=3;XaEmulation=false;]
Mar 4, 2014 12:06:56 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Mar 4, 2014 12:06:56 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
Mar 4, 2014 12:06:56 PM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
SEVERE: Start DBServer operation is not supported
 

**********************************************************************************************************