Lost connection with MySQL

1
0
-1

Hi
I've strange problem.

My Production Bonita Portal works good. There are 5 processes and 100 intancess.

After some time (few hours after restart server) there is o lot errors (in yellow notes), but Portal is still working.
After short time Portal stops.

Please help, it's production so I must often restart server.

Here is log:

root@hds105:/opt/bos/logs# tail -1000 bonita.2013-11-20.log
at org.bonitasoft.console.server.datastore.bpm.cases.ArchivedCaseDatastore.runSearch(ArchivedCaseDatastore.java:104)
at org.bonitasoft.console.server.datastore.bpm.cases.ArchivedCaseDatastore.search(ArchivedCaseDatastore.java:77)
at org.bonitasoft.console.server.api.bpm.cases.APIArchivedCase.search(APIArchivedCase.java:66)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy27.searchArchivedProcessInstancesInvolvingUser(Unknown Source)
at org.bonitasoft.console.server.datastore.bpm.cases.ArchivedCaseDatastore.runSearch(ArchivedCaseDatastore.java:93)
... 26 more
Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
... 28 more
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)
... 32 more
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)
... 34 more
Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
... 46 more
Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032C9F7D000093F0 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032C9F7D000093F1], error=!invalid error code (0)!
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
... 59 more
Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)
at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)
... 61 more

Nov 20, 2013 12:17:21 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions
SEVERE: Error when searching process user can start
org.bonitasoft.web.toolkit.client.common.exception.api.APIException: Error when searching process user can start
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:168)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.bonitasoft.engine.exception.SearchException: Error while retrieving process definitions: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not execute query
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3649)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
at ══════════════════════════.()
at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:678)
at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
at .Caused By:(org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not execute query)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:650)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)
at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)
at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
at .Caused By:(org.hibernate.exception.GenericJDBCException: could not execute query)
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)
at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)
at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
at .Caused By:(could not execute query)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy24.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)
at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)
at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
at .Caused By:(error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4)
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy24.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)
at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)
at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
at .Caused By:(cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032CA48500009405 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000032CA48500009407], error=!invalid error code (0)!)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)
at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy24.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:638)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)
at org.bonitasoft.engine.core.process.definition.ProcessDefinitionServiceImpl.getNumberOfProcessDeploymentInfos(ProcessDefinitionServiceImpl.java:675)
at org.bonitasoft.engine.search.process.SearchProcessDeploymentInfosUserCanStart.executeCount(SearchProcessDeploymentInfosUserCanStart.java:44)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:84)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
at org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchProcessDeploymentInfos(ProcessAPIImpl.java:3647)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:192)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
at .Caused By:(No operations allowed after connection closed.)

Nov 20, 2013 12:34:42 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions
SEVERE: null
java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy23.getProfilesForUser(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProfileEngineClient.listProfilesForUser(ProfileEngineClient.java:73)
at org.bonitasoft.console.server.datastore.profile.SearchProfilesHelper.searchProfilesForUser(SearchProfilesHelper.java:64)
at org.bonitasoft.console.server.datastore.profile.SearchProfilesHelper.search(SearchProfilesHelper.java:47)
at org.bonitasoft.console.server.datastore.ComposedDatastore.search(ComposedDatastore.java:66)
at org.bonitasoft.web.toolkit.server.API.search(API.java:277)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
... 30 more
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)
... 34 more
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)
... 36 more
Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
... 48 more
Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86BD00009475 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86BD00009476], error=!invalid error code (0)!
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
... 61 more
Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)
at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)
... 63 more

Nov 20, 2013 12:34:42 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions
SEVERE: java.lang.reflect.UndeclaredThrowableException
org.bonitasoft.web.toolkit.client.common.exception.api.APIException: java.lang.reflect.UndeclaredThrowableException
at org.bonitasoft.console.server.datastore.organization.UserDatastore.get(UserDatastore.java:133)
at org.bonitasoft.console.server.api.organization.APIUser.get(APIUser.java:113)
at org.bonitasoft.console.server.api.organization.APIUser.get(APIUser.java:44)
at org.bonitasoft.web.toolkit.server.API.runGet(API.java:216)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:158)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy26.getUser(Unknown Source)
at org.bonitasoft.console.server.datastore.organization.UserDatastore.get(UserDatastore.java:125)
... 26 more
Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
... 28 more
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)
... 32 more
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)
... 34 more
Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
... 46 more
Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86C800009477 : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C86C900009478], error=!invalid error code (0)!
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
... 59 more
Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)
at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)
... 61 more

Nov 20, 2013 12:34:48 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions
SEVERE: java.lang.reflect.UndeclaredThrowableException
org.bonitasoft.web.toolkit.client.common.exception.api.APIException: java.lang.reflect.UndeclaredThrowableException
at org.bonitasoft.console.server.datastore.bpm.cases.CommentDatastore.runCustomSearch(CommentDatastore.java:183)
at org.bonitasoft.console.server.datastore.bpm.cases.CommentDatastore.search(CommentDatastore.java:114)
at org.bonitasoft.console.server.api.bpm.cases.APIComment.search(APIComment.java:62)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy27.searchComments(Unknown Source)
at org.bonitasoft.console.server.datastore.bpm.cases.CommentDatastore.runCustomSearch(CommentDatastore.java:179)
... 26 more
Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
... 28 more
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)
... 32 more
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)
... 34 more
Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
... 46 more
Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C9C120000948F : 626F6E6974612D746F6D6361742D62746D2D6E6F64653000000000033C9C1200009490], error=!invalid error code (0)!
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
... 59 more
Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)
at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)
... 61 more

