No ManagedConnections Available!

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

No ManagedConnections Available!

Mamdouh Kaadan-2
Dear all

 

I'm getting the below error every 2 days, and the only solution is to
restart OFBiz, can anyone help me please

 

Kind regards

 

125244604[GeronimoTransactionFactory.java:97 :ERROR]

---- runtime exception report
--------------------------------------------------

Geronimo is the configured transaction manager but there was an error
getting a database Connection through Geronimo for the crmoracle
datasource. Please check your configuration, class path, etc.

Exception: java.lang.RuntimeException

Message: No ManagedConnections Available!

---- stack trace
---------------------------------------------------------------

java.lang.RuntimeException: No ManagedConnections Available!

org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:655)

org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolData
Source.java:355)

org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(Mine
rvaConnectionFactory.java:56)

org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTran
sactionFactory.java:94)

org.ofbiz.entity.transaction.TransactionFactory.getConnection(Transactio
nFactory.java:104)

org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.
java:82)

org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:268)

org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:37
4)

org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:35
8)

org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:539)

org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:510)

org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHel
perDAO.java:90)

org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java
:1248)

org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java
:1304)

org.ofbiz.minilang.method.entityops.FindByPrimaryKey.exec(FindByPrimaryK
ey.java:91)

org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:920)

org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:560)

org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:107)

org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:89)

org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngin
e.java:77)

org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:
52)

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:338)

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:212)

org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:114)

org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.ja
va:292)

org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:407
)

org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:24
3)

org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:183)

org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:79)

javax.servlet.http.HttpServlet.service(HttpServlet.java:615)

javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)

org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:249)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)

org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541
)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)

java.lang.Thread.run(Thread.java:534)

 

Reply | Threaded
Open this post in threaded view
|

RE: No ManagedConnections Available!

Mamdouh Kaadan-2
I found where the problem is, I forget to change the default value(20)
of pool-maxsize in inline-jdbc in entityengine.xml

 

Kind regards

 

==================================

Mamdouh Kaadan

Software Engineer

IT - Application

Areeba SYRIA

Mobile: +963-94-222763

Office :  +963-94-222222   Ext: 2288

E-mail:[hidden email]

 

 

________________________________

From: Mamdouh Kaadan
Sent: Wednesday, October 11, 2006 11:47 PM
To: [hidden email]
Subject: No ManagedConnections Available!

 

Dear all

 

I'm getting the below error every 2 days, and the only solution is to
restart OFBiz, can anyone help me please

 

Kind regards

 

125244604[GeronimoTransactionFactory.java:97 :ERROR]

---- runtime exception report
--------------------------------------------------

Geronimo is the configured transaction manager but there was an error
getting a database Connection through Geronimo for the crmoracle
datasource. Please check your configuration, class path, etc.

Exception: java.lang.RuntimeException

Message: No ManagedConnections Available!

---- stack trace
---------------------------------------------------------------

java.lang.RuntimeException: No ManagedConnections Available!

org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:655)

org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolData
Source.java:355)

org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(Mine
rvaConnectionFactory.java:56)

org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTran
sactionFactory.java:94)

org.ofbiz.entity.transaction.TransactionFactory.getConnection(Transactio
nFactory.java:104)

org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.
java:82)

org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:268)

org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:37
4)

org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:35
8)

org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:539)

org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:510)

org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHel
perDAO.java:90)

org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java
:1248)

org.ofbiz.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java
:1304)

org.ofbiz.minilang.method.entityops.FindByPrimaryKey.exec(FindByPrimaryK
ey.java:91)

org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:920)

org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:560)

org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:107)

org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:89)

org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngin
e.java:77)

org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:
52)

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:338)

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:212)

org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:114)

org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.ja
va:292)

org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:407
)

org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:24
3)

org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:183)

org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:79)

javax.servlet.http.HttpServlet.service(HttpServlet.java:615)

javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)

org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:249)

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)

org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541
)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)

java.lang.Thread.run(Thread.java:534)