Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Pankti.

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

Last updated: September 27, 2023 - 1:44 pm UTC

Version: 18.2

Viewed 10K+ times! This question is

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 Connor 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"



Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

spot on

A reader, September 14, 2023 - 10:51 am UTC

solved my error too, many thanks
Chris Saxon
September 27, 2023 - 1:44 pm UTC

Glad we could help

More to Explore

APEX

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