Article Number
000068115
Applies To
RSA Product Set: RSA Governance & Lifecycle
RSA Version/Condition:
- RSA Governance & Lifecycle 7.x.x
Issue
The role count being reviewed shows the incorrect entitlement count in the role review.
Image description
Image description
Cause
This issue is caused by the occurrence of roles duplicate records in the T_AV_EXPLODEDUSERENTITLEMENTS table.
Importing Roles that are created on legacy versions and with the existence of Roles having the same name as the Collected Roles results in duplicates creation in the T_AV_EXPLODEDUSERENTITLEMENTS entries
Resolution
Contact RSA Customer Support and quote this KB article for a cleanup script for this issue.
Notes
Run the attached script Dup_Review_Comp_And_Xue.sql
This script contains four select queries that detect if there are any duplicates for the roles.