4 Replies Latest reply on Nov 25, 2013 10:34 AM by Christian Neumueller-Oracle

    APEX page crashes due to server internal error


      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