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
Data Purging stuck "in Progress" in "Step 7/12 Purging Workflow Custom Tasks" in RSA Identity Governance & Lifecycle Number of Views Role Membership Rule Difference Rule fails to run at scheduled time in RSA Identity Governance & Lifecycle Number of Views RSA Identity Management and Governance DB logs, task results, task progress are not available on run details of collection… Number of Views RSA Access Manager Agent SharePoint Ticket Service sends duplicate runtimeAPI WebServices Requests Number of Views RSA Identity Governance and Lifecycle Account Data Collector (ADC) and Entitlement Data Collectors (EDC) are slow in step … Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
