sql_response probe stuck crash not responding / connections failing

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The sql_response probe stopped working, none of the multiple connections to different remote DB work, the probe is also crashing and stuck. The probe stops logging anything when this issue occurs, so there is no specific error in the logs. 

Environment

• DX UIM 23.4.3
• sql_response probe 1.81 / 1.82

Cause

This issue may be observe if any of the drivers / providers become corrupt in the system hosting the sql_response probe. An example could be the OraOLEDB.Oracle.1 provider which could have become corrupt. When this happens, even one single connection attempting to connect using a faulty / corrupt driver it will affect the probe ability to work as expected. 

Resolution

To rule any issue with the provider / driver used by the connection, for example, "OraOLEDB.Oracle.1", follow the steps below:

1. Stop the probe
2. Manually in the cfg file, or using Raw configure, change the provider: "OraOLEDB.Oracle.1" to "MSDASQL.1" on all profiles using this provider. 
   
   
3. Start the probe and test the connections.