Viewing the sc_req_item list may hang until the user transaction times out causing a Stack Overflow error - Known Error

Viewing the sc_req_item list may hang until the user transaction times out causing a Stack Overflow error Description Loading sc_req_item.list may hang indefinitely with RITMs with a service catalog flow that calls an action or subflow with a input of type choice driven by sc_req_item.stage.

This occurs when a sc_req_item is associated with a flow that calls and an action or subflow with an input of type choice that is driven by the stage column on table sc_req_item.

The issue does not happen consistently, only when the associated flow needs to be recompiled, i.e. the flow or one of its dependents has been altered and reactivated or a new release has been installed.

Steps to Reproduce

- Paris instance 1. Commit the attached update set . This adds service catalog flow "stage choice flow" and associateds it with "Apple Ipad 3". 2. Order an Applie Ipad 3 (maintain items > open apple ipad 3 > click try it). 3. Navigate to sc_req_item.list and observe that it loads correctly, the sys_hub_flow row has differing snapshots, so the flow does not need to be recompiled. 4. Open flow designer and change the flow "stage choice flow" by altering the message in the log action. 5. Activate the flow. Note that the sys_hub_flow row has the same latest and main snapshot, meaning the flow does need to be recompiled. 6. Navigate to sc_req_item.list and observe the page never loads due to an infinite loop loading the stage column.

- Quebec instance 7. Import the other update set . This update set has an action with a stage choice input, rather than a subflow. 8. Order the item "Office Keys". 9. Continue with steps 3-6.

Workaround This problem has been fixed. If you are able to upgrade, review the Fixed In section to determine the latest version with a permanent fix your instance can be upgraded to.

If a workaround is needed, change the subflow input to type String instead of Choice backed by sc_req_item.stage. A Choice not backed by sc_req_item.stage will also work as expected.