3 Replies Latest reply on Nov 3, 2011 4:26 PM by korsa-fox

Could not create connection error is thrown in JBPM Console

rajeshchikhale Mar 17, 2011 2:49 AM

Hi,

When navigationg through process overview tab in JBPM console an below error is thrown

2011-03-15 15:37:43,781 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-localhost%2F127.0.0.1-8080-3) Unable to get managed connection for jdbc/testDS1; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/testDS1)

H2 database is started correctly as per the build script execution.Please could you let me know what might be the issue,below is the error log

Please find below logs

2011-03-15 15:37:41,156 ERROR [org.hibernate.ejb.AbstractEntityManagerImpl] (http-localhost%2F127.0.0.1-8080-3) Unable to mark for rollback on PersistenceException:

java.lang.IllegalStateException: [com.arjuna.ats.internal.jta.transaction.arjunacore.nosuchtx] [com.arjuna.ats.internal.jta.transaction.arjunacore.nosuchtx] No such transaction!

at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.setRollbackOnly(BaseTransaction.java:191)

at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.setRollbackOnly(BaseTransactionManagerDelegate.java:123)

at org.hibernate.ejb.AbstractEntityManagerImpl.markAsRollback(AbstractEntityManagerImpl.java:421)

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:576)

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:202)

at org.drools.persistence.jpa.JpaPersistenceContext.findSessionInfo(JpaPersistenceContext.java:21)

at org.drools.persistence.SingleSessionCommandService.initKsession(SingleSessionCommandService.java:176)

at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:160)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:88)

at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:71)

at org.drools.persistence.jpa.JPAKnowledgeService.loadStatefulKnowledgeSession(JPAKnowledgeService.java:118)

at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:133)

at org.jbpm.integration.console.CommandDelegate.getSession(CommandDelegate.java:185)

at org.jbpm.integration.console.CommandDelegate.<init>(CommandDelegate.java:69)

at org.jbpm.integration.console.ProcessManagement.<init>(ProcessManagement.java:35)

at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:22)

at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:19)

at org.jboss.bpm.console.server.ProcessMgmtFacade.getProcessManagement(ProcessMgmtFacade.java:98)

at org.jboss.bpm.console.server.ProcessMgmtFacade.getDefinitionsJSON(ProcessMgmtFacade.java:122)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)

at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)

at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)

at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)

at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)

at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)

at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)

at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)

at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)

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

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

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

at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

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

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

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

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

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

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

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

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

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

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

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

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

at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

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

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

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

at java.lang.Thread.run(Thread.java:595)

2011-03-15 15:37:41,171 INFO [STDOUT] (http-localhost%2F127.0.0.1-8080-3) Error loading session data: java.lang.reflect.InvocationTargetException

2011-03-15 15:37:41,171 INFO [STDOUT] (http-localhost%2F127.0.0.1-8080-3) Creating new session data ...

2011-03-15 15:37:43,734 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (http-localhost%2F127.0.0.1-8080-3) Throwable while attempting to get a new connection: null

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0" [50000-124]

at org.h2.message.Message.getSQLException(Message.java:111)

at org.h2.message.Message.convert(Message.java:288)

at org.h2.engine.Database.openDatabase(Database.java:261)

at org.h2.engine.Database.<init>(Database.java:221)

at org.h2.engine.Engine.openSession(Engine.java:58)

at org.h2.engine.Engine.openSession(Engine.java:142)

at org.h2.engine.Engine.getSession(Engine.java:122)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:122)

at java.lang.Thread.run(Thread.java:595)

Caused by: java.lang.RuntimeException: page[13] data leaf table:0 entries:9 parent:16 keys:[6681, 6683, 6685, 6687, 6689, 6691, 6693, 6695, 6697] offsets:[1936, 1477, 1389, 1258, 1146, 796, 724, 609, 497] parent 16 expected 0

at org.h2.message.Message.throwInternalError(Message.java:191)

at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:220)

at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:74)

at org.h2.table.TableData.<init>(TableData.java:83)

at org.h2.store.PageStore.addMeta(PageStore.java:1304)

at org.h2.store.PageStore.redo(PageStore.java:1185)

at org.h2.store.PageLog.recover(PageLog.java:285)

at org.h2.store.PageStore.recover(PageStore.java:1051)

at org.h2.store.PageStore.openExisting(PageStore.java:310)

at org.h2.store.PageStore.open(PageStore.java:268)

at org.h2.engine.Database.getPageStore(Database.java:2305)

at org.h2.engine.Database.open(Database.java:624)

at org.h2.engine.Database.openDatabase(Database.java:227)

... 6 more

)

at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)

at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)

at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)

at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)

at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:679)

at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)

at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)

at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)

at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)

at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)

at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)

at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:54)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)

at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)

at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)

at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)

at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)

at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)

at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154)

at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110)

at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61)

at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:645)

at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:619)

at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:623)

at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:220)

at org.drools.persistence.jpa.JpaPersistenceContext.persist(JpaPersistenceContext.java:17)

at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:125)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:116)

at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:54)

at org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)

at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:145)