Unable to view details in View Submitted tasks

Products

• CA Identity Suite

Issue/Introduction

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.

Environment

Release : 14.3 CP2

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Cause

Usage Error

Resolution

"SQL_Latin1_General_CP1_CI_AS" collation is and has been the pre-requisite since before 14.0.  

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-manager/14-3/installing/installation-prerequisites/central-databases.html

This must be set correctly to ensure the product works as designed.

Additional Information

The collation must be changed.  The process to do this is detailed in the Microsoft documentation.

https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?view=sql-server-ver15

If you have any queries or concerns over changing the collation settings they should be discussed with Microsoft Support.