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")))

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