Maintenance Mode schedules on devices failed with 'Error adding schedule - Error retrieving database meta-data'

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Creating a schedule fails with the following pop message: "Error adding schedule - Error retrieving database meta-data" after upgrading UIM from 20.4 to 23.4.

Error in the maintenance_mode.log

The connection is broken and recovery is not possible. The connection is marked by the client driver as unrecoverable. No attempt was made to restore the connection. Failed to notify nas /<domain>/<primaryhub_name>/<primaryhubrobotname>/ems

Error in the ems.log file

Error creating bean with name 'databaseConnectionInfo' defined in class path resource [com/nimsoft/events/common/config/DataAccessConfig.class]: Failed to instantiate [com.nimsoft.nimbus.lookup.model.DatabaseConnectionInfo]: Factory method 'databaseConnectionInfo' threw exception with message: Received status (4) on response (for sendRcv) for cmd = 'nametoip' name = '/<domain>/<primaryhub_name>/<primaryhubrobotname>/data_engine'

Environment

UIM 23.4+ with MS SQL Server as the backend database

Resolution

This issue is sometimes seen when the data_engine Provider setting is not configured with the recommended MS SQL driver.

Steps to set the MSOLEDBSQL driver

1. Open the data_engine probe configuration

2. Select MSOLEDBSQL on the Provider setting, followed by a Test Connection and then save the changes.

3. Restart the Nimsoft service on the Primary hub

4. Restart the OC robot after all probes are started on the Primary hub

Additional Information

DX UIM 20.4/23.4 - which database driver is supported for MS SQL Server database on Window