Hello, When installing the latest version of BonitaSoft 10.2.0.beta-01. The system throws an ERROR error | [main|1] o.h.e.j.s.SqlExceptionHelper - Unable to enlist connection in transaction: enlistResource returns 'false'
All the steps indicated by Bonita are carried out and the following is obtained:
| ERROR | [internalTasksScheduler-1|33] o.s.s.s.TaskUtils$LoggingErrorHandler - Unexpected error occurred in scheduled task
org.bonitasoft.engine.exception.BonitaRuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
at org.bonitasoft.engine.platform.TemporaryContentScheduler.cleanOutDatedTempFiles(TemporaryContentScheduler.java:50) ~[bonita-server-10.2.0.beta-01.jar:?]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) ~[spring-context-5.3.37.jar:5.3.37]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.37.jar:5.3.37]
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) [?:?]
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) [?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
at java.base/java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1692) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.bonitasoft.engine.persistence.HibernatePersistenceService.update(HibernatePersistenceService.java:186) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.temporary.content.TemporaryContentServiceImpl.cleanOutDatedTemporaryContent(TemporaryContentServiceImpl.java:77) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:255) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.platform.TemporaryContentScheduler.cleanOutDatedTempFiles(TemporaryContentScheduler.java:45) ~[bonita-server-10.2.0.beta-01.jar:?]
... 12 more
Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:111) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:138) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:50) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:90) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:81) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:68) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:50) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.exec.DeleteExecutor.execute(DeleteExecutor.java:177) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:458) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:377) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1438) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1701) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1683) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.bonitasoft.engine.persistence.HibernatePersistenceService.update(HibernatePersistenceService.java:186) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.temporary.content.TemporaryContentServiceImpl.cleanOutDatedTemporaryContent(TemporaryContentServiceImpl.java:77) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:255) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.platform.TemporaryContentScheduler.cleanOutDatedTempFiles(TemporaryContentScheduler.java:45) ~[bonita-server-10.2.0.beta-01.jar:?]
... 12 more
Caused by: java.sql.SQLException: Unable to enlist connection in transaction: enlistResource returns 'false'.
at org.apache.tomcat.dbcp.dbcp2.managed.TransactionContext.setSharedConnection(TransactionContext.java:191) ~[tomcat-dbcp.jar:9.0.90]
at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:310) ~[tomcat-dbcp.jar:9.0.90]
at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.(ManagedConnection.java:88) ~[tomcat-dbcp.jar:9.0.90]
at org.apache.tomcat.dbcp.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:63) ~[tomcat-dbcp.jar:9.0.90]
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:713) ~[tomcat-dbcp.jar:9.0.90]
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:38) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:108) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:138) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:50) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:90) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:81) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:68) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:50) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.exec.DeleteExecutor.execute(DeleteExecutor.java:177) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:458) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:377) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1438) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1701) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1683) ~[hibernate-core-5.4.33.jar:5.4.33]
at org.bonitasoft.engine.persistence.HibernatePersistenceService.update(HibernatePersistenceService.java:186) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.temporary.content.TemporaryContentServiceImpl.cleanOutDatedTemporaryContent(TemporaryContentServiceImpl.java:77) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:255) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.platform.TemporaryContentScheduler.cleanOutDatedTempFiles(TemporaryContentScheduler.java:45) ~[bonita-server-10.2.0.beta-01.jar:?]
... 12 more
2024-07-17T15:12:38,196-0300 | | INFO | [main|1] o.b.e.p.HibernatePersistenceService - Closing Hibernate session factory of org.bonitasoft.engine.persistence.HibernatePersistenceService
2024-07-17T15:12:38,197-0300 | | INFO | [main|1] o.b.e.EngineInitializer - Bonita Engine stopped!
2024-07-17T15:12:38,197-0300 | | ERROR | [main|1] o.b.e.a.i.s.EngineInitializerListener - Error occurred while initializing the Engine. Shutting down JVM...
org.bonitasoft.engine.platform.PlatformNotFoundException: Can't start or stop platform if it is not created.
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:66) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.initializeWebApplicationContext(EngineInitializerListener.java:60) ~[bonita-server-10.2.0.beta-01.jar:?]
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:37) [bonita-server-10.2.0.beta-01.jar:?]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4007) [catalina.jar:9.0.90]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4448) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.90]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:599) [catalina.jar:9.0.90]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:571) [catalina.jar:9.0.90]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:603) [catalina.jar:9.0.90]
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:680) [catalina.jar:9.0.90]
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1844) [catalina.jar:9.0.90]
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.90]
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123) [?:?]
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:575) [catalina.jar:9.0.90]
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:466) [catalina.jar:9.0.90]
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1584) [catalina.jar:9.0.90]
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:312) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:109) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:385) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:332) [catalina.jar:9.0.90]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:776) [catalina.jar:9.0.90]
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:721) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.90]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203) [catalina.jar:9.0.90]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193) [catalina.jar:9.0.90]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.90]
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) [?:?]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749) [catalina.jar:9.0.90]
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:211) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.90]
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:415) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.90]
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:878) [catalina.jar:9.0.90]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.90]
at org.apache.catalina.startup.Catalina.start(Catalina.java:735) [catalina.jar:9.0.90]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) [bootstrap.jar:9.0.90]
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473) [bootstrap.jar:9.0.90]
