RSA Product Set:
RSA Governance & LifecycleRSA Version/Condition
- RSA Governance & Lifecycle 7.x.x
The role count being reviewed shows the incorrect entitlement count in the role review.Image descriptionImage description
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
Contact RSA Customer Support and quote this KB article for a cleanup script for this issue.
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.