Warning: compabibility issues with Bonita versions 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.10.0, 7.10.1 and Oracle

Jerome.Jargot
Blog Categories: 

What's wrong ?

Tomcat can be started but there are many errors in the log files (available at the end of this article): ORA-25351 and stack traces ...

Explanation

The bonita engine is using XA transactions: there are distributed over several databases or schemas. The two-phase commit (2PC) protocol is used. The life cycle of these transactions is managed by both parties: the client (thanks to the transaction manager -TM- ) and the oracle database server (thanks to the Resource Manager -RM- ).

The error messages, added at the end of this article, are generated either due to an incompatibility between tomcat pool, Oracle and the use of XA transactions, or when the java oracle jdbc driver is not the appropriate one, or when the Oracle database server had not been configured for XA applications.

Tomcat bundles with tomcat-jta-7.y.z.jar file fixed

These error messages are generated because there is a compatibility issue with an open source dependency used with the Bontia Engine and Oracle:

  • either use the tomcat bundle delivered with the 7.9.5 version
  • or use a tomcat bundle delivered with the 7.10.3 + version

The exhaustive list of Bonita versions impacted is: 7.9.0, 7.9.1, 7.9.2, 7.9.3, 7.9.4, 7.10.0, and 7.10.1

Oracle jdbc driver

Double check that the jdbc driver is the proper one.

You cannot distinguish one oracle jdbc driver from another based on their filenames: indeed, for many different oracle database server versions, the jdbc drivers filename is ojdbc8.jar.

Note that each Oracle server version has an official page from which to download its specific jdbc driver.
Please, make sure to use the ojdbc8.jar file downloaded from:

Oracle server configuration for XA applications

Some error messages listed are generated because a XA Library Subprograms is not found at Oracle Database server side.

Make sure to implement the configuration described in the Oracle Database section in the Database creation and configuration for Bonita engine and BDM page:

  • Install and activate the required modules
  • Run the SQL scripts to create the views and defined the XA Library Subprograms
  • Execute the SQL requests to GRANT the proper rights to the users used with the bonita engine.



Validate that Oracle RDBMS is ready for XA

Download and and unzip the files listed below onto server hosting the Oracle server. Store the files into the /tmp directory:



Open a new XA transaction when connected with bonita user
sqlplus bonita/bpm @/tmp/bonita_open_xa_transaction.sql 3322

It is successful if these 2 lines are printed in the standard output:

...
XA Process ID 3322 started
XA Process ID 3322 is working!
...


Use the same xa transaction id with the other business_data user
sqlplus business_data/bpm @/tmp/business_data_continue_xa_transaction.sql 3322

It is successful if these 2 lines are printed in the standard output:

...
XA Process ID 3322 started - ####### Step 1 ##########
XA Process ID 3322 started - ####### Step 2 ##########
...



There are below the error messages generated in the Tomcat the log files

 27-Jan-2020 11:39:36.994 WARN [localhost-startStop-1] jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 ARJUNA016089: TransactionImple.enlistResource - xa_start  - caught: XAException.XA_RETRY for < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffac17f84e:b721:5e2ebd89:37, node_name=1, branch_uid=0:ffffac17f84e:b721:5e2ebd89:3c, subordinatenodename=null, eis_name=0 >
    oracle.jdbc.xa.OracleXAException: XAErr (4): Routine returned with no effect and may be reissued. ORA-25351 SQLErr (0)
        at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1112)
        at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:265)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:741)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:423)
        at org.apache.tomcat.dbcp.dbcp2.managed.TransactionContext.setSharedConnection(TransactionContext.java:109)
        at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:310)
        at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:89)
        at org.apache.tomcat.dbcp.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:64)
        at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)
        at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:279)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:124)
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
        at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)
        at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)
        at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:75)
        at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:54)
        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
        at org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.createEntityManagerFactory(JPABusinessDataRepositoryImpl.java:101)
        at org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.start(JPABusinessDataRepositoryImpl.java:94)
        at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
        at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:302)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:179)
        at com.bonitasoft.engine.api.impl.PlatformAPIExt.startNode(PlatformAPIExt.java:617)
        at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
        at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:28)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: java.sql.SQLException: ORA-25351: transaction is currently in use

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:441)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:436)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1061)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
        at oracle.jdbc.driver.T4CTTIOtxse.doOTXSE(T4CTTIOtxse.java:166)
        at oracle.jdbc.driver.T4CXAResource.doStart(T4CXAResource.java:207)
        at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:260)
        ... 46 more
