My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.