data_engine probe is in red state

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The probes data_engine, sla_engine and udm_manager are in a red state and I am also unable to activate them.

Cause

Mar 24 11:09:46:367 [20548] 0 de: [main] Open - 1 errors
Mar 24 11:09:46:367 [20548] 0 de: (1) Open [Microsoft SQL Server Native Client 11.0] The target database ('CA_UIM') is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent, see SQL Server Books Online.
Mar 24 11:09:46:367 [20548] 0 de: COM Error [0x80004005] Unspecified error - [Microsoft SQL Server Native Client 11.0] The target database ('CA_UIM') is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent, see SQL Server Books Online.
Mar 24 11:09:46:367 [20548] 0 de: Unable to connect to database. so exiting
Mar 24 11:09:46:367 [20548] 0 de: Database library - program is exiting through exit()...

Environment

• Release : 20.4
• Component : UIM - DATA_ENGINE

Resolution

Correct the data_engine configuration so it is pointing to the primary instance database instead of the secondary. 

Additional Information

As per this MS SQL Forum this happens when the application is pointing to the secondary database instead of the primary database:
Job failed. The target database ('XXX') is in an availability group and is currently accessible for connections when the application intent is set to read only.

Other related information can be found here:

Cannot Connect to SQL Availability Group Using ApplicationIntent = ReadOnly Get Network Error From Outside AWS