Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
ORDS - 500 Internal Server Error when using Ressource limits — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORDS - 500 Internal Server Error when using Ressource limits

Received Response
13
Views
3
Comments
edited Apr 16, 2022 7:50AM in Autonomous Database 3 comments

Summary

Setting a Ressource Query time limit for "Low" and ORDS will stop working (500 Internal Server Error)

Content

Steps to reproduce (on free tier cloud)

1. Create an ATP instance. Setup any workspace. Test if you can access APEX (login page is enough).

2. Set a ressource limit for SQL Queries for the "LOW" ressource, for example set it to 20 seconds.

3. wait a little

4. The access to APEX will stop working after a couple of minutes. An ORDS error (500) is reported.

Any db connections will still work and will correctly get error messages when a queries runs longer than 20 secs.

 

 

 

 

 

Version

19.5 DB

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!