0 Replies Latest reply on Aug 2, 2012 7:44 AM by dwhdeveloper

    APEX  File upload abort after long time

    dwhdeveloper
      Hi,

      I am trying to upload big files to individual table with BLOB column. During upload process after long time approx. 2h I get the following error message:

      [#|2012-08-01T19:03:01.667+0200|WARNING|sun-appserver2.1|java.lang.Class|_ThreadID=27;_ThreadName=httpSSLWorkerThread-8082-2;_Reques
      tID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;|oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:236)
      java.io.IOException: ORA-01013: user requested cancel of current operation

      at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:236)
      at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:151)
      at java.nio.channels.Channels$WritableByteChannelImpl.write(Channels.java:296)
      at oracle.dbtools.apex.utilities.StreamCopy.drain(StreamCopy.java:43)
      at oracle.dbtools.apex.utilities.StreamCopy.drain(StreamCopy.java:30)
      at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.getBlob(ApexFileLoader.java:207)
      at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.processApexFileUtil(ApexFileLoader.java:167)
      at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.processFile(ApexFileLoader.java:55)
      at oracle.dbtools.apex.hooks.ProcessorRegistry.fileUploadPreProcess(ProcessorRegistry.java:94)
      at oracle.dbtools.apex.FileUpload.loadFiles(FileUpload.java:52)
      at oracle.dbtools.apex.ModApex.doPost(ModApex.java:121)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
      at oracle.dbtools.rt.web.HttpEndpointBase.defaultServlet(HttpEndpointBase.java:133)
      at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:90)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
      at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:427)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:315)
      at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
      at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
      at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1093)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1093)
      at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:291)
      at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:666)
      at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:597)
      at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:872)
      at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
      at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
      at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
      at com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipeline.java:382)
      at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:264)
      at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
      Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation


      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
      at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:789)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
      at oracle.jdbc.driver.T4C8TTILob.write(T4C8TTILob.java:178)
      at oracle.jdbc.driver.T4CConnection.putBytes(T4CConnection.java:2412)
      at oracle.sql.BLOB.setBytes(BLOB.java:881)
      at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:228)
      ... 43 more
      #]

      [#
           2012-08-01T19:03:01.743+0200      WARNING      sun-appserver2.1      javax.enterprise.system.stream.err      ThreadID=27;ThreadName=httpSSLWorkerTh
      read-8082-2;_RequestID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;

      init: # headers=47
      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:The connection is closed: The connection is closed|#]

      [#|2012-08-01T19:03:01.743+0200|WARNING|sun-appserver2.1|javax.enterprise.system.stream.err|_ThreadID=27;_ThreadName=httpSSLWorkerTh
      read-8082-2;_RequestID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;|
      nm(1) := 'accept';
      vl(1) := 'text/html, application/xhtml+xml, */*';
      nm(2) := 'referer';
      vl(2) := 'http://degtlun1118.server.arvato-systems.de:8082/apex/f?p=108:19:151527714221001::NO';
      nm(3) := 'accept-language';
      vl(3) := 'de-DE';
      nm(4) := 'user-agent';
      vl(4) := 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)';
      nm(5) := 'content-type';
      vl(5) := 'multipart/form-data; boundary=---------------------------7dc10a1f5001c';
      nm(6) := 'accept-encoding';
      vl(6) := 'gzip, deflate';
      nm(7) := 'host';
      vl(7) := 'degtlun1118.server.arvato-systems.de:8082';
      nm(8) := 'content-length';
      vl(8) := '1002208860';
      nm(9) := 'connection';
      vl(9) := 'Keep-Alive';
      nm(10) := 'cache-control';
      vl(10) := 'no-cache';
      nm(11) := 'cookie';
      vl(11) := 'WWV_CUSTOM-F_3062908104789135_108=0B847723FCDB7B7246A26318ACA79A41; LOGIN_USERNAME_COOKIE=scaub01; ORA_WWV_REMEMBER_UN=SC
      AUB01:rzsam_irlacc; ORA_WWV_USER_63105666364946=4D6F39F871BFB3EBFBA81249BBC0BF0B';
      nm(12) := 'APEX_LISTENER_VERSION';
      vl(12) := '1.1.3.243.11.40';
      nm(13) := 'DAD_NAME';
      vl(13) := '';
      nm(14) := 'DOC_ACCESS_PATH';
      vl(14) := '';
      nm(15) := 'DOCUMENT_TABLE';
      vl(15) := '';
      nm(16) := 'GATEWAY_IVERSION';
      vl(16) := '3';
      nm(17) := 'GATEWAY_INTERFACE';
      vl(17) := 'CGI/1.1';
      nm(18) := 'HTTP_ACCEPT';
      vl(18) := 'text/html, application/xhtml+xml, */*';
      nm(19) := 'HTTP_ACCEPT_ENCODING';
      vl(19) := 'gzip, deflate';
      nm(20) := 'HTTP_ACCEPT_LANGUAGE';
      vl(20) := 'de-DE';
      nm(21) := 'HTTP_ACCEPT_CHARSET';
      vl(21) := 'null';
      nm(22) := 'HTTP_COOKIE';
      vl(22) := 'WWV_CUSTOM-F_3062908104789135_108=0B847723FCDB7B7246A26318ACA79A41; LOGIN_USERNAME_COOKIE=scaub01; ORA_WWV_REMEMBER_UN=SC
      AUB01:rzsam_irlacc; ORA_WWV_USER_63105666364946=4D6F39F871BFB3EBFBA81249BBC0BF0B';
      nm(23) := 'HTTP_IF_MODIFIED_SINCE';
      vl(23) := 'null';
      nm(24) := 'HTTP_IF_NONE_MATCH';
      vl(24) := 'null';
      nm(25) := 'HTTP_HOST';
      vl(25) := 'degtlun1118.server.arvato-systems.de:8082';
      nm(26) := 'HTTP_ORACLE_ECID';
      vl(26) := '';
      nm(27) := 'HTTP_PORT';
      vl(27) := '8082';
      nm(28) := 'HTTP_REFERER';
      vl(28) := 'http://degtlun1118.server.arvato-systems.de:8082/apex/f?p=108:19:151527714221001::NO';
      nm(29) := 'HTTP_USER_AGENT';
      vl(29) := 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)';
      nm(30) := 'PATH_ALIAS';
      vl(30) := ' ';
      nm(31) := 'PATH_INFO';
      vl(31) := '/wwv_flow.accept';
      nm(32) := 'PLSQL_GATEWAY';
      vl(32) := 'WebDb';
      nm(33) := 'QUERY_STRING';
      vl(33) := 'null';
      nm(34) := 'REMOTE_ADDR';
      vl(34) := '162.49.176.225';
      nm(35) := 'REMOTE_USER';
      vl(35) := 'APEX_PUBLIC_USER';
      nm(36) := 'REQUEST_CHARSET';
      vl(36) := 'AL32UTF8';
      nm(37) := 'REQUEST_IANA_CHARSET';
      vl(37) := 'UTF-8';
      nm(38) := 'REQUEST_METHOD';
      vl(38) := 'POST';
      nm(39) := 'REQUEST_PROTOCOL';
      vl(39) := 'http';
      nm(40) := 'REQUEST_SCHEME';
      vl(40) := 'http';
      nm(41) := 'SCRIPT_NAME';
      vl(41) := '/apex';
      nm(42) := 'SCRIPT_PREFIX';
      vl(42) := '';
      nm(43) := 'SERVER_NAME';
      vl(43) := 'degtlun1118.server.arvato-systems.de';
      nm(44) := 'SERVER_PORT';
      vl(44) := '8082';
      nm(45) := 'SERVER_PROTOCOL';
      vl(45) := 'HTTP/1.1';
      nm(46) := 'SERVER_SOFTWARE';
      vl(46) := 'Mod-Apex';
      nm(47) := 'WEB_AUTHENT_PREFIX';
      vl(47) := ' ';
      #]

      [#
           2012-08-01T19:03:01.744+0200      WARNING      sun-appserver2.1      javax.enterprise.system.stream.err      ThreadID=27;ThreadName=httpSSLWorkerTh
      read-8082-2;_RequestID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;

      The connection is closed: The connection is closed|#]

      [#|2012-08-01T19:03:01.744+0200|WARNING|sun-appserver2.1|javax.enterprise.system.stream.err|_ThreadID=27;_ThreadName=httpSSLWorkerTh
      read-8082-2;_RequestID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;|
      The connection is closed: The connection is closed|#]

      I am using Glassfish Server v2.1.1 with APEX Listener v1.1.3.243.11.40
      The Timeout parameters for JDBC settings in APEX Listener are default. Thus I would expect to abort earlier to be an issue of JDBC Connection?

      Anybody an idea?

      Thanks!