ORDS, SODA & JSON in the Database

Hi,

We are experiencing connection reset issues with apex listener 1.0 every time the server stays without an active connection for some time (Error : HTTP 500 on the browser when we try to load the application - After the error, we refresh the page and everything is back to normal.)

We have other java applications that are deploy on this server and we don't have any "connection reset" problem on those applications.

Is there a parameter that can be initialize in the apexConfig.xml so that we don't have this kind of error every once a will. Or is there another solution to correct this problem.


Here is what we have in the server log when this error happens:

/****************************************************************************************************************************/
==== doGet()====


isValidRequest(), procedure name: <f>

Validating:f

*** Found procedure in cache: f*** Total number of arguments: 12_init_: # header
s=42
declare nm owa.vc_arr := ?;
vl owa.vc_arr := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
INIT FAILED:Exception d'E/S: Connection reset
nm(1) := 'Accept';
vl(1) := 'image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwa
ve-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/m
sword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-x
psdocument, application/xaml+xml, */*';
nm(2) := 'User-Agent';
vl(2) := 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6.5
; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; InfoPath.2; .NET CLR 3.0.45
06.2152; .NET CLR 3.5.30729)';
nm(3) := 'Accept-Encoding';
vl(3) := 'gzip, deflate';
nm(4) := 'Cookie';
vl(4) := 'EnapAlert=datealert=';
nm(5) := 'Host';
vl(5) := 'XXXXXXXXXXXX';
nm(6) := 'Connection';
vl(6) := 'Keep-Alive';
nm(7) := 'Accept-Language';
vl(7) := 'fr-ca';
nm(8) := 'APEX_LISTENER_VERSION';
vl(8) := '1.10.179.10.43';
nm(9) := 'DAD_NAME';
vl(9) := '';
nm(10) := 'DOC_ACCESS_PATH';
vl(10) := '';
nm(11) := 'DOCUMENT_TABLE';
vl(11) := '';
nm(12) := 'GATEWAY_IVERSION';
vl(12) := '3';
nm(13) := 'GATEWAY_INTERFACE';
vl(13) := 'CGI/1.1';
nm(14) := 'HTTP_ACCEPT';
vl(14) := 'image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockw
ave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/
msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-
xpsdocument, application/xaml+xml, */*';
nm(15) := 'HTTP_ACCEPT_ENCODING';
vl(15) := 'gzip, deflate';
nm(16) := 'HTTP_ACCEPT_LANGUAGE';
vl(16) := 'fr-ca';
nm(17) := 'HTTP_ACCEPT_CHARSET';
vl(17) := 'null';
nm(18) := 'HTTP_COOKIE';
vl(18) := 'EnapAlert=datealert=';
nm(19) := 'HTTP_IF_MODIFIED_SINCE';
vl(19) := 'null';
nm(20) := 'HTTP_IF_NONE_MATCH';
vl(20) := 'null';
nm(21) := 'HTTP_HOST';
vl(21) := 'XXXXXXXXXXX:443';
nm(22) := 'HTTP_ORACLE_ECID';
vl(22) := '';
nm(23) := 'HTTP_PORT';
vl(23) := '443';
nm(24) := 'HTTP_REFERER';
vl(24) := 'null';
nm(25) := 'HTTP_USER_AGENT';
vl(25) := 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6.
5; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; InfoPath.2; .NET CLR 3.0.4
506.2152; .NET CLR 3.5.30729)';
nm(26) := 'PATH_ALIAS';
vl(26) := ' ';
nm(27) := 'PATH_INFO';
vl(27) := '/f';
nm(28) := 'PLSQL_GATEWAY';
vl(28) := 'WebDb';
nm(29) := 'QUERY_STRING';
vl(29) := 'p=119:1';
nm(30) := 'REMOTE_ADDR';
vl(30) := 'XXX.XXX.XXX.XXX';
nm(31) := 'REMOTE_USER';
vl(31) := 'APEX_PUBLIC_USER';
nm(32) := 'REQUEST_CHARSET';
vl(32) := 'AL32UTF8';
nm(33) := 'REQUEST_IANA_CHARSET';
vl(33) := 'UTF-8';
nm(34) := 'REQUEST_METHOD';
vl(34) := 'GET';
nm(35) := 'REQUEST_PROTOCOL';
vl(35) := '/1.1';
nm(36) := 'SCRIPT_NAME';
vl(36) := '/apex';
nm(37) := 'SCRIPT_PREFIX';
vl(37) := '';
nm(38) := 'SERVER_NAME';
vl(38) := 'XXXXXXXX';
nm(39) := 'SERVER_PORT';
vl(39) := '443';
nm(40) := 'SERVER_PROTOCOL';
vl(40) := 'HTTP/1.1';
nm(41) := 'SERVER_SOFTWARE';
vl(41) := 'Mod-Apex';
nm(42) := 'WEB_AUTHENT_PREFIX';
vl(42) := ' ';

Exception d'E/S: Connection reset
Connexion interrompue


Got results length:NULL


/***************************************************************************************************************************/


Here is what we have in the apexListener error log :

/***************************************************************************************************************************/

--- 10-07-24 09:29 ( 50 Minutes 17 Seconds Ago ) ---
Exception d'E/S: Connection reset


/***************************************************************************************************************************/


Thanks for your help...