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:
RSA Governance & Lifecycle incorrectly approves changes in some Workflows with multiple approvals
