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: Telemetry Chart - Daily Request Processing Summary 9Number of Views RSA Governance & Lifecycle Recipes: Overview - Daily User Changes 14Number of Views RSA Governance & Lifecycle Recipes: Telemetry Chart - Daily Role Processing Summary 15Number of Views The workpoint log has daily occurrences of ORA-02049: timeout: distributed transaction waiting for lock errors in RSA Id… 320Number of Views Connector Test or Edit times out without sending any packets on the network in RSA Governance & Lifecycle 44Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) RSA announces the availability of the RSA SecurID Hardware Appliance 230 based on the Dell PowerEdge R240 Server How to troubleshoot Oracle database ORA-04030 errors in RSA Identity Governance & Lifecycle RSA Authentication Manager Upgrade Process Microsoft SQL Server Collectors can no longer connect to the SQL Server database after upgrade to Microsoft SQL Server 201…
Don't see what you're looking for?