6 Replies Latest reply: Jan 15, 2013 8:16 AM by Colm Divilly RSS

    What does this SEVERE message mean?

    Sanjeev Chauhan
      APEX Listener 2.0.0.268.17.04
      Glassfish 3.1.2
      Apache 2.2

      I am seeing the following message in the glassfish server.log after every 1000 statements processed. Even though the first error is SEVERE, it does not appear to cause any error for the end-user. What should I look for in my configuration/application?
      [#|2012-12-12T07:36:05.482-0600|SEVERE|oracle-glassfish3.1.2|null|_ThreadID=19;_ThreadName=Thread-2;|Universal Connection Pool not found in Universal Connection Pool Manager. Register the Universal Connection Pool with Universal Connection Pool Manager
      oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool not found in Universal Connection Pool Manager. Register the Universal Connection Pool with Universal Connection Pool Manager
              at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:421)
              at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:389)
              at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:403)
              at oracle.ucp.admin.UniversalConnectionPoolManagerBase.getManagerPoolID(UniversalConnectionPoolManagerBase.java:771)
              at oracle.ucp.admin.UniversalConnectionPoolManagerBase.getConnectionPool(UniversalConnectionPoolManagerBase.java:656)
              at oracle.dbtools.apex.Connections.getCacheInfos(Connections.java:28)
              at oracle.dbtools.apex.statistics.Statistics.toString(Statistics.java:227)
              at oracle.dbtools.apex.statistics.Statistics.print(Statistics.java:162)
              at oracle.dbtools.apex.statistics.Statistics.finishRequest(Statistics.java:129)
              at oracle.dbtools.apex.ModApexContext.close(ModApexContext.java:277)
              at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:151)
              at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:145)
              at oracle.dbtools.common.util.Closeables$BaseCloser.close(Closeables.java:214)
              at oracle.dbtools.common.util.Closeables.close(Closeables.java:96)
              at oracle.dbtools.apex.ModApex.close(ModApex.java:152)
              at oracle.dbtools.apex.ModApex.doGet(ModApex.java:86)
              at oracle.dbtools.apex.ModApex.service(ModApex.java:263)
              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: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.ajp.AjpProcessorTask.invokeAdapter(AjpProcessorTask.java:130)
              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)
      |#]
      
      [#|2012-12-12T07:36:05.484-0600|INFO|oracle-glassfish3.1.2|null|_ThreadID=19;_ThreadName=Thread-2;|Current Time:        Wed Dec 12 07:36:05 CST 2012<br />
      Server Uptime:  0 Days 01:04:09.384<br />
      Total Accesses: 2000.0<br />
      Total Traffic:  13.08M<br />
      Total Errors:   0<br />
      Total File Downloads:   0<br />
      Total Processing Time:  0 Days 00:13:45.122<br />
      Processing Time in milliseconds:<br />  Minimum: 26   Average: 413   Median: 73   Maximum: 16895<br />
      Database Time in milliseconds:<br />    Minimum: 9   Average: 363   Median: 50   Maximum: 16306<br />
      Active Requests:        2<br />
      POOL BROKEN:Universal Connection Pool not found in Universal Connection Pool Manager. Register the Universal Connection Pool with Universal Connection Pool Manager<br />
      Security:<br /> Total Entries: 0   Maximum Entries Allowed: 100<br />
      Caching Files:<br />    Caching file is disabled.<br />
      |#]
        • 1. Re: What does this SEVERE message mean?
          Udo
          Hi Sanjeev,

          which APEX version do you use? If 4.1 or above: Have you configured it for RESTful services?

          -Udo
          • 2. Re: What does this SEVERE message mean?
            Sanjeev Chauhan
            I have Apex 4.2. Yes, RESTful service is configured.
            • 3. Re: What does this SEVERE message mean?
              Damir Vadas
              Hi
              I have the same problem. Problem is that page is blank and freezed. After another enter in URL page is shown normally.
              What I find out is that that "Freeze" mostly happened in Apex design time ... never in runtime of any of mine app.

              Mine conf:
              Apex 4.2.1 on
              Apex Listener standalone 2.0.0.354.17.06
              Oracle 11.2.03 x64
              Windows 2008 SE R2 x64

              C:\Users\DamirV>java -version
              java version "1.6.0_34"
              Java(TM) SE Runtime Environment (build 1.6.0_34-b04)
              Java HotSpot(TM) 64-Bit Server VM (build 20.9-b04, mixed mode)

              C:\Users\DamirV>
              D:\Users\damirv\Desktop\Apex\Apex-Misc>set ORACLE_HOME=c:\oracle\product\11.2.0\dbhome_1
              
              D:\Users\damirv\Desktop\Apex\Apex-Misc>set ORACLE_SID=XE
              
              D:\Users\damirv\Desktop\Apex\Apex-Misc>set PATH=c:\Program Files\Java\jdk1.6.0_34\bin;c:\oracle\product\11.2.0\dbhome_1\bin;c:\oracle\product\11.2.0\dbhome_1\bin;d:\wintools\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0
              
              D:\Users\damirv\Desktop\Apex\Apex-Misc>set JAVA_HOME=c:\Program Files\Java\jdk1.6.0_34
              
              D:\Users\damirv\Desktop\Apex\Apex-Misc>java -Dapex.home=c:\oracle\product\apex -Dapex.images=c:\oracle\product\11.2.0\dbhome_1\apex\images\
              -Dapex.port=8080 -Dapex.erase -jar c:\oracle\product\apex\apex.war
              13.01.2013. 16:50:13 oracle.dbtools.standalone.Standalone execute
              INFO: NOTE:
              
              Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.
              
              13.01.2013. 16:50:13 oracle.dbtools.standalone.Standalone execute
              INFO: Starting standalone Web Container in:  c:\oracle\product\apex
              13.01.2013. 16:50:13 oracle.dbtools.standalone.Deployer deploy
              INFO: Will deploy application path = c:\oracle\product\apex\apex\WEB-INF\web.xml
              13.01.2013. 16:50:14 oracle.dbtools.standalone.Deployer deploy
              INFO: Deployed application path = c:\oracle\product\apex\apex\WEB-INF\web.xml
              13.01.2013. 16:50:14 oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
              INFO: Using configuration folder: C:\oracle\product\apex
              Configuration properties for: apex
              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.hostname=pcdamir
              db.password=******
              db.port=1521
              db.sid=xe
              debug.debugger=false
              debug.printDebugToScreen=false
              error.keepErrorMessages=true
              error.maxEntries=50
              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
              misc.compress=
              misc.defaultPage=apex
              security.disableDefaultExclusionList=false
              security.maxEntries=2000
              db.username=APEX_PUBLIC_USER
              Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0
              13.01.2013. 16:50:15 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: Grizzly/1.9.49
              
              13.01.2013. 16:50:15 com.sun.grizzly.Controller logVersion
              INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 13.01.13. 16:50
              13.01.2013. 16:50:15 oracle.dbtools.standalone.Standalone execute
              INFO: http://localhost:8080/apex started.
              Configuration properties for: apex_al
              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.hostname=pcdamir
              db.password=******
              db.port=1521
              db.sid=xe
              debug.debugger=false
              debug.printDebugToScreen=false
              error.keepErrorMessages=true
              error.maxEntries=50
              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
              misc.compress=
              misc.defaultPage=apex
              security.disableDefaultExclusionList=false
              security.maxEntries=2000
              db.username=APEX_LISTENER
              Returning:oracle.dbtools.common.util.Closeables$1@31b6956f
              Returning:oracle.dbtools.common.util.Closeables$1@5673cc11
              Returning:oracle.dbtools.common.util.Closeables$1@655d7752
              Returning:oracle.dbtools.common.util.Closeables$1@6040f3c1
              Returning:oracle.dbtools.common.util.Closeables$1@3afa43e8
              Returning:oracle.dbtools.common.util.Closeables$1@6f3f903b
              Returning:oracle.dbtools.common.util.Closeables$1@586dd8f1
              Returning:oracle.dbtools.common.util.Closeables$1@564a5320
              Returning:oracle.dbtools.common.util.Closeables$1@64e7b3cf
              Returning:oracle.dbtools.common.util.Closeables$1@406d06b0
              Returning:oracle.dbtools.common.util.Closeables$1@596b753
              Returning:oracle.dbtools.common.util.Closeables$1@749cd006
              Returning:oracle.dbtools.common.util.Closeables$1@4821e115
              Returning:oracle.dbtools.common.util.Closeables$1@7f1f91ac
              Returning:oracle.dbtools.common.util.Closeables$1@5ac524dd
              Returning:oracle.dbtools.common.util.Closeables$1@5c9aa764
              Returning:oracle.dbtools.common.util.Closeables$1@66f34a08
              Returning:oracle.dbtools.common.util.Closeables$1@57cae5b7
              Returning:oracle.dbtools.common.util.Closeables$1@498b5a73
              Returning:oracle.dbtools.common.util.Closeables$1@4d885088
              Returning:oracle.dbtools.common.util.Closeables$1@338bd37a
              Returning:oracle.dbtools.common.util.Closeables$1@53d9f80
              Returning:oracle.dbtools.common.util.Closeables$1@6a4d37e5
              Returning:oracle.dbtools.common.util.Closeables$1@440d8355
              Edited by: Damir Vadas on Jan 13, 2013 5:33 PM
              • 4. Re: What does this SEVERE message mean?
                Colm Divilly
                You can ignore this message, firstly it should not have been logged at SEVERE level, secondly it's occurring because it is assuming you always have a pool name 'apex', which it would seem you do not in your particular environment.

                These issues will be addressed in the next scheduled release of Listener, thanks for reporting the issue.

                Colm
                • 5. Re: What does this SEVERE message mean?
                  Damir Vadas
                  I do not know if you read mine post, but this happened in Apex development app when post get freezed. Another enter or refresh show page as espected.
                  So I cannot ignore this because is in the core point and error of Apex development app with Apex listener.
                  :-)
                  This was never shown on any of mine Apex app.

                  Edited by: Damir Vadas on Jan 14, 2013 6:54 PM
                  • 6. Re: What does this SEVERE message mean?
                    Colm Divilly
                    My reply was to the OP, unless I'm mistaken, your issue does not seem to be related the original OP's (an error being reported during the statistical reporting, on every 1000th request), probably best if you start a new thread for your issue.