7 Replies Latest reply: Apr 10, 2013 1:19 PM by Jayson Hanes RSS

    File Upload --->  Internal server error 500

    Maris Gabalins
      Hi,

      My envionment:

      Oracle EE 11.2.0.3.0 - 64bit Production, APEX 4.2.1, Apex Listener 2.0.0.354.17.06 under Tomcat 6.0.24 (Yes I know it is unsupported), all running Oracle Linux 6.3.

      Error occurs when in apex developer I try to import application (approx 900k, but I tried several files) - got error 500 after first screen. Everything works fine using built in EPG, so it is not an APEX problem.

      Maybe somebody have some hint about a possible solution ? Below tomcat LOG file:

      INFO: Deploying web application archive apex.war
      Mar 2, 2013 6:39:35 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /etc/apex/apex
      Configuration properties for: apex
      apex.docTable=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$
      apex.excel2collection=true
      apex.excel2collection.name=APEX$EXCEL
      apex.excel2collection.onecollection=true
      apex.excel2collection.useSheetName=false
      apex.extensions=
      cache.caching=false
      cache.directory=/tmp/apex/cache
      cache.duration=days
      cache.expiration=7
      cache.maxEntries=500
      cache.monitorInterval=60
      cache.procedureNameList=
      cache.type=lru
      db.connectionType=basic
      db.customURL=
      db.hostname=oradev2.limbo.lv
      db.password=******
      db.port=1521
      db.servicename=
      db.sid=orcl
      db.tnsAliasName=
      db.tnsDirectory=
      debug.debugger=false
      debug.printDebugToScreen=false
      error.keepErrorMessages=true
      error.maxEntries=50
      icap.port=
      icap.server=
      jdbc.DriverType=thin
      jdbc.InactivityTimeout=1800
      jdbc.InitialLimit=3
      jdbc.MaxConnectionReuseCount=1000
      jdbc.MaxLimit=10
      jdbc.MaxStatementsLimit=10
      jdbc.MinLimit=1
      jdbc.statementTimeout=900
      log.logging=false
      log.maxEntries=50
      log.procedure=false
      misc.compress=
      misc.defaultPage=apex
      procedure.postProcess=
      procedure.preProcess=
      security.disableDefaultExclusionList=false
      security.exclusionList=
      security.inclusionList=
      security.maxEntries=2000
      security.requestValidationFunction=
      security.validationFunctionType=plsql
      security.verifySSL=false
      sqldev.description=
      sqldev.name=apex
      sqldev.version=3.2.20.09.87
      db.username=APEX_PUBLIC_USER
      Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0
      Mar 2, 2013 6:39:37 PM oracle.dbtools.rt.web.SCListener contextInitialized
      INFO: Oracle Application Express Listener initialized
      Application Express Listener version : 2.0.0.354.17.06
      Application Express Listener server info: Apache Tomcat/6.0.24

      ........ following lines at the moment of error ....

      Mar 2, 2013 6:40:49 PM oracle.dbtools.rt.web.WebErrorResponse internalError
      SEVERE: For input string: ""
      java.lang.NumberFormatException: For input string: ""
           at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
           at java.lang.Integer.parseInt(Integer.java:493)
           at java.lang.Integer.parseInt(Integer.java:514)
           at oracle.dbtools.listener.icap.ICAPScan.getScanner(ICAPScan.java:74)
           at oracle.dbtools.listener.icap.ICAPScan.scanStream(ICAPScan.java:44)
           at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.getBlob(ApexFileLoader.java:269)
           at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.processApexFileUtil(ApexFileLoader.java:217)
           at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.processFile(ApexFileLoader.java:73)
           at oracle.dbtools.apex.hooks.ProcessorRegistry.fileUploadPreProcess(ProcessorRegistry.java:95)
           at oracle.dbtools.apex.FileUpload.loadFiles(FileUpload.java:62)
           at oracle.dbtools.apex.ModApex.doPost(ModApex.java:148)
           at oracle.dbtools.apex.ModApex.service(ModApex.java:318)
           at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:260)
           at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:110)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
           at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
           at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
           at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
           at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
           at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
           at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
           at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
           at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
           at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
           at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
           at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
           at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
           at java.lang.Thread.run(Thread.java:679)

      Sincerely
      Maris