Hi,
I'm trying to migrate OpManagere database between two MSSQL servers. When I change SQL server in DBconfiguration.bat, process Opmanager doesn't start.
Can You help me with this operation?
Here is the log serverout:
[14:03:01:539]|[10-12-2016]|[com.adventnet.mfw.logging.LoggerUtil]|[INFO]|[17]: Reinitializing logging.properties|
[14:03:01:570]|[10-12-2016]|[com.adventnet.mfw.logging.LoggerUtil]|[INFO]|[17]: Properties files merged. Merged file created at ::: ..\conf\merged-logging.properties|
[14:03:01:820]|[10-12-2016]|[com.adventnet.mfw.Server]|[INFO]|[17]: Creating new Server instance|
[14:03:01:820]|[10-12-2016]|[com.adventnet.me.opmanager.server.mfw.OpmServer]|[INFO]|[17]: Creating new OpmServer instance|
[14:03:02:180]|[10-12-2016]|[com.adventnet.persistence.ConfigurationParser]|[INFO]|[17]: Processing C:\MANAGE~1\OPMANA~1\bin\..\conf\Persistence\DBconfig.xml|
[14:03:02:305]|[10-12-2016]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[19]: Starting HandShakeServer...|
[14:03:02:305]|[10-12-2016]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[19]: Writing HandShakeServer port [57384] in .lock file|
[14:03:02:305]|[10-12-2016]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[19]: HandShakeServer listening port :: 57384|
[14:03:02:305]|[10-12-2016]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[19]: Waiting for client connection...|
[14:03:02:461]|[10-12-2016]|[com.adventnet.persistence.ConfigurationParser]|[INFO]|[17]: Processing C:\MANAGE~1\OPMANA~1\bin\..\conf\Persistence\DBconfig.xml|
[14:03:02:695]|[10-12-2016]|[com.zoho.framework.utils.crypto.EnDecrypt]|[SEVERE]|[17]: Encryption failed|
[14:03:02:695]|[10-12-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[17]: Reading ..\conf\database_params.conf |
[14:03:02:711]|[10-12-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[17]: Reading ..\conf\database_params.conf |
[14:03:02:836]|[10-12-2016]|[com.zoho.cp.ConnectionCreator]|[INFO]|[17]: Socket Factory className--null|
[14:03:02:867]|[10-12-2016]|[com.adventnet.ds.DefaultDataSourcePlugIn]|[INFO]|[17]: DataSourcecom.zoho.cp.TxDataSource@5d59e6f1|
[14:03:02:867]|[10-12-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[17]: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter|
[14:03:02:867]|[10-12-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[17]: Storage Adapter class ::: null|
[14:03:02:883]|[10-12-2016]|[com.adventnet.db.api.RelationalAPI]|[SEVERE]|[17]: haltjvm.on.dbcrash is set to [false]|
[14:03:02:883]|[10-12-2016]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[17]: shutDownStrings :: []|
[14:03:02:883]|[10-12-2016]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[17]: isDBMigration running :: false|
[14:03:02:883]|[10-12-2016]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[17]: isDBMigration dest DB :: false|
[14:03:02:883]|[10-12-2016]|[com.zoho.framework.utils.crypto.EnDecrypt]|[SEVERE]|[17]: Encryption failed|
[14:03:02:883]|[10-12-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[17]: DataSourcePlugIn is initialized successfully|
[14:03:02:883]|[10-12-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[17]: create.db is :: null|
[14:03:02:883]|[10-12-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[17]: Template replaced url :: jdbc:jtds:sqlserver://CLPLSQL02:1433/OpManagerDB|
[14:03:03:945]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Error Code : 10001|
[14:03:03:945]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Localized Error Msg : null|
[14:03:03:945]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Error Msg : Exception while initializing DB.|
[14:03:03:945]|[10-12-2016]|[com.adventnet.mfw.Server]|[SEVERE]|[17]: STACK TRACE|
com.adventnet.mfw.ServerFailureException
at com.adventnet.mfw.Server.startServer(Server.java:179)
at com.adventnet.me.opmanager.server.mfw.OpmServer.startServer(OpmServer.java:37)
at com.adventnet.mfw.Starter.start(Starter.java:349)
at com.adventnet.mfw.Starter.main(Starter.java:559)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Exception: Exception while initializing DB.
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:364)
at com.adventnet.mfw.Server.startServer(Server.java:171)
... 9 more
Caused by: java.sql.SQLException: java.lang.Exception: Exception during getConnection from pool Exception occurred during get connection from datasource
at com.zoho.cp.TxDataSource.getConnection(TxDataSource.java:56)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:1082)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:944)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:567)
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:360)
... 10 more
Caused by: java.lang.Exception: Exception during getConnection from pool
at com.zoho.cp.ConnectionPool._getConnectionDetail(ConnectionPool.java:100)
at com.zoho.cp.ConnectionPool.getConnectionDetail(ConnectionPool.java:55)
at com.zoho.cp.TxDataSource.getConnDetailFromPool(TxDataSource.java:62)
at com.zoho.cp.TxDataSource.getConnection(TxDataSource.java:37)
... 14 more
Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.zoho.cp.ConnectionCreator.createConnection(ConnectionCreator.java:40)
at com.zoho.cp.ConnectionCreator.createConnectionInfo(ConnectionCreator.java:50)
at com.zoho.cp.ConnectionPool._getConnectionDetail(ConnectionPool.java:78)
... 17 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
... 23 more
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.ServerFailureHandlerImpl]|[INFO]|[17]: Error Code :: 10,001|
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Error Code : 10001|
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Localized Error Msg : null|
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Error Msg : Exception while initializing DB.|
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.Server]|[WARNING]|[17]: Abort Backup has to be implemented db specifically|
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Error Code : 10001|
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Localized Error Msg : null|
[14:03:03:961]|[10-12-2016]|[com.adventnet.mfw.ServerFailureException]|[INFO]|[17]: Error Msg : Exception while initializing DB.|