For a delimited file we are doing manual correlation but still failing “failed to correlate error”, what can be the reason?
There can be multiple reasons for the Correlation failure.
1.Incorrect correlation mapping.
2.Correlation attribute mismatch.
3.Correlation rule/custom logic failure
4.Aggregation Failure.
5.Data type or format issues with the delimited file.
may I know what is the type of correlated account attribute?
The values are actually alphanumerical type
Try this if you have leading zeros in account name, let say if it has zero at starting csv misses that so you need to format csv to include that zero, hence try csv formula to include leading zeros in file
A couple questions to help get better responses:
-
Have you configured the correlation mapping to automatically correlate the accounts and getting the error, or manually correlating the accounts by selecting an uncorrelated account and matching it to an identity?
-
Do you have any case differences in the incoming attribute and the IdentityAttribute you are correlating to?
yes mapping is to automatically correlate the accounts and error is getting for few uncorrelated accounts when we try to manually correlate
There is no case difference.
Ok, good to know.
Is the error happening when you use the Update Correlation option in the Admin → Accounts → Uncorrelated Accounts screen to assign the correlation, or is the error happening during the next aggregation?
yes when we use the Update Correlation option in the Admin → Accounts → Uncorrelated Accounts screen to assign the correlation
Have you tried to manually correlate by downloading CSV file for the list of uncorrelated accounts from Source config page, and upload the file back with identity reference values?
I think this needs a support ticket opened as manual correlation does not depend on correlation settings or any other configuration
I miss interpreted @gmilunich question but the actually what we are doing is
tried to manually correlate by downloading CSV file for the list of uncorrelated accounts from Source config page, and upload the file back with identity reference values. Here is where error is coming
This worked I wrongly added these are numeric starting 0 is missing for the failed ones added in csv as =“0”&cell and aggregated uncorrelated file.