Approval workflow slow or stuck in decision node in RSA Governance & Lifecycle
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
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")))
Changes in the way approvals are calculated for a change request where there are parallel approval workflows may cause performance issues for some customers.
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: