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) |
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) |
Free forum by Nabble | Edit this page |