5 Replies Latest reply: Jan 10, 2013 10:32 AM by Nattu RSS

    Bugreport: Importing issue in APEX 4.1.1 with APEX listener 2.0 EA2

    685473
      Using the APEX listener 2.0 EA2 (2.0.0.268.17.04) it raises an Internal Error while trying to import applications, image files, plugins, etc. in APEX 4.1.1.00.23 (See below).
      It doesn't matter if you use the standalone version or Weblogic as application server.

      With the APEX listener 1.1.4 there is no issue importing APEX files.

      In the standalone command box it shows the following:
      Using JDBC driver: Oracle JDBC driver version: 11.2.0.1.0
      Oct 2, 2012 10:26:15 AM oracle.dbtools.rt.web.SCListener contextInitialized
      INFO: Oracle Application Express Listener initialized
      Application Express Listener version : 2.0.0.268.17.05
      Application Express Listener server info: Grizzly/1.9.49

      Oct 2, 2012 10:26:15 AM com.sun.grizzly.Controller logVersion
      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 10/2/12 10:26 AM
      Oct 2, 2012 10:26:15 AM oracle.dbtools.standalone.Standalone execute
      INFO: http://localhost:8082/apex started.
      Configuration properties for: apex_al
      apex.docTable=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$
      apex.excel2collection=false
      apex.excel2collection.name=
      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=192.168.72.134
      db.password=******
      db.port=1521
      db.servicename=
      db.sid=vozg
      db.tnsAliasName=
      db.tnsDirectory=
      db.username=APEX_LISTENER
      debug.debugger=true
      debug.printDebugToScreen=true
      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=true
      log.maxEntries=100
      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=Administration Settings
      sqldev.version=3.2.10.09.57
      Oct 2, 2012 10:27:19 AM com.sun.grizzly.http.servlet.ServletAdapter doService
      SEVERE: service exception:
      java.lang.NumberFormatException: For input string: ""
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
      at java.lang.Integer.parseInt(Integer.java:470)
      at java.lang.Integer.parseInt(Integer.java:499)
      at oracle.dbtools.listener.icap.ICAPScan.getScanner(ICAPScan.java:77)
      at oracle.dbtools.listener.icap.ICAPScan.scanStream(ICAPScan.java:50)
      at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.getBlob(ApexFileLoader.java:210)
      at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.processApexFileUtil(ApexFileLoader.java:174)
      at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.processFile(ApexFileLoader.java:58)
      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:123)
      at oracle.dbtools.apex.ModApex.service(ModApex.java:265)
      at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:288)
      at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:127)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)
      at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)
      at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)
      at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:65)
      at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)
      at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
      at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)
      at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
      at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
      at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
      at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
      at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
      at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
      at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
      at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
      at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
      at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
      at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
      at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
      at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
      at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
      at java.lang.Thread.run(Thread.java:662)
        • 1. Re: Bugreport: Importing issue in APEX 4.1.1 with APEX listener 2.0 EA2
          685473
          Hmmm, I can't reproduce it any more after I reconfigured the APEX listener again.
          Please ignore this thread.

          Regards,

          Mathieu
          • 2. Re: Bugreport: Importing issue in APEX 4.1.1 with APEX listener 2.0 EA2
            685473
            Forget my previous reply.

            I can reproduce it.

            It's due to SQL Developer when it uploads the settings of the configuration.
            I have done the following:
            1. I have setup the APEX listener manually using java -jar apex.war
            2. I created a adminlistener according the documentation
            3. Start the standalone listener
            4. Start APEX in a browser and try to import a file => works fine
            5. Go to SQL Developer (on a clientmachine), create a listener, connect to the standalone listener
            6. Download the settings of the configuration of the listener in SQL Developer
            7. Change the database connection from localhost to the ip-address of the application server
            8. Test the settings => OK
            9. Upload the settings of the configuration
            10. Start APEX in a browser and try to import a file => Internal Error

            SQL Developer will add some extra entry key elements in the default.xml
            The entry key element *<entry key="icap.port"/>* is giving the error.
            When you comment this element out, APEX will be able to import files.

            Hopefully this will be solved in the production version of the APEX listener 2.0

            Regards,

            Mathieu Meeuwissen
            • 3. Re: Bugreport: Importing issue in APEX 4.1.1 with APEX listener 2.0 EA2
              Liz Saunders-Oracle
              This is already fixed in SQL Developer 3.2.2 which checks if the ICAP Port or ICAP Server is missing. You are using SQL Developer 3.2.1 (sqldev.version=3.2.10.09.57). Use SQL Devleoper 3.2.2 for APEX Listener 2.0 EA2.

              Regards,
              Liz Saunders

              Edited by: Liz Saunders on Nov 15, 2012 4:55 PM
              • 4. Re: Bugreport: Importing issue in APEX 4.1.1 with APEX listener 2.0 EA2
                MartinJ
                I am using the latest available SqlDeveloper 3.2.2 with the latest available Listener v2 and the icap issue very much still exists.

                Just thought I would mention this as both icap port and icap server entries were put in place via sqldeveloper with no associated value and led to the same import issue mentioned above.
                • 5. Re: Bugreport: Importing issue in APEX 4.1.1 with APEX listener 2.0 EA2
                  Nattu
                  Hi,

                  I got the same issue but after going thro this thread understood the cause for the issue. (I am using Apex 4.2.1 with apex listener 2.0 on Oracle 11g XE).

                  I manually removed the below from the defaults.xml file in the apex listener configuration directory
                  <entry key="icap.port"/>
                  <entry key="icap.server"/>
                  Now it allows to import an application to my workspace. I also understand that it is not an issue with file import but an issue with the file upload control. Thank you all here for me to understand the issue and resolve.

                  I also want to know what for the icap.port and icap.server values set and removing the them from the configuration would cause any other negative impact.

                  Thanks in advance.

                  Natarajan

                  Edited by: Nattu on Jan 10, 2013 8:31 AM