Error -Error APEX Error

BisRocket

Recently we have been getting "Error -Error" error /issues with our apex applications. We have filed many SR's and are trying to figure out what the issue is.

Not exactly sure the issue but it seems to be ok at first for the user in using the application and then manifests itself into not being able to save a record and then somehow a 503 error where users cant seem to access the application at all.

When a reboot of ORDS, and Tom CAT is done this seems to solve the issue for a short period of time and then comes up again days, or weeks later.

We are running ATP in Oracle Cloud with dedicated ORDS Servers.

Any thoughts would be greatly appreciated

Files are uploaded with examples.

65635849626__7BE71E0E-D680-4E0D-B6B7-BC49D6E68501.jpeg

65635851445__92EB3A5B-F707-4A0B-979D-170B0A410B7D.jpeg

IMG_2018.jpeg

msammour

Try to increase the number of [Maximum Web Service Requests] to 20000, you can find it in:

Manage Workspaces -> Existing Workspaces -> Select your workspace -> Maximum Web Service Requests

BisRocket

https://community.oracle.com/tech/developers/discussion/comment/16813962#Comment_16813962

Thank you for your response,

Actually we did this already and increased to 30,000 or so and still having an issue. We changed from the default to about 20000 and then a bit higher and still having the same issue.

I am not sure if this error seems to relate to a 503 error and the application being completely "DOWN"

Any other thoughts, can I ask what this error actually means? - Is there some correlation to MAX Sessions on APEX or MAX sessions on ATP DB?

msammour

From that error in screen shot I can say it is related to APEX sessions, can you confirm these values in defaults.xml:

<entry key="jdbc.InitialLimit"></entry>
<entry key="jdbc.MaxConnectionReuseCount"></entry>
<entry key="jdbc.MaxLimit"></entry>
<entry key="jdbc.MinLimit"></entry>

BisRocket

https://community.oracle.com/tech/developers/discussion/comment/16813966#Comment_16813966

OK thank you again. I know we have made some changes in this area, however I am not sure if we touched on

<entry key="jdbc.InitialLimit"></entry>
<entry key="jdbc.MaxConnectionReuseCount"></entry>
<entry key="jdbc.MaxLimit"></entry>
<entry key="jdbc.MinLimit"></entry>

I will check and let you know.

Not sure if this relates: That being said, we are on ATP DB and there is a MAX session count of concurrent 300 sessions per processor and we have 2 processors so that is 600 sessions and auto scaling is on so that means it can go up to approx. 1800 sessions. That being said,

. Thank you again

BisRocket

https://community.oracle.com/tech/developers/discussion/comment/16813966#Comment_16813966

Below are the details we have set

<entry key="plsql.gateway.enabled">true</entry>

 <entry key="jdbc.InitialLimit">5</entry>

 <entry key="jdbc.MaxLimit">60000</entry>

<entry key="jdbc.MaxStatementsLimit">800</entry>

<entry key="jdbc.InactivityTimeout">3000</entry>

<entry key="jdbc.statementTimeout">900</entry>

<entry key="jdbc.MaxConnectionReuseCount">50000</entry>