This discussion is archived
4 Replies Latest reply: Nov 25, 2013 2:34 AM by Christian Neumueller RSS

APEX page crashes due to server internal error

skapex Newbie
Currently Being Moderated

I get below error on my apex page

 

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

On my page i have a PL/SQL region which builds report query and uses global temporary table in which data is inserted..some update,delete operations are performed and then from temporary table report is created

 

Report data is built on few conditions.

In one condition it works fine page loads but for second it gives above error.

 

My first suspect was with data fetched so i restricted no. of rows returned..till 280 its working fine,more than 280 it gives this error.

For second condition it fetches total 1160 rows.I ran it in toad and takes almost 1 min to execute the query

 

Is it due to data??

How to check error log files?? I checked in APEX>Administration>monitor activity if there is any error -but it doesn't record any error

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points