7 Replies Latest reply: Nov 6, 2012 10:02 AM by Mehabub Sheikh RSS

    Glasshfish Server Open Source Edition /apex/listenerAdmin not showing

    Mehabub Sheikh
      I'm setting up a laptop to use APEX and I'm having issues at utilising
      http://localhost:8080/apex/listenerAdmin

      I'm using:
      Oracle 11gR2
      Apex 4.2
      Windows XP Professional 32 bit
      Glassfish3 Open Source Edition

      I deployed the 1.1.4 war

      Now when I attempt the listenerConfigure or listenerAdmin address it takes me to the page where I set up the database connection. However the logo is missing and the tabs aren't painted with css.

      When I attempt to apply the profile regardless, it navigates to a blank page with no confirmation - but now listenerConfigure announces in plain text that it's already configured.

      listenerAdmin can't find it's supporting files.
      For instance, the logo url is
      http://localhost:8080/apex/scripts/images/oracle_logo.gif

      Am I missing anything?

      Thanks,
      Mehabub
        • 1. Re: Glasshfish Server Open Source Edition /apex/listenerAdmin not showing
          Mehabub Sheikh
          Following is the log messages from server.log file

          [#|2012-11-06T11:49:27.906+0530|WARNING|glassfish3.1.2|javax.enterprise.system.container.web.com.sun.enterprise.web|_ThreadID=20;_ThreadName=Thread-2;|StandardWrapperValve[HttpEndPoint]: PWC1406: Servlet.service() for servlet HttpEndPoint threw exception
          oracle.dbtools.rt.service.ServiceLocatorException: Exception occurred in activate() method
               at oracle.dbtools.rt.service.Provider.activate(Provider.java:56)
               at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
               at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
               at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:125)
               at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:102)
               at oracle.dbtools.rt.service.Provider.inject(Provider.java:137)
               at oracle.dbtools.rt.service.Provider.activate(Provider.java:39)
               at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
               at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
               at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:125)
               at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:102)
               at oracle.dbtools.rt.service.Provider.inject(Provider.java:137)
               at oracle.dbtools.rt.service.Provider.activate(Provider.java:39)
               at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
               at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
               at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:125)
               at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:132)
               at oracle.dbtools.rt.web.RequestDispatchers.choose(RequestDispatchers.java:85)
               at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:52)
               at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:94)
               at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
               at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
               at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:281)
               at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
               at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
               at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
               at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
               at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)
               at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
               at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
               at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
               at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
               at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
               at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
               at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
               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)
          Caused by: com.sleepycat.je.EnvironmentFailureException: (JE 4.0.103) java.lang.ClassNotFoundException: oracle.dbtools.rt.resource.templates.DeleteTableName UNEXPECTED_EXCEPTION: Unexpected internal Exception, may have side effects.
               at com.sleepycat.je.EnvironmentFailureException.unexpectedException(EnvironmentFailureException.java:286)
               at com.sleepycat.compat.DbCompat.unexpectedException(DbCompat.java:500)
               at com.sleepycat.persist.impl.PersistCatalog.readData(PersistCatalog.java:1108)
               at com.sleepycat.persist.impl.PersistCatalog.init(PersistCatalog.java:255)
               at com.sleepycat.persist.impl.PersistCatalog.<init>(PersistCatalog.java:221)
               at com.sleepycat.persist.impl.Store.<init>(Store.java:186)
               at com.sleepycat.persist.EntityStore.<init>(EntityStore.java:185)
               at oracle.dbtools.rt.home.DataStore.activate(DataStore.java:64)
               at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:597)
               at oracle.dbtools.rt.service.__Reflections.invoke(__Reflections.java:85)
               at oracle.dbtools.rt.service.Provider.activate(Provider.java:43)
               ... 44 more
          Caused by: java.lang.ClassNotFoundException: oracle.dbtools.rt.resource.templates.DeleteTableName
               at org.glassfish.web.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1509)
               at org.glassfish.web.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1359)
               at java.lang.Class.forName0(Native Method)
               at java.lang.Class.forName(Class.java:247)
               at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:603)
               at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1574)
               at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
               at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1731)
               at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
               at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
               at java.util.HashMap.readObject(HashMap.java:1030)
               at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:597)
               at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:969)
               at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1848)
               at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
               at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
               at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
               at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
               at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
               at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
               at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1946)
               at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1870)
               at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1752)
               at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
               at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
               at com.sleepycat.persist.impl.PersistCatalog.readData(PersistCatalog.java:1093)
               ... 54 more
          |#]
          • 2. Re: Glasshfish Server Open Source Edition /apex/listenerAdmin not showing
            Udo
            Hi,

            which Java (JDK) version does your GlassFish use?
            Is your database installed on the same machine with your database? Did you disable the database internal web server or move it to a different port? The default port used by this component would be 8080 as well, so possibly you have a port conflict there.
            When I attempt to apply the profile regardless, it navigates to a blank page with no confirmation - but now listenerConfigure announces in plain text that it's already configured.
            This means the configuration has succeeded. The blank page indicates that you haven't copied the static contents ("images") to your GlassFish yet - or it can't be accessed due to the same issue that also blocks the scripts and stuff for APEX Listener itself.

            -Udo
            • 3. Re: Glasshfish Server Open Source Edition /apex/listenerAdmin not showing
              Mehabub Sheikh
              which Java (JDK) version does your GlassFish use?
              Is your database installed on the same machine with your database? Did you disable the database internal web server or move it to a different port? The default port used by this component would be 8080 as well, so possibly you have a port conflict there.
              How will I know which version of java it is using? When I configured my domain I changed asenv.bat file and included Java SDK 6 with an entry of set AS_JAVA=C:\java6\jdk and then used command line prompt to configure domain. I am able to login in admin console and if I type http://localhost:8080/ it is displaying Your server is now running
              My database is installed on the same m/c where glassfish has been installed. Yes I disabled the internal port used by EPG.

              Please help.

              Thanks,
              Mehabub
              • 4. Re: Glasshfish Server Open Source Edition /apex/listenerAdmin not showing
                Mehabub Sheikh
                Hi Udo,

                After chaning the path variable to point to correct JDK version 1.6.0_33 I am getting the following error in glassfish server log
                [#|2012-11-06T17:58:25.593+0530|WARNING|glassfish3.1.2|javax.enterprise.system.container.web.com.sun.enterprise.web|_ThreadID=21;_ThreadName=Thread-2;|StandardWrapperValve[HttpEndPoint]: PWC1406: Servlet.service() for servlet HttpEndPoint threw exception
                oracle.dbtools.rt.service.ServiceLocatorException: Exception occurred in activate() method
                     at oracle.dbtools.rt.service.Provider.activate(Provider.java:56)
                     at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
                     at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
                     at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:125)
                     at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:102)
                     at oracle.dbtools.rt.service.Provider.inject(Provider.java:137)
                     at oracle.dbtools.rt.service.Provider.activate(Provider.java:39)
                     at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
                     at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
                     at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:125)
                     at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:102)
                     at oracle.dbtools.rt.service.Provider.inject(Provider.java:137)
                     at oracle.dbtools.rt.service.Provider.activate(Provider.java:39)
                     at oracle.dbtools.rt.service.Provider.match(Provider.java:111)
                     at oracle.dbtools.rt.service.Providers.match(Providers.java:22)
                     at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:125)
                     at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:132)
                     at oracle.dbtools.rt.web.RequestDispatchers.choose(RequestDispatchers.java:85)
                     at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:52)
                     at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:94)
                     at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
                     at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
                     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:281)
                     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
                     at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
                     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
                     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
                     at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)
                     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
                     at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
                     at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
                     at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
                     at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
                     at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
                     at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
                     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)
                Caused by: com.sleepycat.je.EnvironmentLockedException: (JE 4.0.103) C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\apex\bdb The environment cannot be locked for single writer access. ENV_LOCKED: The je.lck file could not be locked. Environment is invalid and must be closed.
                     at com.sleepycat.je.log.FileManager.<init>(FileManager.java:350)
                     at com.sleepycat.je.dbi.EnvironmentImpl.<init>(EnvironmentImpl.java:439)
                     at com.sleepycat.je.dbi.EnvironmentImpl.<init>(EnvironmentImpl.java:341)
                     at com.sleepycat.je.dbi.DbEnvPool.getEnvironment(DbEnvPool.java:181)
                     at com.sleepycat.je.Environment.makeEnvironmentImpl(Environment.java:229)
                     at com.sleepycat.je.Environment.<init>(Environment.java:211)
                     at com.sleepycat.je.Environment.<init>(Environment.java:165)
                     at oracle.dbtools.rt.home.DataStore.activate(DataStore.java:56)
                     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                     at java.lang.reflect.Method.invoke(Method.java:597)
                     at oracle.dbtools.rt.service.__Reflections.invoke(__Reflections.java:85)
                     at oracle.dbtools.rt.service.Provider.activate(Provider.java:43)
                     ... 44 more

                Any Idea??

                Thanks,
                Mehabub
                • 5. Re: Glasshfish Server Open Source Edition /apex/listenerAdmin not showing
                  Udo
                  Caused by: com.sleepycat.je.EnvironmentLockedException: (JE 4.0.103) C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\apex\bdb The environment cannot be locked for single writer access. ENV_LOCKED: The je.lck file could not be locked. Environment is invalid and must be closed.
                  Sounds like the last run really crashed. If you didn't configure any Ressource Templates yet, you may delete the whole bdb directory and restart your APEX Listener deployment (or the whole GlassFish domain, if you don't care).

                  -Udo
                  • 6. Re: Glasshfish Server Open Source Edition /apex/listenerAdmin not showing
                    Prabodh
                    Hi,
                    Caused by: com.sleepycat.je.EnvironmentLockedException: (JE 4.0.103) C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\apex\bdb The environment cannot be locked for single writer access. ENV_LOCKED: The je.lck file could not be locked. Environment is invalid and must be closed.
                    It appears that you have not pinned your apex-config.xml to a directory other than the default, which is temp.
                    See Appendix A About the configuration file -> Locating the configuration file.

                    Once you have edited and saved the web.xml as referred to in the above documentation do the following
                    a. Stop the GF domain
                    b. Search for apex-conf.xml files under your c:\Documents and setting\ folder tree and delete all occurrences of this file
                    c. start your GF doman for Apex
                    d. Got apex/listenerConfigure and configure your listener again.

                    I presume you have copied the apex/images folder to domain/docroot/i folder as described in the above document already(section Copy Oracle Application Express Images). If not, do it before step c above.

                    Cheer,
                    • 7. Re: Glasshfish Server Open Source Edition /apex/listenerAdmin not showing
                      Mehabub Sheikh
                      Hi Prabodh,

                      After stopping the domain I deleted the the folder apex from temp and then restarted domain. Everything looks great now.
                      Thank you very much for the information.

                      Thanks,
                      Mehabub