search

flowsforapex / apex-flowsforapex

Flows for APEX - Model and run process flows all within Oracle APEX!
https://flowsforapex.org
Other
80 stars 40 forks source link

[bug]: Database 23c Free: ORA-01403: no data found after start a flow #675

Closed ljvankempen closed 9 months ago

ljvankempen commented 10 months ago

Flows for APEX version

23.1 (latest)

Oracle Database version

23c

Oracle APEX version

23.1

Have you used the BPMN-Linter in Flow Designer to Validate your Diagram?

No

What happened?

image

Steps to reproduce

Start / Run a flow.

Happens on all flows

Expected behaviour

THat it runs without error.

Nothing to find in the alert-log

rallen2010 commented 10 months ago

can we have a quick zoom call to see / help? Email me at Richard.allen@ora***.com

ljvankempen commented 10 months ago

Hi

1) I have installed the app in an other workspace with ony one schema , this makes no difference.

2) I have create the Getting started app. And got the same eror , but now with a trace.

Begin flow_start | 3 |   -- | -- | -- 0.03140 | 0.00060 | start_process Process_ID=>3 | 5 |   0.03200 | 0.00025 | Process Priority : Due On : | 4 |   0.03225 | 0.00069 | Found starting object Event_1gmoy95 | 4 |   0.03294 | 0.00226 | subflow_start Process=>3,Parent Subflow=> | 5 |   0.03520 | 0.00048 | Exception in "begin declare begin wwv_flow_plugin_api.g_process_exec_result := flow_plugin_manage_instance.execution (p_process => wwv_flow_plugin_api.g_process,p_plugin => wwv_flow_plugin_api.g_plugin );end; end;": Error Stack: ORA-01403: no data found ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 Backtrace: ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 | 2 |   0.03568 | 0.00036 | Exception in "Create and Start Instance": Error Stack: ORA-01403: no data found ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 399 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC", line 553 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 2285 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3467 Backtrace: ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 399 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC", line 553 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 2285 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3467 ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS", line 189 | 2 |   0.03604 | 0.00171 | Add error onto error stack: ORA-01403: no data found | 2 |   0.03775 | 0.00060 | Hiding error additional_info, as it contains ORA error message: ORA-01403: no data found | 1 |   0.03835 | 0.00028 | Error: ORA-01403: no data found - Additional info: ORA-01403: no data found - Display location: INLINE_IN_NOTIFICATION - Association type: - Item name: - Region id: - Column alias: - Row: - Model instance id: - Model record id: - Internal error: false - Common runtime error: false - APEX error code: - SQL code: 100 - SQL error: ORA-01403: no data found ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 399 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC", line 553 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 2285 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3467 - Backtrace: ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 132 ORA-06512: at "FLOW4APEX.FLOW_ENGINE_UTIL", line 340 ORA-06512: at "FLOW4APEX.FLOW_INSTANCES", line 351 ORA-06512: at "FLOW4APEX.FLOW_API_PKG", line 121 ORA-06512: at "FLOW4APEX.FLOW_PLUGIN_MANAGE_INSTANCE", line 440 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2194 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMI~ - Statement: begin declare begin wwv_flow_plugin_api.g_process_exec_result := flow_plugin_manage_instance.execution (p_process => wwv_flow_plugin_api.g_process,p_plugin => wwv_flow_plugin_api.g_plugin );end; end; - Component: APEX_APPLICATION_PAGE_PROCESS Create and Start Instance (16392240939541202) | 1 |   0.03863 | 0.00005 | < APEX_APPLICATION_PAGE_PROCESS Create and Start Instance | 3 |   0.03868 | 0.00007 | ...Inline Errors detected, performing rollback | 4 |   0.03875 | 0.00373 | Emit errors as JSON | 4 |   0.04247 | 0.00004 | service "freepdb1" is already active. No need to switch.
rallen2010 commented 10 months ago

These problems replicate on database 23c, which is not yet production. There are currently a few issues running on 23c, and we have not yet been able to fix and fully test these. We will do more testing as 23c becomes available.

rallen2010 commented 9 months ago

This issue is a database issue in 23c 23.3.0. A workaround has been incorporated into a patch for Flows for APEX 23.1 which avoids this problem.
Hotfix file combo-fix-675-676-681.sql is available as a Release 23.1 asset at https://github.com/flowsforapex/apex-flowsforapex/releases/tag/v23.1 and which addresses this issue and provides support for Oracle Database 23c (23.3.0). This patch has been tested on both 19c and 23c (23.3.0) databases, including 23c Free (23.3.0).