Error while restoring SDP database backup in a new environment (SQL Server 2017)
I am trying to move SDP database in a new environment. Backup using backupData.bat --trimmed went well. But when tried to restore data in new environment, I am getting error. Following is the output. Need help here please.
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]
*********************************************************************************
Jan 11, 2020 5:11:08 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Jan 11, 2020 5:11:09 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Jan 11, 2020 5:11:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .\
Jan 11, 2020 5:11:22 PM com.adventnet.servicedesk.server.utils.SDDataManager readBuildData
INFO: Root Directory in readBuildData method of SDDataManagerClass :---> .\
Jan 11, 2020 5:11:22 PM com.adventnet.servicedesk.server.utils.SDDataManager readBuildData
INFO: Reading Build Info file :---> .\\conf\buildInfo.xml
Jan 11, 2020 5:11:23 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=11.0}, BUILD={number=11005}}
Jan 11, 2020 5:11:23 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADM
ANAGER={name=ADManager Plus}}
You chose to open this file: D:\ManageEngine\ServiceDesk\trimmedbackup\backup_mssql_11005_database_01_11_2020_16_00\backup_mssql_11005_datab
ase_01_11_2020_16_00_part_1.data
File name is : D:\ManageEngine\ServiceDesk\trimmedbackup\backup_mssql_11005_database_01_11_2020_16_00\backup_mssql_11005_database_01_11_202
0_16_00_part_1.data
Jan 11, 2020 5:12:14 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Jan 11, 2020 5:12:14 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Jan 11, 2020 5:12:14 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .\
Jan 11, 2020 5:12:14 PM com.adventnet.servicedesk.server.utils.SDDataManager readBuildData
INFO: Root Directory in readBuildData method of SDDataManagerClass :---> .\
Jan 11, 2020 5:12:14 PM com.adventnet.servicedesk.server.utils.SDDataManager readBuildData
INFO: Reading Build Info file :---> .\\conf\buildInfo.xml
Jan 11, 2020 5:12:14 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=11.0}, BUILD={number=11005}}
Jan 11, 2020 5:12:14 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADM
ANAGER={name=ADManager Plus}}
Extracting backup file....
Jan 11, 2020 5:13:55 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration running :: false
Jan 11, 2020 5:13:55 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration dest DB :: false
Database started
*************************************************************.\\backup_info.xml
Backpup data : Sat Jan 11 16:00:21 GST 2020
Database name : ServiceDeskPlus
Total Tables : 1718
Database Server : mssql
Build Number : 11005
Backupid : 1578744021891
*************************************************************
Please wait extracting backup file \backup_mssql_11005_database_01_11_2020_16_00_part_1.data
--Size: 32MB
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
INFO: Processing all product-config files
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
INFO: Processing D:\ManageEngine\ServiceDesk\.\conf\product-config.xml
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
INFO: Processing D:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
INFO: Processing all product-config files
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
INFO: Processing D:\ManageEngine\ServiceDesk\.\conf\product-config.xml
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.ConfigurationParser$1 resolveEntity
INFO: Processing D:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
Jan 11, 2020 5:14:29 PM com.zoho.framework.utils.crypto.EnDecryptUtil initializeEnDecryptionMap
INFO: Enforce encryption - true
Jan 11, 2020 5:14:29 PM com.zoho.framework.utils.crypto.CryptoUtil setEnDecryptInstance
INFO: Already crypt instance has been set and hence this [com.zoho.framework.utils.crypto.EnDecryptAES256Impl@71a51d64] is ignored
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer getDBParamsFilePath
INFO: Reading .\conf\database_params.conf
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.util.DCManager validateDCProps
INFO: All valid properties are available for dctype :: defaultdc, database :: postgres
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.util.DCManager initialize
INFO: dc-types defined in dynamic-column-types.props :: [defaultdc]
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer initializeRelationalAPI
INFO: Loading UDTs from directory :: .\conf\udt
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: AGE
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: CURRENCY
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: CURRENCYSYMBOL
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: DAYS
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: GENDER
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: HONORIFIC
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: JSONSTRING
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: LENGTH
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: MONTHS
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: SERIAL
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: UUID
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager loadDataTypes
INFO: Loaded data type :: WEIGHT
Jan 11, 2020 5:14:29 PM com.adventnet.db.persistence.metadata.DataTypeManager initialize
SEVERE: DataTypes initialized from :: .\conf\udt
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer getDBParamsFilePath
INFO: Reading .\conf\database_params.conf
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer loadDBParams
INFO: Driver Name :: com.microsoft.sqlserver.jdbc.SQLServerDriver
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer loadDBParams
INFO: Connection URL :: jdbc:sqlserver://DBSRV087:1433;DatabaseName=ServiceDeskDB;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=false;log
inTimeout=5;socketTimeout=1200000
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer loadDBParams
INFO: Username :: ServiceDesk
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer loadDBParams
INFO: Min Size :: 5
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer loadDBParams
INFO: Max Size :: 40
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer loadDBParams
INFO: Transaction Isolation :: TRANSACTION_READ_COMMITTED
Jan 11, 2020 5:14:29 PM com.zoho.cp.ConnectionCreator initialize
INFO: Socket Factory className--null
Jan 11, 2020 5:14:29 PM com.adventnet.ds.DefaultDataSourcePlugIn getDataSource
INFO: DataSourcecom.zoho.cp.TxDataSource@1aa53875
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
INFO: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
INFO: Storage Adapter class ::: null
Jan 11, 2020 5:14:29 PM com.adventnet.db.api.RelationalAPI <clinit>
SEVERE: haltjvm.on.dbcrash is set to [false]
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter getShutDownStrings
INFO: shutDownStrings :: []
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
INFO: Loading the function patterns from the file :: [.\conf\Helpdesk\custom_mssql_functionpatterns.txt]
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
INFO: Loading the function patterns from the file :: [.\conf\Persistence\mssql_functionpatterns.txt]
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration running :: false
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration dest DB :: false
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer initializeRelationalAPI
INFO: DataSourcePlugIn is initialized successfully
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer createDestinationDataBase
INFO: create.db is :: null
Jan 11, 2020 5:14:29 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
INFO: Template replaced url :: jdbc:sqlserver://DBSRV087:1433;DatabaseName=ServiceDeskDB;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=fa
lse;loginTimeout=5;socketTimeout=1200000
Jan 11, 2020 5:14:29 PM com.manageengine.db.adapter.mssql.SDMssqlDBAdapter validateVersion
INFO: Inside sql version validate method ####
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
INFO: Incoming collation string is SQL_Latin1_General_CP1_CI_AS
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
INFO: Collation String constructed is SQL_Latin1_General_CP1_CS_A%
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
INFO: The Toggle collation string is SQL_Latin1_General_CP1_CS_AS
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.mssql.MssqlUuidDTAdapter validateVersion
INFO: Mssql version : 14.00.3257
Jan 11, 2020 5:14:29 PM com.adventnet.db.adapter.mssql.MssqlUuidDTAdapter validateVersion
INFO: This version of Mysql :: 14.00.3257 is supported for UUID
Jan 11, 2020 5:14:30 PM com.adventnet.db.adapter.AbstractRestoreHandler doRestoreSanityTesting
INFO: Restore process fully completed.
Jan 11, 2020 5:14:30 PM com.adventnet.db.adapter.Jdbc20DBAdapter getDBProps
INFO: splitConnectionURL :: {charset=utf-8, Tds=8.0, Server=DBSRV087, Port=1433, DatabaseName=ServiceDeskDB, urlWithoutProps=jdbc:sqlserve
r://DBSRV087:1433, jdbcurl_props_separator=;, url_props_delimiter=;, socketTimeout=1200000, XaEmulation=false, urlProps={Tds=8.0, XaEmulat
ion=false, PrepareSql=3, DatabaseName=ServiceDeskDB, loginTimeout=5, socketTimeout=1200000, charset=utf-8}, loginTimeout=5, properties={char
set=utf-8, DatabaseName=ServiceDeskDB, socketTimeout=1200000, PrepareSql=3, XaEmulation=false, Tds=8.0, Port=1433, Server=DBSRV087, loginT
imeout=5}, PrepareSql=3}
Jan 11, 2020 5:14:30 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
INFO: Template replaced url :: jdbc:sqlserver://DBSRV087:1433;DatabaseName=ServiceDeskDB;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=fa
lse;loginTimeout=5;socketTimeout=1200000
Jan 11, 2020 5:14:30 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter prepareDatabase
INFO: Master Key is already Created
Jan 11, 2020 5:14:30 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter logDatabaseDetails
INFO: DB Version :: 14.0
Jan 11, 2020 5:14:30 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter logDatabaseDetails
INFO: DB Architecture :: 64
Jan 11, 2020 5:14:30 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter logDatabaseDetails
INFO: There are 2 files. [Data file : D:\MSSQL\Data\ServiceDeskDB.mdf, Log file : L:\MSSQL\Data\ServiceDeskDB_log.ldf, ]
Jan 11, 2020 5:14:30 PM com.adventnet.persistence.xml.DynamicValueHandlerRepositry parse
INFO: Going to load DVH :: jar:file:/D:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/dynamic-
value-handlers.xml
Time Taken: 2 min 15 seconds
stopping DB Server >>>>> true
Exception in thread "Thread-5" java.lang.NoClassDefFoundError: org/apache/commons/codec/binary/Hex
at com.adventnet.iam.security.SecurityUtil.<clinit>(SecurityUtil.java:147)
at com.adventnet.persistence.xml.DynamicValueHandlerRepositry.loadDocument(DynamicValueHandlerRepositry.java:154)
at com.adventnet.persistence.xml.DynamicValueHandlerRepositry.parse(DynamicValueHandlerRepositry.java:73)
at com.adventnet.persistence.PersistenceInitializer.initializePersistence(PersistenceInitializer.java:756)
at com.adventnet.persistence.PersistenceInitializer.initializeMickey(PersistenceInitializer.java:2257)
at com.adventnet.persistence.PersistenceInitializer.initializeMickey(PersistenceInitializer.java:2245)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:443)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:128)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.codec.binary.Hex
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 10 more
Jan 11, 2020 5:44:29 PM com.zoho.cp.ConnectionPool log
INFO: ClusterIP:DBSRV087 Idle Connection Removed from the pool: {PhysicalConnection :: ConnectionID:2 ClientConnectionId: 25a5e4af-2f47-46
83-98f2-3369c13009ae, isUsed :: false, isValid :: true, stackTrace :: } Idle for more than 30[mins]
D:\ManageEngine\ServiceDesk\bin>