'One or more attributes used in Join Condition has duplicate values' error during unification in RSA Identity Governance & Lifecycle
Originally Published: 2015-12-18
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 7.0
Issue
Go to Collectors > Identity Collectors > {Identity Collector Name} > Collection History tab > {Run ID} and select either the Admin Errors or Raw Data hyperlink (Rejected column) for the Run. Note the following error:
EC[102] Context[RunID=435, IDC(ID=3)] Message[Identity Data Validation:
One or more attributes used in Join Condition has duplicate values.]
Cause
This error may occur if the value of the unique identifier used for the join in the unification for one or more users is null. If more than one user has a null value for the join field, the nulls are incorrectly identified as duplicate values. For unification, unique users should be identified only by attributes that are collected. If one or more users do not have a value for a collected attribute, then it should have a value of null and should not be used for unification.
In RSA Identity Governance & Lifecycle 6.9.1 and earlier, duplicate null values in join fields were identified with the same error message, but the users were still collected as unique users. In RSA Identity Governance & Lifecycle 7.0 GA, these users are rejected.
Resolution
- RSA Identity Governance & Lifecycle 7.0.0 P02
- RSA Identity Governance & Lifecycle 7.0.1
- RSA Identity Governance & Lifecycle 7.0.2
Related Articles
Installation fails with 'unzip: cannot find zipfile directory in one of /tmp/aveksa/packages/<filename.zip>' error in RSA … 56Number of Views Can RSA SecurID tokens exist in more than one RSA Authentication Manager deployment? 35Number of Views When approval activities are grouped by category, they auto-complete when one of the items is rejected in RSA Identity Gov… 101Number of Views Provisioning Node Mapping display changed in RSA Identity Governance & Lifecycle 28Number of Views What is Silvertail Syslog syntax 12Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?