27-Jan-2020 11:39:36.997 WARN [localhost-startStop-1] jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 ARJUNA016138: Failed to enlist XA resource oracle.jdbc.driver.T4CXAResource@e918c2
    oracle.jdbc.xa.OracleXAException: XAErr (4): Routine returned with no effect and may be reissued. ORA-25351 SQLErr (0)
        at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1112)
        at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:265)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:741)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:423)
        at org.apache.tomcat.dbcp.dbcp2.managed.TransactionContext.setSharedConnection(TransactionContext.java:109)
        at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:310)
        at org.apache.tomcat.dbcp.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:89)
        at org.apache.tomcat.dbcp.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:64)
        at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753)
        at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:279)
        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:124)
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
        at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)
        at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)
        at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:75)
        at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:54)
        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
        at org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.createEntityManagerFactory(JPABusinessDataRepositoryImpl.java:101)
        at org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.start(JPABusinessDataRepositoryImpl.java:94)
        at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
        at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:302)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:179)
        at com.bonitasoft.engine.api.impl.PlatformAPIExt.startNode(PlatformAPIExt.java:617)
        at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
        at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:28)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: java.sql.SQLException: ORA-25351: transaction is currently in use

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:441)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:436)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1061)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
        at oracle.jdbc.driver.T4CTTIOtxse.doOTXSE(T4CTTIOtxse.java:166)
        at oracle.jdbc.driver.T4CXAResource.doStart(T4CXAResource.java:207)
        at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:260)
        ... 46 more
27-Jan-2020 11:39:37.000 WARN [localhost-startStop-1] org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure HHH000342: Could not obtain connection to query metadata : Unable to enlist connection in transaction: enlistResource returns 'false'.
27-Jan-2020 11:39:37.001 INFO [localhost-startStop-1] org.hibernate.dialect.Dialect.<init> HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
27-Jan-2020 11:39:37.002 INFO [localhost-startStop-1] org.hibernate.engine.jdbc.internal.LobCreatorBuilder.useContextualLobCreation HHH000422: Disabling contextual LOB creation as connection was null
27-Jan-2020 11:39:37.165 INFO [localhost-startStop-1] org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory.<init> HHH000397: Using ASTQueryTranslatorFactory
27-Jan-2020 11:39:37.820 INFO [localhost-startStop-1] org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl.log THREAD_ID=26 | HOSTNAME=sl100886 | TENANT_ID=1 | start tenant-level service com.bonitasoft.engine.core.reporting.ReportingServiceImpl on tenant with ID 1
27-Jan-2020 11:39:37.826 WARNING [localhost-startStop-1] org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl.log THREAD_ID=26 | HOSTNAME=sl100886 | TENANT_ID=1 | Report case_avg_time can't be imported
    org.bonitasoft.engine.persistence.SBonitaReadException: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:327)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.getReportByName(ReportingServiceImpl.java:258)
        at com.bonitasoft.engine.core.reporting.DefaultReportImporter.invoke(DefaultReportImporter.java:48)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.start(ReportingServiceImpl.java:401)
        at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
        at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:302)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:179)
        at com.bonitasoft.engine.api.impl.PlatformAPIExt.startNode(PlatformAPIExt.java:617)
        at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
        at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:28)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:206)
        at org.bonitasoft.engine.persistence.TenantHibernatePersistenceService.getSession(TenantHibernatePersistenceService.java:104)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:325)
        ... 25 more
    Caused by: org.hibernate.HibernateException: Current transaction is not in progress
        at org.hibernate.context.internal.JTASessionContext.currentSession(JTASessionContext.java:98)
        at org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:1014)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:204)
        ... 27 more
