Role Review showing incorrect entitlement count in RSA Governance & Lifecycle
Last Modified: 2023-10-06
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-2022-08-01-15-48-07-197.png

image-2022-08-01-15-48-19-587.png
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.
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).

Related Articles

Trending Articles

Don't see what you're looking for?