When clicking on a task in the CA Identity Manager (IM) VST (View Submitted Task) screen, no details are displayed. However, the application server log (Wildfly) displays the following error message.
2021-02-07 13:06:39,492 ERROR [ims.ui] (default task-18) com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Danish_Norwegian_CI_AS" in UNION ALL operator occurring in SELECT statement column 8.
Release : 14.3 CP2
Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)
"SQL_Latin1_General_CP1_CI_AS" collation is and has been the pre-requisite since before 14.0.
This must be set correctly to ensure the product works as designed.
The collation must be changed. The process to do this is detailed in the Microsoft documentation.
If you have any queries or concerns over changing the collation settings they should be discussed with Microsoft Support.