Application Timing Out With HTTP Status 500 Exception Reports When Using APEX Listener Deployed to GlassFish Server (Doc ID 1590738.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Express Listener - Version 2.0.2 and later
Information in this document applies to any platform.

Symptoms

Application is timing out with HTTP status 500 exception reports. Server encountered an internal error() that prevented it from fulfilling this request. The application is pulling massive data over a dblink. One query is bringing back 3572 rows from the remote data tables and inserting into the remote database table and the other query is bringing back 36 rows from the remote data tables and inserting into a remote database  table.  The third query simply merges the contents from the first 2 tables into the third table on the remote database.  The entire procedure executes on the remote database, and returns rows inserted on the remote database. Time out varies ... appears to be after the program code has completed (program has run for around 2 hours extracting the data.) Check after the error, the data is correctly written.

The GlassFish Server (version 3.1.2.2) log shows:


server log
---------------
...
;|GRIZZLY0023: Interrupting idle Thread: http-thread-pool-8585(5).|#]

[#|2013-09-23T10:01:12.330-0500|WARNING|oracle-glassfish3.1.2|com.sun.grizzly.config.GrizzlyServiceListener|_ThreadID=47;_ThreadName=Thread-12;|GRIZZLY0023: Interrupting idle Thread: http-thread-pool-8585(5).|#]

[#|2013-09-23T10:01:12.593-0500|SEVERE|oracle-glassfish3.1.2|null|_ThreadID=130;_ThreadName=Thread-12;|java.lang.InterruptedException
oracle.dbtools.common.util.AbortedException: java.lang.InterruptedException
at oracle.dbtools.common.util.TransformCache.apply(TransformCache.java:70)
at oracle.dbtools.common.config.file.ConfigurationFiles.values(ConfigurationFiles.java:350)
at oracle.dbtools.common.config.file.ConfigurationFiles.access$300(ConfigurationFiles.java:44)
at oracle.dbtools.common.config.file.ConfigurationFiles$ConfigurationFile.child(ConfigurationFiles.java:488)
at oracle.dbtools.common.config.file.ConfigurationFiles$ConfigurationFile.values(ConfigurationFiles.java:481)
at oracle.dbtools.common.config.ConfigurationBase.get(ConfigurationBase.java:49)
at oracle.dbtools.common.config.GlobalConfiguration.get(GlobalConfiguration.java:46)

...

...

...

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms