APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Has Apex 5.1.x a running max time up to 120 seconds?

MassimoOct 10 2017 — edited Oct 10 2017

I can not run a report that lasts more than 120 seconds, otherwise I receive a blank page without any error code.

I'm running on Apex 5.1.3.00.05

To test I also used the following script in SQL Commands inside Apex:

BEGIN
    DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
    APEX_UTIL.PAUSE(130);
    DBMS_OUTPUT.PUT_LINE('End   ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
END;

In 5.1.3 I don't receive any message for any pause >= 60 secs

I tested the same code on Oracle cloud (actually updated to 5.1.0.00.45) and I receive my two message lines but after at most 120 secs, also with a sleep time > of 120

I can't think I found such a so big bug for which I think there is an explanation or a parameter to be configured somewhere.

In my old production environment with Apex 4.2.6 my report runs smoothly with an execution time of about 140 secs.