This discussion is archived
5 Replies Latest reply: Jan 10, 2013 8:32 AM by Nattu RSS

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

685473 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    780195 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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