Visualizer is not working in the secondary server
search cancel

Visualizer is not working in the secondary server

book

Article ID: 247751

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

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.

 

Environment

Release : 17.3

Component : SDM - Configuration Management (CMDB/Visualizer/Grloader)

Cause

Application.conf is pointing to the domsrvr of the primary server, instead of the domsrvr of the secondary.

Resolution

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.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/NewCMDBVisualizer/Configuring-CMDB-Visualizer/CMDB-Visualizer-Resource-Management-and-Performance-Tuning.html

4. Save changes and restart services.