The probes data_engine, sla_engine and udm_manager are in red state and i am also unable to activate them.
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()...
Release : 20.4
Component : UIM - DATA_ENGINE
Correct data_engine configuration so it is pointing to the primary instance database instead of the secondary.
As per this MS SQL Forum this happens when the application is pointing to the secondary database instead of the primary:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/555a3b6a-fdac-4ce5-9d26-7806513f57ee/job-failed-the-target-database-xxx-is-in-an-availability-group-and-is-currently-accessible-for?forum=sqldisasterrecovery
And more info here:
https://docs.microsoft.com/en-us/answers/questions/256139/cannot-connect-to-sql-availability-group-using-app.html