ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS 3.0 UCP Error

Alex_K1May 29 2015 — edited Jun 10 2015

Dear community,

I originally posted my question to but during problem analysis we found that it's probably related to ORDS 3.0.

I recently upgraded to APEX 5 & ORDS 3.0 and I am experiencing an UCP error in my log file. In my application the visible effect is, that sometimes images are not fetched from the ORDS.

29-May-2015 10:41:52.795 WARNING [http-nio-82-exec-6] oracle.dbtools.common.config.db.ConfigurationValues.log *** jdbc.MaxLimit in configuration apex_rt is using a value of 5, this setting may not be sized adequately for a production environment ***

29-May-2015 10:41:52.795 WARNING [http-nio-82-exec-6] oracle.dbtools.common.config.db.ConfigurationValues.log *** jdbc.InitialLimit in configuration apex_rt is using a value of 3, this setting may not be sized adequately for a production environment ***

29-May-2015 10:41:52.795 SEVERE [http-nio-82-exec-6] oracle.dbtools.common.config.db.DatabasePools.getPool The pool named: apex_rt is not correctly configured, error: Error during pool creation in Universal Connection Pool Manager: oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool already exists in the Universal Connection Pool Manager. Universal Connection Pool cannot be added to the Universal Connection Pool Manager

oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex_rt is not correctly configured, error: Error during pool creation in Universal Connection Pool Manager: oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool already exists in the Universal Connection Pool Manager. Universal Connection Pool cannot be added to the Universal Connection Pool Manager

at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:88)

at oracle.dbtools.common.config.db.DatabasePools.badConfiguration(DatabasePools.java:198)

at oracle.dbtools.common.config.db.DatabasePools.createPool(DatabasePools.java:273)

at oracle.dbtools.common.config.db.DatabasePools.getPool(DatabasePools.java:372)

at oracle.dbtools.common.config.db.DatabasePools.dataSource(DatabasePools.java:89)

at oracle.dbtools.common.config.db.DatabaseConfig.getPool(DatabaseConfig.java:239)

at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:60)

at oracle.dbtools.common.jdbc.ora.OraPrincipal.connection(OraPrincipal.java:69)

at oracle.dbtools.common.jdbc.BaseJDBCCallProvider.connection(BaseJDBCCallProvider.java:166)

at oracle.dbtools.common.jdbc.BaseJDBCCallProvider.transaction(BaseJDBCCallProvider.java:94)

at oracle.dbtools.rt.plsql.AnonymousBlockGenerator.generate(AnonymousBlockGenerator.java:181)

at oracle.dbtools.rt.resource.templates.v2.ResourceTemplatesDispatcher$HttpResourceGenerator.response(ResourceTemplatesDispatcher.java:311)

at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:108)

at oracle.dbtools.rt.web.ETags.checkPrecondition(ETags.java:56)

at oracle.dbtools.rt.ResourceTemplatesServlet.restfulServices(ResourceTemplatesServlet.java:192)

at oracle.dbtools.rt.ResourceTemplatesServlet.service(ResourceTemplatesServlet.java:111)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at oracle.dbtools.http.servlet.DispatchableServletBase.service(DispatchableServletBase.java:101)

at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:109)

at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:117)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:60)

at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:82)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:58)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:67)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:61)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(AuthenticationFilter.java:95)

at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:67)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.url.mapping.BasePathMapper.doFilter(BasePathMapper.java:55)

at oracle.dbtools.url.mapping.URLMapping.doFilter(URLMapping.java:78)

at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:63)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.locale.LocaleFilter.doFilter(LocaleFilter.java:60)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:71)

at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:71)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.ecid.ECIDFilter.doFilter(ECIDFilter.java:35)

at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:45)

at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:51)

at oracle.dbtools.http.filters.Filters.filter(Filters.java:46)

at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:74)

at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:46)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:166)

at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:88)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at waffle.servlet.NegotiateSecurityFilter.doFilterPrincipal(Unknown Source)

at waffle.servlet.NegotiateSecurityFilter.doFilter(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:526)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:655)

at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

Caused by: oracle.ucp.UniversalConnectionPoolException: Error during pool creation in Universal Connection Pool Manager: oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool already exists in the Universal Connection Pool Manager. Universal Connection Pool cannot be added to the Universal Connection Pool Manager

at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:359)

at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:58)

at oracle.ucp.admin.UniversalConnectionPoolManagerBase.createConnectionPool(UniversalConnectionPoolManagerBase.java:528)

at oracle.dbtools.common.config.db.DatabasePools.createPool(DatabasePools.java:265)

... 83 more

Caused by: oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool already exists in the Universal Connection Pool Manager. Universal Connection Pool cannot be added to the Universal Connection Pool Manager

at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:359)

at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:58)

at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:122)

at oracle.ucp.admin.UniversalConnectionPoolManagerBase.setConnectionPool(UniversalConnectionPoolManagerBase.java:562)

at oracle.ucp.admin.UniversalConnectionPoolManagerBase.createConnectionPool(UniversalConnectionPoolManagerBase.java:524)

... 84 more

29-May-2015 10:41:52.795 SEVERE [http-nio-82-exec-6] oracle.dbtools.http.errors.ErrorPageFilter.log WebException [statusCode=503, reasons=[The connection pool named: apex_rt is not correctly configured, due to the following error(s): Error during pool creation in Universal Connection Pool Manager: oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool already exists in the Universal Connection Pool Manager. Universal Connection Pool cannot be added to the Universal Connection Pool Manager ]]

oracle.dbtools.rt.ResourceTemplatesException: WebException [statusCode=503, reasons=[The connection pool named: apex_rt is not correctly configured, due to the following error(s): Error during pool creation in Universal Connection Pool Manager: oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool already exists in the Universal Connection Pool Manager. Universal Connection Pool cannot be added to the Universal Connection Pool Manager ]]

at oracle.dbtools.rt.ResourceTemplatesServlet.adapt(ResourceTemplatesServlet.java:123)

at oracle.dbtools.rt.ResourceTemplatesServlet.service(ResourceTemplatesServlet.java:115)