Manual Correlation Fails – “Invalid value in account or userName field”

Hi,

I’m trying to perform a manual correlation in SailPoint ISC and I get this message:

Warning!
The following account(s) failed to correlate: uid=test_user

Error!
Invalid value in account or userName field.

My CSV looks like this:

account,displayName,userName,type
uid=test_user,ou=People,dc=example,dc=com,Test User,12345-ABCDE,

I suspect the issue might be caused by the commas in the account (DN) value, since the DN contains several comma-separated components like ou=People,dc=example,dc=com.

Has anyone run into this before or knows the correct format for DNs in manual correlation uploads?

Thanks!

The account value should be surrounded by double quote.


account,displayName,userName,type
"uid=test_user,ou=People,dc=example,dc=com",Test User,12345-ABCDE,

Hi @AntonioGvtt , Seems the issue is with “userName“ , I am able to do manual correlation correctly with CN. Please check if the identity exists and you are giving correct value in userName field. Try giving Identity “accountName” as correlaton ID

image

PS: Download the correlation file directly from UI and don’t make any changes to “accoun” field

Hi @pattabhi

Thanks for the suggestion!
I tried adding double quotes around the account value as shown:

"uid=test_user,ou=People,dc=example,dc=com",Test User,12345-ABCDE,

But when I do that, I get a new error:

Error!
An unexpected error occurred: java.lang.IndexOutOfBoundsException: Index 1 out of bounds for length 1

Maybe the type field needs to have a specific value? The documentation doesn’t seem to clearly mention what should be used there.

@AntonioGvtt Are you trying to do the correlation for AD source? type is not required

If you don’t have a value for “type”, I think you need to add another comma after 12345-ABCDE,

Try:

"uid=test_user,ou=People,dc=example,dc=com",Test User,12345-ABCDE,,