Error while trying to instantiate SQLGeneratir
hi
say me please , what is wrong ?
i get backup from 9019 (9.46 Mb) and want to restore (to 9021)
PS 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]
*********************************************************************************
Oct 17, 2014 12:46:20 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Oct 17, 2014 12:46:20 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Oct 17, 2014 12:46:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Oct 17, 2014 12:46:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=9.0}, BUILD={number=9021}}
Oct 17, 2014 12:46:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Se
rviceDesk Plus}, ADMANAGER={name=ADManager Plus}}
You chose to open this file: C:\Users\Ozgur.Shahin\Desktop\backup_mssql_9019_database_10_13_2014_14_48\backup_mssql_9019
_database_10_13_2014_14_48_part_1.data
File name is : C:\Users\Ozgur.Shahin\Desktop\backup_mssql_9019_database_10_13_2014_14_48\backup_mssql_9019_database_10_
13_2014_14_48_part_1.data
Oct 17, 2014 12:46:29 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Oct 17, 2014 12:46:29 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Oct 17, 2014 12:46:29 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Oct 17, 2014 12:46:29 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=9.0}, BUILD={number=9021}}
Oct 17, 2014 12:46:29 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Se
rviceDesk Plus}, ADMANAGER={name=ADManager Plus}}
Extracting backup file....
Please wait extracting backup file
Please wait extracting backup file
*************************************************************.\backup_info.xml
Backpup data : Mon Oct 13 14:48:57 EAT 2014
Database name : servicedesk
Total Tables : 1934
Database Server : mssql
Build Number : 9019
*************************************************************
Oct 17, 2014 12:46:41 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Oct 17, 2014 12:46:41 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Oct 17, 2014 12:46:41 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]
Oct 17, 2014 12:46:41 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Oct 17, 2014 12:46:41 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Oct 17, 2014 12:46:41 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Oct 17, 2014 12:46:42 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: extractLocation : file:/C:/ManageEngine/ServiceDesk/applications/extracted/
Oct 17, 2014 12:46:42 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: startDBServer :: [true]
Oct 17, 2014 12:46:42 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: jndiName :: [MSSQLDS]
Oct 17, 2014 12:46:42 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Oct 17, 2014 12:46:42 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: Final setdbhomearg :: [false]
Oct 17, 2014 12:46:42 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql, setdbhomearg=false, sqlgenerator=com.a
dventnet.db.adapter.mssql.MssqlSQLGenerator}
Oct 17, 2014 12:46:42 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: db.home :: [C:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally
Oct 17, 2014 12:46:43 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Oct 17, 2014 12:46:43 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://SRV_SQL_SERVER:1433;DatabaseName=servicedesktest;Tds=8.0;PrepareSql=3;XaEmulation=false
;]
Oct 17, 2014 12:46:43 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Oct 17, 2014 12:46:43 PM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIdentifierFile
WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.MssqlSQLGenerator javax.naming.NoInitialCo
ntextException: Need to specify class name in environment or system property, or as an applet parameter, or in an applic
ation resource file: java.naming.factory.initial
Oct 17, 2014 12:46:43 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.SQLGenerator java.lang.InstantiationException: c
om.adventnet.db.adapter.SQLGenerator
Database started
Backup build number not compatible with existing build
Backup build number not compatible with existing build
Oct 17, 2014 12:46:52 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@dc160cb], startDBServer :: [true], dbProp :: {ManagedC
onnectionFactoryProperties=
, TrackConnectionByTx=true, Password=PASSWORD, MaxSize=20, SecurityDomainJndiName=DBPwdEncrypt, UserName=USERNAME C
onnectionURL=jdbc:jtds:sqlserver://SRV_SQL_SERVER:1433;DatabaseName=servicedesktest;Tds=8.0;PrepareSql=3;XaEmulation=false;
, BlockingTimeoutMillis=30000, Criteria=ByContainer, DriverClass=net.sourceforge.jtds.jdbc.Driver, JndiName=MSSQLDS, Loc
alTransactions=true, IdleTimeoutMinutes=15, MinSize=0}
Oct 17, 2014 12:46:52 PM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForceFully
SEVERE: Stop DBServer operation is not supported in Jdbc20DBAdapter
Oct 17, 2014 12:46:52 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Oct 17, 2014 12:46:52 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Oct 17, 2014 12:46:57 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB
PS C:\ManageEngine\ServiceDesk\bin>