27-Jan-2020 11:39:37.828 WARNING [localhost-startStop-1] org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl.log THREAD_ID=26 | HOSTNAME=sl100886 | TENANT_ID=1 | Report case_list can't be imported
    org.bonitasoft.engine.persistence.SBonitaReadException: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:327)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.getReportByName(ReportingServiceImpl.java:258)
        at com.bonitasoft.engine.core.reporting.DefaultReportImporter.invoke(DefaultReportImporter.java:48)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.start(ReportingServiceImpl.java:402)
        at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
        at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:302)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:179)
        at com.bonitasoft.engine.api.impl.PlatformAPIExt.startNode(PlatformAPIExt.java:617)
        at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
        at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:28)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:206)
        at org.bonitasoft.engine.persistence.TenantHibernatePersistenceService.getSession(TenantHibernatePersistenceService.java:104)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:325)
        ... 25 more
    Caused by: org.hibernate.HibernateException: Current transaction is not in progress
        at org.hibernate.context.internal.JTASessionContext.currentSession(JTASessionContext.java:98)
        at org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:1014)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:204)
        ... 27 more
27-Jan-2020 11:39:37.834 WARNING [localhost-startStop-1] org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl.log THREAD_ID=26 | HOSTNAME=sl100886 | TENANT_ID=1 | Report task_list can't be imported
    org.bonitasoft.engine.persistence.SBonitaReadException: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:327)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.getReportByName(ReportingServiceImpl.java:258)
        at com.bonitasoft.engine.core.reporting.DefaultReportImporter.invoke(DefaultReportImporter.java:48)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.start(ReportingServiceImpl.java:403)
        at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
        at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:302)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:179)
        at com.bonitasoft.engine.api.impl.PlatformAPIExt.startNode(PlatformAPIExt.java:617)
        at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
        at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:28)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:206)
        at org.bonitasoft.engine.persistence.TenantHibernatePersistenceService.getSession(TenantHibernatePersistenceService.java:104)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:325)
        ... 25 more
    Caused by: org.hibernate.HibernateException: Current transaction is not in progress
        at org.hibernate.context.internal.JTASessionContext.currentSession(JTASessionContext.java:98)
        at org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:1014)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:204)
        ... 27 more
27-Jan-2020 11:39:37.837 WARNING [localhost-startStop-1] org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl.log THREAD_ID=26 | HOSTNAME=sl100886 | TENANT_ID=1 | Report case_history can't be imported
    org.bonitasoft.engine.persistence.SBonitaReadException: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:327)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.getReportByName(ReportingServiceImpl.java:258)
        at com.bonitasoft.engine.core.reporting.DefaultReportImporter.invoke(DefaultReportImporter.java:48)
        at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.start(ReportingServiceImpl.java:405)
        at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
        at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
        at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:302)
        at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:179)
        at com.bonitasoft.engine.api.impl.PlatformAPIExt.startNode(PlatformAPIExt.java:617)
        at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:75)
        at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:28)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: org.bonitasoft.engine.services.SPersistenceException: org.hibernate.HibernateException: Current transaction is not in progress
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:206)
        at org.bonitasoft.engine.persistence.TenantHibernatePersistenceService.getSession(TenantHibernatePersistenceService.java:104)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:325)
        ... 25 more
    Caused by: org.hibernate.HibernateException: Current transaction is not in progress
        at org.hibernate.context.internal.JTASessionContext.currentSession(JTASessionContext.java:98)
        at org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:1014)
        at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.getSession(AbstractHibernatePersistenceService.java:204)
        ... 27 more
Notifications