[bug]: Installation Problem on Oracle APEX 24.2.0 (Cloud)

[peter-bpm]

Flows for APEX version

24.1

Oracle Database version

23ai

Oracle APEX version

newer

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

No

What happened?

Please help! Is this A bug or am I doing something wrong? Started the installation of the "flowsforapex_apex221.sql" file in Oracle APEX Environment. I am using Oracle APEX 24.2.0. See Screenshots - everything ist started as expected and as described in the release notes, but then it delivers an error:

An error occurred while processing your request.
Reference #221.215a1602.1737391740.e5148ec

https://errors.edgesuite.net/221.215a1602.1737391740.e5148ec

Steps to reproduce

Tried multiple times to install, then I created a complete new APEX Workspace form scratch to install it - still the same issue.

Expected behaviour

No response

[nielsdebr]

Hi Peter, thanks for your message. We will check this out. APEX 24.2 was released a few days ago, so it could be related.

[nielsdebr]

We were able to reproduce your problem. It is specific to APEX 24.2.0 and related to the parser of supporting objects. Due to this, some views aren't installed in the database. The problem is not related to the database version (19c/23ai).

Solution 1: wait for a patchset for APEX (24.2.x) and install that first before installing Flows for APEX 24.1
Solution 2: install Flows for APEX 24.1 in a supported APEX release up to 24.1.
Solution 3: we are working on bringing out a "one-off" packaged app of Flows for APEX 24.1 that can be installed on APEX 24.2.0.

[peter-bpm]

Thanks for investigating and for the proposed solutions. Solution2 would help immediately, but I guess not available with the APEX cloud workspace. For solutions 1 and 3 are there any short term releases planned, which would solve it? Thanks PeterGesendet mit der GMX iPhone AppAm 21.01.25 um 11:06 schrieb Niels de Bruijn Von: "Niels de Bruijn" ***@***.***>Datum: 21. Jänner 2025An: "flowsforapex/apex-flowsforapex" ***@***.***>Cc: "Author" ***@***.***>,"peter-bpm" ***@***.***>Betreff: Re: [flowsforapex/apex-flowsforapex] [bug]: Installation Problem on Oracle APEX 24.2.0 (Cloud) (Issue #782) We were able to reproduce your problem. It is specific to APEX 24.2.0 and related to the parser of supporting objects. Due to this, some views aren't installed in the database. The problem is not related to the database version (19c/23ai). Solution 1: wait for a patchset for APEX (24.2.x) and install that first before installing Flows for APEX 24.1 Solution 2: install Flows for APEX 24.1 in a supported APEX release up to 24.1. Solution 3: we are working on bringing out a "one-off" packaged app of Flows for APEX 24.1 that can be installed on APEX 24.2.0. —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[rallen2010]

Unfortunately there is a bug/ regression in the APEX 24.2.0 application installer which prevents a clean installation of Flows for APEX 24.1 Community Edition onto APEX 24.2.0 and 24.2.1. Oracle is aware of this problem, and is working on a fix that we hope will be released in a 24.2.2 patch release. (I will update this once we know a fix is available / released).

When you install Flows for APEX 24.1 Community Edition (CE) in the APEX 24.2.0 Application Builder > Import, the following will occur:

• Upload the flowsforapex_apex221.sql file. Should succeed as normal...
• Install the Application. This should succeed as normal...
• Supporting Objects. If you run this, it will FAIL -
  - if you have attempted to run Install Supporting Objects and it failed, look at the Install Log and you should see that it reports 1 error in the Views file and 1 error in the PL/SQL Package Bodies file.
  - If it failed, you should deinstall the Application, check that all Supporting Objects were deleted, then reinstall from scratch - following the instructions below to fix Supporting Objects before you Install Supporting Objects....

Better, don't run Install Supporting Objects ....but instead ...

• Upload the flowsforapex_apex221.sql file. Should succeed as normal...

• Install the Application. This should succeed as normal...

• Inspect the Supporting Objects. We're going to replace the Views script BEFORE you install the supporting objects.

• Download the file hotfix782-views.sql from the release assets at https://github.com/flowsforapex/apex-flowsforapex/releases/tag/v24.1

• In Supporting Objects > Scripts, click on the Views entry (3rd item, sequence 30 in the list).

• In the Script Properties tab, Script region, use. the New Script - Choose File item to select your downloaded hotfix782-views.sql file. Click Apply Changes.

• Returning to the Supporting Objects > Scripts page, select Install Supporting Objects from the Tasks panel on the right hand side.

• Supporting Objects should now install cleanly...

[nielsdebr]

APEX 24.2.2 got released and has the bug fixed.

apex.oracle.com is now also on 24.2.2. I could succesfully install Flows for APEX 24.1 on apex.oracle.com without encountering the mentioned error.