|Applies To||RSA Product Set: RSA Identity Governance and Lifecycle|
|Issue||Checking the Data is case sensitive checkbox in collector definitions has no effect on Account Collectors. |
Steps to Reproduce
Account1 and account1 should be interpreted by the ADC as the same account since we did not have the Data is case sensitive option enabled. The name Account1 should be updated with the new name of account1.
The ADC behaves as if case sensitivity were enabled. This means the ADC interprets account1 as a new account and Account1 is missing. As a result, new account account1 is created and Account1 is deleted.
|Cause||This is a bug fixed in 6.8.1 P23, 6.9.1 P12, 7.0.0 P02, 7.0.1|
|Resolution||Deploy the respective patches based on your version to have the issue resolved.|
|Workaround||If your data is not case sensitive, make sure it is in the same case before being collected. As an example, if the above account data is collected from a csv file, the following query will ensure that any form of the account name such as Account1, account1, ACCOUNT1, ACCount1, etc. will be interpreted as the same case:|
SELECT UPPER(AccountNameColumn) FROM tablename