Maintenance_mode probe in error state

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Hi Team, 

Maintenance_mode probe stopped working suddenly. Restarted probe many time, but issue haven't resolved. 

DX Infrastructure Manager -- Ver:20.33

Maintenance_mode probe -- ver: 20.31

 

Log:

Apr 13 13:09:09:328 INFO [main, com.nimsoft.monitor.probe.util.DBUtils] DatabaseConnectionInfo [databaseName=NimsoftSLM, databaseServer=BAZEU2PWUIMDB01, dbProvider=SQLOLEDB, nisJdbcUsername=nmadmin, nisJdbcPassword={not_shown_for_security_reasons}, nisJdbcUrl=jdbc:sqlserver://;serverName=BAZEU2PWUIMDB01;databaseName=NimsoftSLM;applicationName=maintenance_mode;Network Library=dbmssocn;Language=us_english]
Apr 13 13:09:09:711 FATAL [main, com.nimsoft.monitor.probe.Starter] SQL Run was:exec spn_bas_SetVersion 'initialize', 'MAINTENANCE_MODE',1.0000,5;

 

Apr 13 14:20:41:388 INFO  [main, com.nimsoft.monitor.probe.Starter] Setting NIMV_CONTIP to: 10.20.136.6
Apr 13 14:20:41:389 INFO  [main, com.nimsoft.monitor.probe.Starter] Setting NIM_PROBE_KEY to: 0xgb8QDFl1NaMHd6d3MLk90GeIqexhSnzNzW85m7WffbMF3PQ4efOIbEUoFEZEn
Apr 13 14:20:41:389 INFO  [main, com.nimsoft.monitor.probe.Starter] Setting NIMCPRID to: 5706873
Apr 13 14:20:41:389 INFO  [main, com.nimsoft.monitor.probe.Starter] Setting NIMPROBEPORT to: 48043
Apr 13 14:20:41:522 INFO  [main, com.nimsoft.nimbus.NimProbeBase] Login to NimBUS is OK
Apr 13 14:20:41:537 DEBUG [main, com.nimsoft.nimbus.lookup.DataEngineLookup] Request to probe "data_engine" callback get_connection_string was successful.
Apr 13 14:20:41:656 DEBUG [main, com.nimsoft.nimbus.utils.FileUtils] In FileUtils.getFileChecksum
Apr 13 14:20:41:657 DEBUG [main, com.nimsoft.nimbus.utils.FileUtils] local certificate store FileChecksum - 91f7274617a166110f20b0a941ecf0c6
Apr 13 14:20:41:663 DEBUG [main, com.nimsoft.nimbus.lookup.DataEngineLookup] Resulting parsed connection data is: DatabaseConnectionInfo [databaseName=NimsoftSLM, databaseServer=db1, dbProvider=SQLOLEDB, nisJdbcUsername=sa, nisJdbcPassword={not_shown_for_security_reasons}, nisJdbcUrl=jdbc:sqlserver://;serverName=db1;databaseName=NimsoftSLM;applicationName=maintenance_mode;Network Library=dbmssocn;Language=us_english]
Apr 13 14:20:42:039 INFO  [main, com.nimsoft.monitor.probe.util.DBUtils] DatabaseConnectionInfo [databaseName=NimsoftSLM, databaseServer=db1, dbProvider=SQLOLEDB, nisJdbcUsername=sa, nisJdbcPassword={not_shown_for_security_reasons}, nisJdbcUrl=jdbc:sqlserver://;serverName=db1;databaseName=NimsoftSLM;applicationName=maintenance_mode;Network Library=dbmssocn;Language=us_english]
Apr 13 14:20:42:450 FATAL [main, com.nimsoft.monitor.probe.Starter] SQL Run was:exec spn_bas_SetVersion 'initialize', 'MAINTENANCE_MODE',1.0000,5;
Apr 13 14:20:43:063 [5516] Controller: Max. restarts reached for probe 'maintenance_mode' (command = <startup java>)

Environment

Release : 20.3

Component : UIM MAINTENANCE MODE

Resolution

Have your DBA run this in MS SQL Management Studio

exec spn_bas_SetVersion 'initialize', 'MAINTENANCE_MODE',1.0000,5;

Then deactivate maintenance_mode probe
Wait for PID to clear
Activate maintenance_mode probe.