Skip to Main Content
Feature Request FR-4180
Product Area APEX on OCI
Status CLOSED

4 Voters

Increase http timeout time for autonomous Database since some utilites requires an APEX session to work even asynchronously

jflores Public · Jan 4 2025

Idea Summary
Currently the http timeout is only 5 minutes when using Oracle's managed ORDS

Use Case
HTTP timeout with 5 min is too low for enterprise applications, specially if running printing reports using OAC. I know APEX teams mentions that you need to move to asynchronous transactions but that does not works for some pkgs like APEX_UTIL, this and so many other needs an APEX session to work, HTTP timeout should go along with OCPU's assigned to ADB or user should be able to increase.

Custom Managed ORDS lost the whole purpose of having an ABD.

APEX_UTIL is used for printing pixel perfect reports using OAC as print server, now we have a timeout for reports since there is no workaround.

Preferred Solution (Optional)
OCI Admin should be able to increase http timeout limit.

We reviewed this idea carefully and came to the conclusion that it does not constitute an appropriate APEX feature request.

Comments

Comments

  • jayson hanes Admin OP 8 months ago

    @jflores the ADB/OCI team owns this type of configuration and such is out of the control of the APEX team and APEX product.

    The work-around would be for you to explore background executions for these types of processes. If you need help with that, please create a post on our forum https://apex.oracle.com/forum

  • jflores OP 8 months ago

    Hi Jason, as I mentioned asynchronous transactions does not works since APEX_UTIL requires an APEX session created via PLSQL.

    I guess my only possible solution is to create our own custom managed ORDS and hope that works, its just hard to understand why there is a such of limitation even for this asynchronous transaction where ADB/OCI is supposed to be for enterprise applications.

  • jflores OP 8 months ago

    same issue happens when loading applications to APEX workspace, if app is big enough to take more than 5 min, then you get the http timeout error.

    Maybe APEX should process this asynchronously.

  • jayson hanes Admin OP 8 months ago

    @jflores your last comment is indeed valid; feel free to submit that as a new idea :)