VST case sensitive

Products

• CA Identity Manager

Issue/Introduction

VST search become case sensitive after apply the HF.

Environment

Release : 14.3

Component : IdentityMinder(Identity Manager)

Cause

Issue has nothing to do with HF but the property DisableExplicitConversion was added to the environment at other time.

Resolution

Remove DisableExplicitConversion or change the value to false. 

Additional Information

DisableExplicitConversion:

 

When this property is set to true, the TO_CHAR and LCASE functions are not included in the SQL queries for View Submitted Tasks/View My Submitted Tasks. This eliminates the table level conversion for TO_CHAR and LCASE functions and improves the query performance, but the search is case sensitive.When this property is not set or set to false, the SQL query includes TO_CHAR and LCASE functions. You may experience some slowness in the execution of the SQL queries for View Submitted Tasks/View My Submitted Tasks, as it performs table level conversion for TO_CHAR and LCASE functions.

Please refer the doc for further explanation of the property

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-manager/14-4/configuring/advanced-settings/business-logic/miscellaneous-properties.html