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
you should have a look at the web server log files. You mentioned that the query runs 1 min in Toad. I suspect that you are running into a web server timeout, where it aborts the request if it does not complete in a fixed amount of time. 1 minute is a very long time to display information in the browser.