Change Requests in Pending Submission state are not being deleted by the daily scheduled task in RSA Identity Governance & Lifecycle
Originally Published: 2020-06-27
Article Number
Applies To
RSA Version/Condition: 7.1.0
Issue
To monitor your pending submissions, run the following SQL query every few days and note if the number stays static or increases. Run the query as avuser using a tool such as SQL*Plus or SQL Developer.
select count(*) from t_av_change_requests_mst where current_state='PS';
Cause
This issue occurs for those Pending Submission requests that have dependent change items in a completed state.
Resolution
Related Articles
RSA Governance & Lifecycle Recipes: Overview - Daily User Changes Number of Views RSA Governance & Lifecycle Recipes: Telemetry Chart - Daily Role Processing Summary Number of Views RSA Governance & Lifecycle Recipes: Telemetry Chart - Daily Request Processing Summary Number of Views RSA Governance & Lifecycle Recipes: Dashboard - Telemetry Daily Number of Views Connector Test or Edit times out without sending any packets on the network in RSA Governance & Lifecycle Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