Nov 20, 2013 12:51:00 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: Unexpected error while executing work
java.lang.NullPointerException
at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.(SProcessInstanceReadException.java:29)
at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)
at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)
at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)
at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)
at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

Nov 20, 2013 2:28:37 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: Unexpected error while executing work
java.lang.NullPointerException
at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.(SProcessInstanceReadException.java:29)
at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)
at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)
at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)
at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)
at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

Nov 20, 2013 2:30:37 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: Unexpected error while executing work
java.lang.NullPointerException
at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.(SProcessInstanceReadException.java:29)
at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)
at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)
at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)
at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)
at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

Nov 20, 2013 2:31:50 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: Unexpected error while executing work
java.lang.NullPointerException
at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.(SProcessInstanceReadException.java:29)
at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)
at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)
at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)
at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)
at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

Nov 20, 2013 3:35:39 PM org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: Unexpected error while executing work
java.lang.NullPointerException
at org.bonitasoft.engine.core.process.instance.api.exceptions.SProcessInstanceReadException.(SProcessInstanceReadException.java:29)
at org.bonitasoft.engine.core.process.instance.impl.ProcessInstanceServiceImpl.getProcessInstance(ProcessInstanceServiceImpl.java:249)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.childReachedState(ProcessExecutorImpl.java:814)
at org.bonitasoft.engine.execution.ContainerRegistry.nodeReachedState(ContainerRegistry.java:58)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.notifyParentStateIsFinished(FlowNodeExecutorImpl.java:306)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.stepForward(FlowNodeExecutorImpl.java:280)
at org.bonitasoft.engine.execution.FlowNodeExecutorImpl.gotoNextStableState(FlowNodeExecutorImpl.java:364)
at org.bonitasoft.engine.execution.ProcessExecutorImpl.executeFlowNode(ProcessExecutorImpl.java:266)
at org.bonitasoft.engine.execution.work.ExecuteFlowNodeWork.work(ExecuteFlowNodeWork.java:50)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:48)
at org.bonitasoft.engine.work.SequenceRunnableExecutor.innerRun(SequenceRunnableExecutor.java:37)
at org.bonitasoft.engine.work.NotifyingRunnable.run(NotifyingRunnable.java:36)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

Nov 20, 2013 3:47:17 PM org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet catchAllExceptions
SEVERE: null
java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy27.searchProcessDeploymentInfos(Unknown Source)
at org.bonitasoft.console.server.engineclient.ProcessEngineClient.searchProcessDeploymentInfos(ProcessEngineClient.java:166)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.runSearch(SearchProcessHelper.java:63)
at org.bonitasoft.console.server.datastore.bpm.process.helper.SearchProcessHelper.search(SearchProcessHelper.java:51)
at org.bonitasoft.console.server.datastore.bpm.process.ProcessDatastore.search(ProcessDatastore.java:148)
at org.bonitasoft.console.server.api.bpm.process.APIProcess.search(APIProcess.java:128)
at org.bonitasoft.web.toolkit.server.API.runSearch(API.java:257)
at org.bonitasoft.web.toolkit.server.APIServletCall.doGet(APIServletCall.java:169)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doGet(ToolkitHttpServlet.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:225)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.FilterManager.pageRedirect(FilterManager.java:88)
at org.bonitasoft.console.common.server.login.filter.FilterManager.doFilter(FilterManager.java:68)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.bonitasoft.engine.platform.STenantNotFoundException: Unable to get the tenant: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:423)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkTenantSession(ServerAPIImpl.java:220)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.beforeInvokeMethod(ServerAPIImpl.java:126)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:77)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
... 30 more
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:378)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:355)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getTenant(PlatformServiceImpl.java:418)
... 34 more
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [org.bonitasoft.engine.platform.model.impl.STenantImpl#1]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectById(AbstractHibernatePersistenceService.java:370)
... 36 more
Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/bonitaDSXA in state ACCESSIBLE with usage count 1 wrapping com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 on com.mysql.jdbc.jdbc2.optional.JDBC4ConnectionWrapper@4fe551c4
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:87)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:242)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy1.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
... 48 more
Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/bonitaDSXA XAResource=com.mysql.jdbc.jdbc2.optional.JDBC4MysqlXAConnection@23c79d80 with XID a Bitronix XID [626F6E6974612D746F6D6361742D62746D2D6E6F6465300000000003ECD7A100009666 : 626F6E6974612D746F6D6361742D62746D2D6E6F6465300000000003ECD7A100009667], error=!invalid error code (0)!
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:139)
at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:69)
at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:85)
... 61 more
Caused by: com.mysql.jdbc.jdbc2.optional.MysqlXAException: No operations allowed after connection closed.
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:604)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:583)
at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:523)
at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:220)
at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:111)
at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:130)
... 63 more

Comments

Submitted by jainmayank33 on Fri, 08/05/2016 - 04:41

Hi decyzjoner,

I understand this thread became very old. Can you please brief me how did you solve this problem?

Appreciate your help!

Thanks,
Mayank

2 answers

1
0
-1

Hello,

I assume that you use Tomcat (it's good to specify it in your initial post ;)). It seems that you need to explicitly test the connection in your datasource settings since it times out. Most probably something like resource.ds1.testQuery=SELECT 1 in your bitronix settings file would do the trick.

Hope this helps,

Haris

1
0
-1

with that code you extract data from your database? I wanted to know if you can help me with that because they already tried everything and I can not extract data from my database please help me. Can you tell me which code you used please?

Notifications