RSA Identity Governance and Lifecycle Account Data Collectors treat data as case sensitive regardless of the setting of the "Data is case sensitive" option
Originally Published: 2017-01-05
Article Number
Applies To
Issue
Steps to Reproduce
- Go to Resources > Directory > Create Directory.
- Click on created Directory (New Directory) > Collector > Account Data Collector.
- Create an Account collector to collect accounts and uncheck the checkbox for Data is case sensitive.
- Collect the data and make sure some accounts are collected .
- Go to the data source and edit any account name to change its case. In this example "Account1" was changed to "account1."
- Run the Account Collector to re-collect the modified data.
Expected Result
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.Actual Result
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
Resolution
Workaround
SELECT UPPER(AccountNameColumn) FROM tablename
where,
AccountNameColumn is the name of the collected field that contains the account name. This will make any value of the account name in RSA Identity Governance and Lifecycle be ACCOUNT1.
