Performance issues seen when processing Role modifications in RSA Identity Governance & Lifecycle
Originally Published: 2020-08-17
Article Number
Applies To
RSA Version/Condition: 6.9.1, 7.0.x, 7.1.x, 7.2.0
Issue
Cause
To verify if you have this issue, run the following two queries as AVUSER:
select count(*) from t_av_roleversions rv
where state in ('TN', 'T', 'R', 'CR', 'CC', 'UD') -- All other States are for Pending RoleVersions
-- If there is no corresponding Role:
and not exists (select 1 from t_av_roles r
where r.deletion_date is null and r.id = rv.role_id)
-- If there is no CRI that uses it as VALUE or OPERATOR:
and not exists (select 1 from t_av_change_request_details cri
where cri.value_type = 'PR'
and cri.value_id = rv.roleversion_id)
and not exists (select 1 from t_av_change_request_details cri
where cri.operand_type = 'PR'
and cri.operand_id = rv.roleversion_id);
and
select count(*) from t_av_model_explodeduserents m
where (role_type = 'P' and
not exists (select 1 from t_av_roleversions rv where rv.roleversion_id = m.role_id))
or (role_type = 'C' and
not exists (select 1 from t_av_roles r where r.deletion_date is null and r.id = m.role_id));
If either query returns positive values, you have this issue.
Resolution
- RSA Identity Governance & Lifecycle 7.1.1 P07
- RSA Identity Governance & Lifecycle 7.2.0 P02
Related Articles
Entitlement from a deleted account is still seen in the User Access tab in RSA Identity Governance & Lifecycle Number of Views "Request could not be handled" error seen when clicking on submitted form tab for request raised via Webservices in RSA Id… Number of Views 'Critical Error' with software Token for Windows Number of Views Intermittently SQL select node queries are seen in runtime in RSA Identity Governance & Lifecycle Number of Views Requests Pending Submissions queue accumulating in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
