Approval workflow slow or stuck in decision node in RSA Governance & Lifecycle
Last Modified: 2023-08-30
Article Number
Applies To
This is a known issue in the following versions/patches:
- RSA Identity Governance & Lifecycle 7.5.0 P08
- SecurID Governance & Lifecycle 7.5.2 P04 through P07
Issue
Customers may identify various performance issues with approval workflows including but not limited to the following performance related symptoms:
- Approval workflows take a long time to complete
- Workflows show on the "Workflow flagged as stalled based on detection settings" page.
- Workflows stuck in the approval node
- Workflows failing in the approval node with the following error message in the aveksaServer.log file:
2023-04-03 17:49:44,705 Worker_actionq#Normal#jdbc/avdb_478 ERROR com.workpoint.services.impl.GenericServiceImpl - IJ031070: Transaction cannot proceed: STATUS_ROLLEDBACK SQL Command = SELECT WP_BUS_CAL.BUS_CAL_ID, WP_BUS_CAL.BUS_CAL_DB, WP_BUS_CAL.NAME, WP_BUS_CAL.HOL_CAL_ID, WP_BUS_CAL.HOL_CAL_DB, WP_BUS_CAL.ROW_VERSION, WP_BUS_CAL.LU_ID, WP_BUS_CAL.LU_DATE FROM WP_BUS_CAL WHERE WP_BUS_CAL.BUS_CAL_ID=? AND WP_BUS_CAL.BUS_CAL_DB=?
- The following query may show in the AWR report with long execution times:
SELECT DISTINCT * FROM (select * from table(Access_Request_Res.supervisors(:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04"))) MINUS (select * from table(Access_Request_Res.requestor(:"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09")) UNION ALL select * from table(Access_Request_Res.targetUsers(:"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14")) UNION ALL select * from table(Access_Request_Res.prevApprover(:"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19")))
Cause
Resolution
This issue is resolved in the following versions/patches which disables an alternative approval calculation by default:
- SecurID Governance & Lifecycle 7.5.2 P08
- RSA Governance & Lifecycle 8.0.0
This issue can be resolved in the following versions by disabling a custom feature flag. Please contact RSA Customer Support if you are on the following versions/patches and experience this performance issue:
- RSA Governance & Lifecycle 7.5.0 P08
- RSA Governance & Lifecycle 7.5.2 P04 through P07
For more information on the changes made to introduce the alternative approval method, see the following article:
RSA Governance & Lifecycle incorrectly approves changes in some Workflows with multiple approvals
Related Articles
How approval activity behaves when change request items are grouped by category in RSA Identity Governance & Lifecycle 126Number of Views Error encountered in Relying Party servlet: java.net.ConnectException: Connection refused: connect' appears in web browser… 56Number of Views Workflows stuck in AFX fulfillment and/or Provisioning nodes in RSA Identity Governance & Lifecycle 553Number of Views Change Requests stuck in the AFX Fulfillment Handler Workflow Node and Workflows Stalled in RSA Identity Governance & Life… 1.13KNumber of Views Form level workflow node is skipped intermittently in RSA Identity Governance & Lifecycle 30Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?