Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Pankti.

Asked: March 30, 2020 - 12:25 pm UTC

Answered by: Connor McDonald - Last updated: March 31, 2020 - 6:03 am UTC

Category: Application Express - Version: 18.2

Viewed 100+ times

You Asked

We have an application in Oracle APEX where we do not have a large database and the number of pages used in the application would be max 250. However, there is a 500 Internal Server error that we are encountering since the last 3-4 days and we have not made any major changes in the application in the last 3-4 days.
We have not been able to debug which page, which process or which object in Oracle apex or Oracle Database is causing the error.
There are many applications deployed on that server and it is difficult to find out which particular application is causing this issue.

We are using Oracle Apex 18.2 and Oracle Database Standard Edition 11.2.

Please help us in debugging the issue as it is impacting many of our LIVE applications and clients.

and we said...

The "internal server error" will be most likely be coming back from ORDS on the webserver you are using host application express.

So check your ORDS logs (location will depend on what webserver etc you are using) and normally (if its a database error) then the database error (ORA- etc) will have been captured in the ORDS logs.

If that does not assist *and* the error is reproducible on demand, you could activate tracing for the ORDS sessions on the database with something like:

set serverout on
begin
for i in ( select sid, serial#
           from v$session
           where username in ('ORDS_PUBLIC_USER')
           ) loop
       dbms_output.put_line(i.sid||','||i.serial#);
       dbms_monitor.SESSION_TRACE_ENABLE(i.sid, i.serial#, true,true);
end loop;
end;
/


and then re-generate your error and then examine your trace directory for trace files.

Don't forget to turn *off* trace for those session with "session_trace_disable"



More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.