Visualizer is not working in the secondary server

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

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.

 

Environment

Release : 17.x

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: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.