After upgrading SDM from 17.2.x to 17.3, 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)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:5173)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3810)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:94)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3754)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2562)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2216)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2067)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1204)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:825)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at com.broadcom.visualizer.core.db.DBConnectionPoolImpl.createConnection(DBConnectionPoolImpl.java:148)
at com.broadcom.visualizer.core.db.DBConnectionPoolImpl.<init>(DBConnectionPoolImpl.java:104)
at com.broadcom.visualizer.core.db.DBConnectionPoolImpl.getInstance(DBConnectionPoolImpl.java:137)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.initConnectionPoolSettingsAndStartPool(DBConnectionPoolManager.java:188)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.initializeDBConnectionConfig(DBConnectionPoolManager.java:155)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.<init>(DBConnectionPoolManager.java:74)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.getInstance(DBConnectionPoolManager.java:90)
at com.broadcom.visualizer.rest.app.CMDBVisualizerApp.lambda$new$1(CMDBVisualizerApp.java:176)
at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
at java.base/java.util.concurrent.CompletableFuture$Completion.exec(CompletableFuture.java:479)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177)
ERROR [rkJoinPool.commonPool-worker-3] DBConnectionPoolManager 193 Database pool initialization failed....
java.sql.SQLException: Failed to create a connection.
at com.broadcom.visualizer.core.db.DBConnectionPoolImpl.createConnection(DBConnectionPoolImpl.java:153)
at com.broadcom.visualizer.core.db.DBConnectionPoolImpl.<init>(DBConnectionPoolImpl.java:104)
at com.broadcom.visualizer.core.db.DBConnectionPoolImpl.getInstance(DBConnectionPoolImpl.java:137)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.initConnectionPoolSettingsAndStartPool(DBConnectionPoolManager.java:188)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.initializeDBConnectionConfig(DBConnectionPoolManager.java:155)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.<init>(DBConnectionPoolManager.java:74)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.getInstance(DBConnectionPoolManager.java:90)
at com.broadcom.visualizer.rest.app.CMDBVisualizerApp.lambda$new$1(CMDBVisualizerApp.java:176)
at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
at java.base/java.util.concurrent.CompletableFuture$Completion.exec(CompletableFuture.java:479)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177)
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.
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.<init>(DBConnectionPoolManager.java:78)
at com.broadcom.visualizer.core.db.DBConnectionPoolManager.getInstance(DBConnectionPoolManager.java:90)
at com.broadcom.visualizer.rest.app.CMDBVisualizerApp.lambda$new$1(CMDBVisualizerApp.java:176)
at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
at java.base/java.util.concurrent.CompletableFuture$Completion.exec(CompletableFuture.java:479)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177)
[rkJoinPool.commonPool-worker-5] SDMGraphDAOImpl 236 Failed to initialize DBConnectionPoolManager.
[rkJoinPool.commonPool-worker-3] CMDBVisualizerApp 204 Shutting down CMDB Visualizer App.
Release : 17.3
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
3. Modify the value to point to the domrsrvr of the secondary instead of the primary (default). See note under step 3 in the following link.
4. Save changes and restart services.