Migration to MSSQL
Hi.
I am trying to migrate from Postgree to MSSQL.
I have used ChangeDBServer.bat and could successfully connect and create the database.
However when I try to restore the data, I got this error on console and the process never finishes.
jan 18, 2021 3:25:39 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
jan 18, 2021 3:25:39 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
jan 18, 2021 3:25:50 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .\
jan 18, 2021 3:25:50 PM com.adventnet.servicedesk.server.utils.SDDataManager rea
dBuildData
INFO: Root Directory in readBuildData method of SDDataManagerClass :---> .\
jan 18, 2021 3:25:50 PM com.adventnet.servicedesk.server.utils.SDDataManager rea
dBuildData
INFO: Reading Build Info file :---> .\\conf\buildInfo.xml
jan 18, 2021 3:25:50 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=11.1}, BUILD={number=11137}}
jan 18, 2021 3:25:50 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=O
pManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManag
er Plus}}
jan 18, 2021 3:25:56 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to set the standAlone param as : true
jan 18, 2021 3:25:56 PM com.adventnet.servicedesk.server.utils.SDDataManager set
StandAlone
INFO: Going to reset rootDir using server.dir
jan 18, 2021 3:25:56 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: .\
jan 18, 2021 3:25:56 PM com.adventnet.servicedesk.server.utils.SDDataManager rea
dBuildData
INFO: Root Directory in readBuildData method of SDDataManagerClass :---> .\
jan 18, 2021 3:25:56 PM com.adventnet.servicedesk.server.utils.SDDataManager rea
dBuildData
INFO: Reading Build Info file :---> .\\conf\buildInfo.xml
jan 18, 2021 3:25:56 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=11.1}, BUILD={number=11137}}
jan 18, 2021 3:25:56 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=O
pManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManag
er Plus}}
jan 18, 2021 3:26:05 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing all product-config files
jan 18, 2021 3:26:05 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing C:\ManageEngine\ServiceDesk\.\conf\product-config.xml
jan 18, 2021 3:26:05 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing C:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
jan 18, 2021 3:26:05 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration running :: false
jan 18, 2021 3:26:05 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration dest DB :: false
jan 18, 2021 3:26:06 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing all product-config files
jan 18, 2021 3:26:06 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing C:\ManageEngine\ServiceDesk\.\conf\product-config.xml
jan 18, 2021 3:26:06 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing C:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
jan 18, 2021 3:26:06 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing all product-config files
jan 18, 2021 3:26:06 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing C:\ManageEngine\ServiceDesk\.\conf\product-config.xml
jan 18, 2021 3:26:06 PM com.adventnet.persistence.ConfigurationParser$1 resolveE
ntity
INFO: Processing C:\ManageEngine\ServiceDesk\.\conf\customer-config.xml
jan 18, 2021 3:26:06 PM com.zoho.framework.utils.crypto.CryptoUtil setEnDecryptI
nstance
INFO: Already crypt instance has been set and hence this [com.zoho.framework.uti
ls.crypto.EnDecryptAES256Impl@62e292c2] is ignored
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer getDBPa
ramsFilePath
INFO: Reading .\conf\database_params.conf
jan 18, 2021 3:26:07 PM com.adventnet.persistence.util.DCManager validateDCProps
INFO: All valid properties are available for dctype :: defaultdc, database :: po
stgres
jan 18, 2021 3:26:07 PM com.adventnet.persistence.util.DCManager initialize
INFO: dc-types defined in dynamic-column-types.props :: [defaultdc]
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer initial
izeRelationalAPI
INFO: Loading UDTs from directory :: .\conf\udt
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: AGE
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: CURRENCY
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: CURRENCYSYMBOL
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: DAYS
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: GENDER
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: HONORIFIC
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: JSONSTRING
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: LENGTH
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: MONTHS
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: SERIAL
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: UUID
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager lo
adDataTypes
INFO: Loaded data type :: WEIGHT
jan 18, 2021 3:26:07 PM com.adventnet.db.persistence.metadata.DataTypeManager in
itialize
SEVERE: DataTypes initialized from :: .\conf\udt
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer getDBPa
ramsFilePath
INFO: Reading .\conf\database_params.conf
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer loadDBP
arams
INFO: Driver Name :: com.microsoft.sqlserver.jdbc.SQLServerDriver
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer loadDBP
arams
INFO: Connection URL :: jdbc:sqlserver://EBR-NTS14:1433;DatabaseName=servicedesk
;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=false;loginTimeout=5;socketTimeo
ut=1200000
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer loadDBP
arams
INFO: Username :: sa
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer loadDBP
arams
INFO: Min Size :: 5
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer loadDBP
arams
INFO: Max Size :: 40
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer loadDBP
arams
INFO: Transaction Isolation :: TRANSACTION_READ_COMMITTED
jan 18, 2021 3:26:07 PM com.zoho.cp.ConnectionCreator initialize
INFO: Socket Factory className--null
jan 18, 2021 3:26:07 PM com.adventnet.ds.DefaultDataSourcePlugIn getDataSource
INFO: DataSourcecom.zoho.cp.TxDataSource@2ea091e9
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer createA
rchiveAdapter
INFO: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer createA
rchiveAdapter
INFO: Storage Adapter class ::: null
jan 18, 2021 3:26:07 PM com.adventnet.db.api.RelationalAPI <clinit>
SEVERE: haltjvm.on.dbcrash is set to [false]
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.Jdbc20DBAdapter getShutDownStri
ngs
INFO: shutDownStrings :: []
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTem
plates
INFO: Loading the function patterns from the file :: [.\conf\Helpdesk\custom_mss
ql_functionpatterns.txt]
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTem
plates
INFO: Loading the function patterns from the file :: [.\conf\Persistence\mssql_f
unctionpatterns.txt]
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration running :: false
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: isDBMigration dest DB :: false
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer initial
izeRelationalAPI
INFO: DataSourcePlugIn is initialized successfully
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer createD
estinationDataBase
INFO: create.db is :: null
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer getTemp
latesReplacedUrl
INFO: Template replaced url :: jdbc:sqlserver://EBR-NTS14:1433;DatabaseName=serv
icedesk;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=false;loginTimeout=5;sock
etTimeout=1200000
jan 18, 2021 3:26:07 PM com.manageengine.db.adapter.mssql.SDMssqlDBAdapter valid
ateVersion
INFO: Inside sql version validate method ####
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleC
ollation
INFO: Incoming collation string is Latin1_General_CI_AS
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleC
ollation
INFO: Collation String constructed is Latin1_General_CS_A%
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleC
ollation
INFO: The Toggle collation string is Latin1_General_CS_AI
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlUuidDTAdapter valida
teVersion
INFO: Mssql version : 11.00.3128
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlUuidDTAdapter valida
teVersion
INFO: This version of Mysql :: 11.00.3128 is supported for UUID
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.AbstractRestoreHandler doRestor
eSanityTesting
INFO: Restore process fully completed.
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.Jdbc20DBAdapter getDBProps
INFO: splitConnectionURL :: {charset=utf-8, Tds=8.0, Server=EBR-NTS14, Port=1433
, DatabaseName=servicedesk, urlWithoutProps=jdbc:sqlserver://EBR-NTS14:1433, jdb
curl_props_separator=;, url_props_delimiter=;, socketTimeout=1200000, XaEmulatio
n=false, urlProps={Tds=8.0, XaEmulation=false, PrepareSql=3, DatabaseName=servic
edesk, loginTimeout=5, socketTimeout=1200000, charset=utf-8}, DBName=servicedesk
, loginTimeout=5, properties={charset=utf-8, DatabaseName=servicedesk, DBName=se
rvicedesk, socketTimeout=1200000, PrepareSql=3, XaEmulation=false, Tds=8.0, Port
=1433, Server=EBR-NTS14, loginTimeout=5}, PrepareSql=3}
jan 18, 2021 3:26:07 PM com.adventnet.persistence.PersistenceInitializer getTemp
latesReplacedUrl
INFO: Template replaced url :: jdbc:sqlserver://EBR-NTS14:1433;DatabaseName=serv
icedesk;charset=utf-8;Tds=8.0;PrepareSql=3;XaEmulation=false;loginTimeout=5;sock
etTimeout=1200000
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter prepareDat
abase
INFO: Master Key is already Created
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter logDatabas
eDetails
INFO: DB Version :: 11.0
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter logDatabas
eDetails
INFO: DB Architecture :: 64
jan 18, 2021 3:26:07 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter logDatabas
eDetails
INFO: There are 2 files. [Data file : D:\SQLServer\MSSQL11.MSSQLSERVER\MSSQL\DAT
A\servicedesk.mdf, Log file : D:\SQLServer\MSSQL11.MSSQLSERVER\MSSQL\DATA\servi
cedesk_log.ldf, ]
jan 18, 2021 3:26:07 PM com.adventnet.persistence.xml.DynamicValueHandlerReposit
ry parse
INFO: Going to load DVH :: jar:file:/C:/ManageEngine/ServiceDesk/lib/AdvPersiste
nce.jar!/com/adventnet/db/persistence/metadata/conf/dynamic-value-handlers.xml
Exception in thread "Thread-4" java.lang.NoClassDefFoundError: org/apache/common
s/codec/binary/Hex
at com.adventnet.iam.security.SecurityUtil.<clinit>(SecurityUtil.java:16
2)
at com.adventnet.persistence.xml.DynamicValueHandlerRepositry.loadDocume
nt(DynamicValueHandlerRepositry.java:154)
at com.adventnet.persistence.xml.DynamicValueHandlerRepositry.parse(Dyna
micValueHandlerRepositry.java:73)
at com.adventnet.persistence.PersistenceInitializer.initializePersistenc
e(PersistenceInitializer.java:757)
at com.adventnet.persistence.PersistenceInitializer.initializeMickey(Per
sistenceInitializer.java:2267)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:350)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:143)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a: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:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 9 more
I am stopping and reverting changes to get the system operational again.
Please instruct on how to fix this and restore to MSSQL.
Thanks.
Thiago.