After upgrading SDM, Visualizer keeps loading and does not allow to log into the application.
Error in VisualizerMS_debug.log:
[rkJoinPool.commonPool-worker-3] DBConnectionPoolImpl 152 Failed to create a connection.
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'mdbadmin'. ClientConnectionId:c069b18e-1b50-43e8-9b14-59e8abc41c73
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:283)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:129)
ERROR [rkJoinPool.commonPool-worker-3] DBConnectionPoolManager 193 Database pool initialization failed....
java.sql.SQLException: Failed to create a connection.
ERROR [rkJoinPool.commonPool-worker-3] DBConnectionPoolManager 75 Failed to initialize DB configurations.
ERROR [rkJoinPool.commonPool-worker-3] CMDBVisualizerApp 179 SEVERE: Failed to initialize DB Connection Pool Manager.
java.sql.SQLException: Failed to initialize DB configurations.
[rkJoinPool.commonPool-worker-5] SDMGraphDAOImpl 236 Failed to initialize DBConnectionPoolManager.
[rkJoinPool.commonPool-worker-3] CMDBVisualizerApp 204 Shutting down CMDB Visualizer App.
Release : 17.x
Component : SDM - Configuration Management (CMDB/Visualizer/Grloader)
Application.conf is pointing to the domsrvr of the primary server, instead of the domsrvr of the secondary.
1. Create a backup file for application.conf located in Service Desk Manager\bopcfg\www\CATALINA_BASE_VIZ\webapps\CMDBVisualizer\WEB-INF\classes\application.conf
2. Edit the application.conf and search for sdm.domsrvr.viz = "domsrvr:11"
3. Modify the value to point to the domrsrvr of the secondary instead of the primary (default). See note under step 3 in this link
4. Save changes and restart services.