This discussion is archived
6 Replies Latest reply: Jan 15, 2013 6:16 AM by Colm Divilly RSS

What does this SEVERE message mean?

Sanjeev Chauhan Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I have Apex 4.2. Yes, RESTful service is configured.
  • 3. Re: What does this SEVERE message mean?
    Damir Vadas Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points