Sqlserver 5.61 experiences max restarts when upgrading from 5.60-HF1

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When upgrading to sqlserver 5.61, it seems to kill the existing sqlserver probe with max restarts. Probe needed to be

uninstalled and 5.60-HF1 installed in order to restore back to service.
Error:
Mar 19 15:00:20:516 sqlserver: nimSHA256Digest : input[] = db2.crypt.key
Mar 19 15:00:20:516 sqlserver: (nimDecrypt) algorithm ID for supported mode not found.
Mar 19 15:00:20:516 sqlserver: nimSHA256Digest : input[] = db2.crypt.key
Mar 19 15:00:21:438 [11272] Controller: Max. restarts reached for probe 'sqlserver' (command = sqlserver_monitor.exe)

 

Environment

Release: Any UIM

Component: Sqlserver probe 5.60HF1

 

Cause

Failure was traced to custom queries/checkpoints configured on server

Resolution

Disabling queries during upgrade process and re enabling after upgrade is completed, was a work around.

Hotfix attached below was created and deployed as a permanent Fix.