Opening Process Flow components Tab results in a "maximum open cursors exceeded" error

Document ID : KB000103470
Last Modified Date : 26/06/2018
Show Technical Document Details
Issue:

Adding Job or Process Flow to an existing Process Flow in such a way that it references itself can cause the below error when attempting to view the Components Tab of that Process Flow.

java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPWORX.AW_WEB_API", line 1809
ORA-06512: at "APPWORX.AW_WEB_API", line 1816
ORA-06512: at "APPWORX.AW_WEB_API", line 1823
ORA-06512: at "APPWORX.AW_WEB_API", line 1823
ORA-06512: at "APPWORX.AW_WEB_API", line 1823

An example where this occurs is if Job A is added as an component and a external reference. Another way is to to have Process Flow B in Process Flow A and Process Flow A is in Process Flow B. Such situation will cause an infinite referencing loop that will cause a "maximum open cursors exceeded" error when the Components Tab in a Process Flow is selected.
Resolution:
The only solution is to delete the component or Sub Process Flow from the main Process Flow using the below sql:

Delete from so_chain_detail where so_chain_seq = (select so_job_seq from so_job_table where so_module = '<PARENT_PROCESS_FLOW>') And so_task_name = '<COMPONENT_OR_PROCESS_FLOW_CAUSING_ISSUE>';

commit;