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
Last Modified: 2023-11-30
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
Requests Pending Submissions queue accumulating in RSA Identity Governance & Lifecycle 195Number of Views Roles stuck in Applied state in SecurID Governance & Lifecycle 384Number of Views Edit an Application Trust Certificate 9Number of Views ASR fails to generate with 'ORA-31011: XML parsing failed' and 'LPX-00225: end-element tag "ROWSET" does not match start-e… 69Number of Views The Cancel Pending Requests button on the Pending Submissions page is disabled in RSA Identity Governance & Lifecycle 68Number of Views
Trending Articles
How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Setup and Configuration Guide RSA SecurID Software Token Administrator's Guide
Don't see what you're looking for?