Ignore case in Account collector mapping

[MohammedSouadji]

Hi,

In my account collector, i did not check the "Data is case senesitive" chekbox.

But i have some orphans accounts not mapped cause, it has some uppercase letters in its names

select count(*) from PV_ORPHANED_ACCOUNT, PV_USERS where lower(PV_ORPHANED_ACCOUNT.NAME)=lower(PV_USERS.ADMIN_USER_NAME) or lower(PV_ORPHANED_ACCOUNT.NAME)=lower(PV_USERS.USER_NAME).

that query return 392 orphan account.

Note: in PV_USERS all columns are in lowercase.

I want know, how can i ignore case in the account mapping?

Regards.

[SubashChandraBe · Accepted solution]

What is the version of Via L&G you are seeing this issue. This issue was reported in 7.0.0 and fixed in 7.0.0 Patch02.

Below is the screenshot from the Release Notes.

[MohammedSouadji]

I use Aveksa 7.0.0.93958

2016-06-15 16:52 GMT+02:00 Subash Chandra Behera <no-reply@rsa.com>:

RSA Link <https://community.rsa.com/?et=watches.email.thread>

Ignore case in Account collector mapping

reply from Subash Chandra Behera

<https://community.rsa.com/people/Ljzcsk0y25uBpUcOnIFmS1CkrciItifMh5rIrlsIVrQ%3D?et=watches.email.thread>

in RSA Via Lifecycle and Governance - View the full discussion

<https://community.rsa.com/message/873871?et=watches.email.thread#comment-873871>

[SubashChandraBe]

Please upgrade to 7.0.0 P02 to have it fixed.