ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to view details in View Submitted tasks

book

Article ID: 213123

calendar_today

Updated On:

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.

Cause

Usage Error

Environment

Release : 14.3 CP2

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

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.