# Connect Bonita 7.3.3 with MySQL **URL:** \ **Category:** Q&A\ **Created:** [30 November 2016 15:16 UTC](https://community.ofelia.com/t/connect-bonita-7-3-3-with-mysql/7988 "2016-11-30T15:16:08Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![marius.kurti](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@marius.kurti](https://community.ofelia.com/u/marius.kurti)\ **Post date:** [30 November 2016 15:16 UTC](https://community.ofelia.com/t/connect-bonita-7-3-3-with-mysql/7988/1 "2016-11-30T15:16:08Z")
Hello my friends, I have tried to connect Bonita 7.3.3 with MySql database a lot of times, exactly like in Documentation but when I start Bonita it shows me problems with Tomcat (It said that Tomcat could not be launched). Please can someone help me with any tutorial or document that shows how i can do this connection for Bonita 7.3.3. I appreciate every single help from you. Thanks in advance! ---
**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\ **Post date:** [9 December 2016 19:14 UTC](https://community.ofelia.com/t/connect-bonita-7-3-3-with-mysql/7988/2 "2016-12-09T19:14:31Z")
Hi, As indicated at the bottom of this [documentation page](http://documentation.bonitasoft.com/?page=database-configuration), in some cases the maximum packet size configured by default on the DB side is not big enough. It seems to be an issue in your case: Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4216713 \> 1048576). You can change this value on the server by setting the max\_allowed\_packet’ variable. That being said, there are other issues in your logs that might be linked to something, it’s hard to say. If I was you, I would try to increase the packet size and try a fresh install (vanilla tomcat bundle and empty database). Cheers ---
**Author:** ![gyouyou.nin](https://avatars.discourse-cdn.com/v4/letter/g/bc79bd/32.png) [@gyouyou.nin](https://community.ofelia.com/u/gyouyou.nin)\ **Post date:** [22 May 2017 02:00 UTC](https://community.ofelia.com/t/connect-bonita-7-3-3-with-mysql/7988/3 "2017-05-22T02:00:49Z")
I’m so sorry disturb you .I met the same problem that can’t solve .Could you help me how to use the JAVA API to comunicate with Bonita. 017-05-22 10:17:46.776 +0900 WARRNING: org.hibernate.type.TypeFactory HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@166271af after already scoped org.hibernate.internal.SessionFactoryImpl@5f8957bd 2017-05-22 10:17:52.595 +0900 INFO: org.bonitasoft.engine.EngineInitializer Starting platform… 2017-05-22 10:17:52.891 +0900 INFO: com.bonitasoft.engine.api.impl.PlatformAPIExt THREAD\_ID=16 | HOSTNAME=SED1V010 | Start service of platform : org.bonitasoft.engine.classloader.ClassLoaderServiceImpl 2017-05-22 10:17:52.891 +0900 INFO: com.bonitasoft.engine.api.impl.PlatformAPIExt THREAD\_ID=16 | HOSTNAME=SED1V010 | Start service of platform : org.bonitasoft.engine.cache.ehcache.PlatformEhCacheCacheService 2017-05-22 10:17:52.891 +0900 INFO: com.bonitasoft.engine.api.impl.PlatformAPIExt THREAD\_ID=16 | HOSTNAME=SED1V010 | Start service of platform : com.bonitasoft.engine.service.platform.PlatformInfoUpdateScheduledExecutor 2017-05-22 10:17:52.907 +0900 SEVERE: com.bonitasoft.engine.execution.transaction.LockedTransactionExecutor THREAD\_ID=16 | HOSTNAME=SED1V010 | Unable to execute transaction. 2017-05-22 10:17:52.969 +0900 INFO: org.bonitasoft.engine.service.impl.BonitaSpringContext Refreshing org.bonitasoft.engine.service.impl.BonitaSpringContext@42cf3ef7: startup date [Mon May 22 10:17:52 JST 2017]; parent: org.bonitasoft.engine.service.impl.BonitaSpringContext@65515611 2017-05-22 10:17:52.969 +0900 INFO: org.springframework.beans.factory.xml.XmlBeanDefinitionReader Loading XML bean definitions from class path resource [bonita-tenant-community.xml] 2017-05-22 10:17:53.125 +0900 INFO: org.springframework.beans.factory.xml.XmlBeanDefinitionReader Loading XML bean definitions from class path resource [bonita-tenant-sp.xml] 2017-05-22 10:17:53.157 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘searchEntitiesDescriptor’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.search.descriptor.SearchEntitiesDescriptor]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.search.descriptor.SearchEntitiesDescriptor]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.157 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘processExecutor’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.execution.ProcessExecutorImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.execution.ProcessExecutorExt]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.157 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘connectorExecutor’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.connector.impl.ConnectorExecutorTimedOut]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.172 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘tenantEventService’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.events.impl.EventServiceImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.events.impl.ConfigurableEventServiceImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.172 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘engineConstantExpressionExecutorStrategy’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.expression.EngineConstantExpressionExecutorStrategy]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.expression.EngineConstantExpressionExecutorStrategy]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.172 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘queriableLoggerStrategy’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.services.impl.SimpleQueriableLoggerStrategy]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.log.api.impl.MapQueriableLoggerStrategy]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.172 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘syncQueriableLoggerService’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.services.impl.SyncQueriableLoggerServiceImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.log.api.impl.BatchQueriableLoggerImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.172 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘workSynchronizationFactory’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.work.SequenceWorkSynchronizationFactory]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.work.ParallelWorkSynchronizationFactory]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.188 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘leftOperandHandlers’ with a different definition: replacing [Generic bean with parent ‘communityLeftOperandHandlers’: class [org.springframework.beans.factory.config.ListFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean with parent ‘communityLeftOperandHandlers’: class [org.springframework.beans.factory.config.ListFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.188 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘externalUrlAdapter’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.core.form.ExternalURLAdapter]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [com.bonitasoft.engine.core.form.ExternalURLAdapterExt]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.188 +0900 INFO: org.springframework.beans.factory.support.DefaultListableBeanFactory Overriding bean definition for bean ‘pageService’ with a different definition: replacing [Generic bean: class [org.bonitasoft.engine.page.impl.PageServiceImpl]; scope=; abstract=false; lazyInit=false; autowireMode=2; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-community.xml]] with [Generic bean: class [org.bonitasoft.engine.page.impl.PageServiceImpl]; scope=; abstract=false; lazyInit=false; autowireMode=2; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [bonita-tenant-sp.xml]] 2017-05-22 10:17:53.188 +0900 INFO: org.springframework.beans.factory.xml.XmlBeanDefinitionReader Loading XML bean definitions from Byte array resource [bonita-tenant-sp-custom.xml] 2017-05-22 10:17:53.203 +0900 INFO: org.springframework.beans.factory.xml.XmlBeanDefinitionReader Loading XML bean definitions from Byte array resource [bonita-tenants-custom.xml] 2017-05-22 10:17:54.186 +0900 INFO: org.bonitasoft.engine.tracking.TimeTracker THREAD\_ID=16 | HOSTNAME=SED1V010 | TENANT\_ID=1 | ----- Time Tracker ‘org.bonitasoft.engine.tracking.TimeTracker’: - trackingEnabled: false - flushIntervalInSeconds: 30000 - activatedRecords: EXECUTE\_CONNECTOR\_INCLUDING\_POOL\_SUBMIT EVALUATE\_EXPRESSION EXECUTE\_CONNECTOR\_WORK EVALUATE\_EXPRESSION\_INCLUDING\_CONTEXT EXECUTE\_CONNECTOR\_CALLABLE EXECUTE\_CONNECTOR\_DISCONNECT EXECUTE\_CONNECTOR\_INPUT\_EXPRESSIONS EXECUTE\_CONNECTOR\_OUTPUT\_OPERATIONS EVALUATE\_EXPRESSIONS - flushEventListeners: org.bonitasoft.engine.tracking.memory.MemoryFlushEventListener: active: false No DayRecord registered in memory. org.bonitasoft.engine.tracking.csv.CSVFlushEventListener: active: true outputFolder: D:\BonitaBPMSubscription-7.3.3-Tomcat-7.0.67\temp - records.size: 0 - last flush occurrence: Thu Jan 01 09:00:00 JST 1970 * * * 2017-05-22 10:17:54.779 +0900 WARRNING: org.bonitasoft.engine.service.impl.BonitaSpringContext Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘tenantConfiguration’ defined in class path resource [bonita-tenant-community.xml]: Unsatisfied dependency expressed through bean property ‘lifecycleServices’: : Error creating bean with name ‘reportingService’ defined in class path resource [bonita-tenant-sp.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.bonitasoft.engine.core.reporting.ReportingServiceImpl]: Constructor threw exception; nested exception is com.bonitasoft.manager.ManagerIllegalStateException: License Error 27,201212 ; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘reportingService’ defined in class path resource [bonita-tenant-sp.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.bonitasoft.engine.core.reporting.ReportingServiceImpl]: Constructor threw exception; nested exception is com.bonitasoft.manager.ManagerIllegalStateException: License Error 27,201212 2017-05-22 10:17:54.795 +0900 INFO: org.bonitasoft.engine.EngineInitializer Exception while initializing the engine: org.bonitasoft.engine.platform.StartNodeException: Platform starting failed. 2017-05-22 10:17:54.795 +0900 SEVERE: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] class com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP Exception sending context initialization event to listener instance of java.lang.RuntimeException: Error while initializing the Engine at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:35) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.bonitasoft.engine.platform.StartNodeException: Platform starting failed. at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:210) at com.bonitasoft.engine.api.impl.PlatformAPIExt.startNode(PlatformAPIExt.java:627) at org.bonitasoft.engine.PlatformTenantManager.updatePlatform(PlatformTenantManager.java:53) at org.bonitasoft.engine.PlatformTenantManager.startPlatform(PlatformTenantManager.java:60) at org.bonitasoft.engine.EngineInitializer.startPlatform(EngineInitializer.java:147) at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:96) at com.bonitasoft.engine.api.internal.servlet.EngineInitializerListenerSP.contextInitialized(EngineInitializerListenerSP.java:32) … 13 more Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘tenantConfiguration’ defined in class path resource [bonita-tenant-community.xml]: Unsatisfied dependency expressed through bean property ‘lifecycleServices’: : Error creating bean with name ‘reportingService’ defined in class path resource [bonita-tenant-sp.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.bonitasoft.engine.core.reporting.ReportingServiceImpl]: Constructor threw exception; nested exception is com.bonitasoft.manager.ManagerIllegalStateException: License Error 27,201212 ; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘reportingService’ defined in class path resource [bonita-tenant-sp.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.bonitasoft.engine.core.reporting.ReportingServiceImpl]: Constructor threw exception; nested exception is com.bonitasoft.manager.ManagerIllegalStateException: License Error 27,201212 ``` at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1307) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1199) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538) at org.bonitasoft.engine.service.impl.SpringBeanAccessor.getContext(SpringBeanAccessor.java:76) at org.bonitasoft.engine.service.impl.SpringBeanAccessor.getService(SpringBeanAccessor.java:49) at org.bonitasoft.engine.service.impl.SpringTenantServiceAccessor.getSessionService(SpringTenantServiceAccessor.java:275) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.beforeServicesStartOfRestartHandlersOfTenant(PlatformAPIImpl.java:333) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:192) ... 19 more ``` Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘reportingService’ defined in class path resource [bonita-tenant-sp.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.bonitasoft.engine.core.reporting.ReportingServiceImpl]: Constructor threw exception; nested exception is com.bonitasoft.manager.ManagerIllegalStateException: License Error 27,201212 ``` at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:275) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1143) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1046) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1068) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1292) ... 34 more ``` Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.bonitasoft.engine.core.reporting.ReportingServiceImpl]: Constructor threw exception; nested exception is com.bonitasoft.manager.ManagerIllegalStateException: License Error 27,201212 ``` at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267) ... 46 more ``` Caused by: com.bonitasoft.manager.ManagerIllegalStateException: License Error 27,201212 2017-05-22 10:17:54.998 +0900 SEVERE: com.bonitasoft.engine.api.impl.ServerAPIExt THREAD\_ID=16 | HOSTNAME=SED1V010 | Node not started. Method ‘org.bonitasoft.engine.api.PlatformAPI.getClientPlatformConfigurations’ cannot be called until node has been started (PlatformAPI.startNode()). Exact class: org.bonitasoft.engine.api.impl.PlatformAPIImpl 2017-05-22 10:17:55.013 +0900 SEVERE: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] class org.bonitasoft.console.server.servlet.PlatformTenantListenerSP Exception sending context initialization event to listener instance of org.bonitasoft.engine.platform.NodeNotStartedException: USERNAME=local | The current node has not been started yet. Method PlatformAPI.startNode() must be called previously. at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:287) at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:430) at com.bonitasoft.engine.transaction.JTATransactionServiceExt.executeInTransaction(JTATransactionServiceExt.java:49) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86) at com.sun.proxy.$Proxy35.getClientPlatformConfigurations(Unknown Source) at org.bonitasoft.console.common.server.utils.PlatformManagementUtils.retrievePlatformConfiguration(PlatformManagementUtils.java:72) at org.bonitasoft.console.common.server.utils.PlatformManagementUtils.initializePlatformConfiguration(PlatformManagementUtils.java:84) at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:52) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) ---
**Author:** ![kiran.neupane](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kiran.neupane](https://community.ofelia.com/u/kiran.neupane)\ **Post date:** [30 November 2016 22:10 UTC](https://community.ofelia.com/t/connect-bonita-7-3-3-with-mysql/7988/4 "2016-11-30T22:10:51Z")
I have done it few months back and it worked for me. Can you attach the log message. ---
**Author:** ![marius.kurti](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@marius.kurti](https://community.ofelia.com/u/marius.kurti)\ **Post date:** [1 December 2016 12:02 UTC](https://community.ofelia.com/t/connect-bonita-7-3-3-with-mysql/7988/5 "2016-12-01T12:02:05Z")
Hello Kiran thanks a lot for the replay…today i have made the changes again and it shows me these logs in tomcat\logs bonita.2016-12-01.log: 2016-12-01 12:08:32.893 +0100 INFO: org.bonitasoft.platform.setup.PlatformSetup System property org.bonitasoft.platform.setup.folder is set to C:\BonitaBPMCommunity-7.3.3\workspace\tomcat\setup 2016-12-01 12:08:32.904 +0100 INFO: org.bonitasoft.platform.setup.PlatformSetup Connected to ‘mysql’ database with url: ‘jdbc:mysql://localhost:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8’ with user: ‘bonita@localhost’ 2016-12-01 12:08:32.907 +0100 INFO: org.bonitasoft.platform.setup.ScriptExecutor configuration for Database vendor: mysql 2016-12-01 12:08:33.171 +0100 INFO: org.bonitasoft.platform.setup.ScriptExecutor Executed SQL script /C:/BonitaBPMCommunity-7.3.3/workspace/tomcat/setup/platform\_conf/sql/mysql/dropQuartzTables.sql 2016-12-01 12:08:33.215 +0100 INFO: org.bonitasoft.platform.setup.ScriptExecutor Executed SQL script /C:/BonitaBPMCommunity-7.3.3/workspace/tomcat/setup/platform\_conf/sql/mysql/dropTables.sql 2016-12-01 12:09:37.881 +0100 SEVERE: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] Exception sending context initialized event to listener instance of class org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener java.lang.RuntimeException: Error while initializing the Engine at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:39) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #129 of file [C:\BonitaBPMCommunity-7.3.3\workspace\tomcat\setup\platform\_conf\sql\mysql\createTables.sql]: CREATE TABLE platformCommand ( id BIGINT PRIMARY KEY, name VARCHAR(50) NOT NULL UNIQUE, description TEXT, IMPLEMENTATION VARCHAR(100) NOT NULL ) ENGINE = INNODB; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:486) at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:229) at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:48) at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.execute(ResourceDatabasePopulator.java:246) at org.bonitasoft.platform.setup.ScriptExecutor.executeSQLResource(ScriptExecutor.java:192) at org.bonitasoft.platform.setup.ScriptExecutor.executeSQLResources(ScriptExecutor.java:138) at org.bonitasoft.platform.setup.ScriptExecutor.createTables(ScriptExecutor.java:99) at org.bonitasoft.platform.setup.ScriptExecutor.createAndInitializePlatformIfNecessary(ScriptExecutor.java:108) at org.bonitasoft.platform.setup.PlatformSetup.initializePlatform(PlatformSetup.java:240) at org.bonitasoft.platform.setup.PlatformSetup.init(PlatformSetup.java:124) at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:35) … 13 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1246) at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1241) at com.mysql.jdbc.ConnectionImpl.versionMeetsMinimum(ConnectionImpl.java:5229) at com.mysql.jdbc.ConnectionImpl.serverSupportsConvertFn(ConnectionImpl.java:4774) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:775) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:472) … 23 more 2016-12-01 12:09:38.006 +0100 INFO: org.bonitasoft.engine.service.impl.BonitaSpringContext Refreshing org.bonitasoft.engine.service.impl.BonitaSpringContext@1adba6be: startup date [Thu Dec 01 12:09:38 CET 2016]; root of context hierarchy 2016-12-01 12:09:38.318 +0100 INFO: org.bonitasoft.engine.service.impl.BonitaSpringContext Refreshing org.bonitasoft.engine.service.impl.BonitaSpringContext@2dbcdc15: startup date [Thu Dec 01 12:09:38 CET 2016]; parent: org.bonitasoft.engine.service.impl.BonitaSpringContext@1adba6be 2016-12-01 12:09:42.390 +0100 WARNING: org.hibernate.type.TypeFactory HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@13d149e1 after already scoped org.hibernate.internal.SessionFactoryImpl@3aa9e4fa 2016-12-01 12:09:44.671 +0100 SEVERE: org.bonitasoft.engine.api.impl.ServerAPIImpl THREAD\_ID=17 | HOSTNAME=User-PC | Node not started. Method ‘org.bonitasoft.engine.api.PlatformAPI.getClientPlatformConfigurations’ cannot be called until node has been started (PlatformAPI.startNode()). Exact class: org.bonitasoft.engine.api.impl.PlatformAPIImpl 2016-12-01 12:09:44.672 +0100 SEVERE: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] Exception sending context initialized event to listener instance of class org.bonitasoft.console.common.server.servlet.PlatformTenantListener org.bonitasoft.engine.platform.NodeNotStartedException: USERNAME=local | The current node has not been started yet. Method PlatformAPI.startNode() must be called previously. at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:287) at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:430) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:312) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86) at com.sun.proxy.$Proxy11.getClientPlatformConfigurations(Unknown Source) at org.bonitasoft.console.common.server.utils.PlatformManagementUtils.retrievePlatformConfiguration(PlatformManagementUtils.java:72) at org.bonitasoft.console.common.server.utils.PlatformManagementUtils.initializePlatformConfiguration(PlatformManagementUtils.java:84) at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:52) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 2016-12-01 12:09:44.678 +0100 INFO: org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener Initialization went wrong, no need to try to unload the Engine 2016-12-01 12:09:49.423 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 2016-12-01 12:09:49.423 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer d8888b. .d88b. d8b db d888888b d888888b .d8b. .d8888. .d88b. d88888b d888888b 2016-12-01 12:09:49.423 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88 `8D .8P Y8. 888o 88 `88’ ` ~~88~~' d8' `8b 88’ YP .8P Y8. 88’ ` ~~88~~' 2016-12-01 12:09:49.423 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88oooY' 88 88 88V8o 88 88 88 88ooo88 `8bo. 88 88 88ooo 88 2016-12-01 12:09:49.423 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88 ~~~b. 88 88 88 V8o88 88 88 88~~~ 88 `Y8b. 88 88 88~~~ 88 2016-12-01 12:09:49.423 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88 8D `8b d8’ 88 V888 .88. 88 88 88 db 8D `8b d8' 88 88 2016-12-01 12:09:49.423 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer Y8888P' `Y88P’ VP V8P Y888888P YP YP YP `8888Y' `Y88P’ YP YP 2016-12-01 12:09:49.425 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer ==================================================================================================== 2016-12-01 12:09:49.425 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer UI-DESIGNER : Community edition v.1.3.25 2016-12-01 12:09:49.425 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer ==================================================================================================== 2016-12-01 12:09:49.668 +0100 INFO: org.bonitasoft.web.designer.config.DesignerConfigConditional Conf loaded : Community edition 2016-12-01 12:09:49.768 +0100 INFO: org.bonitasoft.web.designer.config.DesignerConfigConditional Conf loaded : Community edition 2016-12-01 12:09:49.793 +0100 INFO: org.bonitasoft.web.designer.config.DesignerConfigConditional Conf loaded : Community edition 2016-12-01 12:09:51.530 +0100 INFO: org.bonitasoft.web.designer.config.WebMvcConfiguration Adding welcome page: file:/C:/BonitaBPMCommunity-7.3.3/workspace/tomcat/webapps/designer/WEB-INF/classes/static/index.html 2016-12-01 12:09:52.034 +0100 WARNING: org.bonitasoft.console.server.listener.StudioWatchdogListener Bonita Studio watchdog process has started on port 6969 with a delay set to 5000 ms 2016-12-01 12:15:47.652 +0100 INFO: org.bonitasoft.platform.setup.PlatformSetup System property org.bonitasoft.platform.setup.folder is set to C:\BonitaBPMCommunity-7.3.3\workspace\tomcat\setup 2016-12-01 12:15:47.661 +0100 INFO: org.bonitasoft.platform.setup.PlatformSetup Connected to ‘mysql’ database with url: ‘jdbc:mysql://localhost:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8’ with user: ‘bonita@localhost’ 2016-12-01 12:15:47.664 +0100 INFO: org.bonitasoft.platform.setup.ScriptExecutor configuration for Database vendor: mysql 2016-12-01 12:15:47.717 +0100 INFO: org.bonitasoft.platform.setup.PlatformSetup Platform is already created. Nothing to do. 2016-12-01 12:15:47.755 +0100 INFO: org.bonitasoft.engine.EngineInitializer Initializing Bonita Engine… 2016-12-01 12:15:47.755 +0100 INFO: org.bonitasoft.engine.EngineInitializer Initializing Spring context… 2016-12-01 12:15:47.855 +0100 INFO: org.bonitasoft.engine.service.impl.BonitaSpringContext Refreshing org.bonitasoft.engine.service.impl.BonitaSpringContext@d1e3a87: startup date [Thu Dec 01 12:15:47 CET 2016]; root of context hierarchy 2016-12-01 12:15:48.093 +0100 INFO: org.bonitasoft.engine.service.impl.BonitaSpringContext Refreshing org.bonitasoft.engine.service.impl.BonitaSpringContext@61d42651: startup date [Thu Dec 01 12:15:48 CET 2016]; parent: org.bonitasoft.engine.service.impl.BonitaSpringContext@d1e3a87 2016-12-01 12:15:52.592 +0100 WARNING: org.hibernate.type.TypeFactory HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@5194ab80 after already scoped org.hibernate.internal.SessionFactoryImpl@2762177d 2016-12-01 12:15:55.941 +0100 INFO: org.bonitasoft.engine.service.impl.BonitaSpringContext Refreshing org.bonitasoft.engine.service.impl.BonitaSpringContext@220c123: startup date [Thu Dec 01 12:15:55 CET 2016]; parent: org.bonitasoft.engine.service.impl.BonitaSpringContext@61d42651 2016-12-01 12:15:56.760 +0100 INFO: org.bonitasoft.engine.tracking.TimeTracker THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | ----- Time Tracker ‘org.bonitasoft.engine.tracking.TimeTracker’: - trackingEnabled: false - flushIntervalInSeconds: 30000 - activatedRecords: EXECUTE\_CONNECTOR\_INCLUDING\_POOL\_SUBMIT EXECUTE\_CONNECTOR\_WORK EXECUTE\_CONNECTOR\_OUTPUT\_OPERATIONS EXECUTE\_CONNECTOR\_DISCONNECT EVALUATE\_EXPRESSION\_INCLUDING\_CONTEXT EVALUATE\_EXPRESSION EVALUATE\_EXPRESSIONS EXECUTE\_CONNECTOR\_INPUT\_EXPRESSIONS EXECUTE\_CONNECTOR\_CALLABLE - flushEventListeners: org.bonitasoft.engine.tracking.memory.MemoryFlushEventListener: active: false No DayRecord registered in memory. org.bonitasoft.engine.tracking.csv.CSVFlushEventListener: active: true outputFolder: C:\BonitaBPMCommunity-7.3.3\workspace\tomcat\temp - records.size: 0 - last flush occurrence: Thu Jan 01 01:00:00 CET 1970 * * * 2016-12-01 12:15:57.165 +0100 INFO: org.bonitasoft.engine.profile.DefaultProfilesUpdater THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Default profiles not up to date, updating them… 2016-12-01 12:15:57.707 +0100 INFO: org.bonitasoft.engine.profile.DefaultProfilesUpdater THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Updated default profiles [ImportStatus [name=User, status=ADDED, errors=], ImportStatus [name=Administrator, status=ADDED, errors=]] 2016-12-01 12:15:57.790 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaSchedulerFactory Using default implementation for ThreadExecutor 2016-12-01 12:15:57.814 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT Using db table-based data access locking (synchronization). 2016-12-01 12:15:57.820 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT JobStoreCMT initialized. 2016-12-01 12:15:57.825 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaSchedulerFactory Quartz scheduler ‘QuartzScheduler’ initialized from an externally provided properties instance. 2016-12-01 12:15:57.827 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaSchedulerFactory Quartz scheduler version: 2.2.1 2016-12-01 12:15:57.836 +0100 INFO: org.bonitasoft.engine.scheduler.impl.SchedulerServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | Start scheduler 2016-12-01 12:15:57.907 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT Freed 0 triggers from ‘acquired’ / ‘blocked’ state. 2016-12-01 12:15:57.951 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT Recovering 0 jobs that were in-progress at the time of the last shut-down. 2016-12-01 12:15:57.953 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT Recovery complete. 2016-12-01 12:15:57.953 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT Removed 0 ‘complete’ triggers. 2016-12-01 12:15:57.954 +0100 INFO: org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT Removed 0 stale fired job entries. 2016-12-01 12:15:58.029 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.platform.ActivateTenant THREAD\_ID=16 | HOSTNAME=User-PC | Starting event handling job with frequency : 0/5 \* \* \* \* ? 2016-12-01 12:15:58.183 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.platform.ActivateTenant THREAD\_ID=16 | HOSTNAME=User-PC | Starting clean invalid sessions job with frequency : 0 0 \*/2 \* \* ? 2016-12-01 12:15:59.034 +0100 INFO: org.bonitasoft.engine.EngineInitializer Platform initialized successfully 2016-12-01 12:15:59.035 +0100 INFO: org.bonitasoft.engine.EngineInitializer Starting platform… 2016-12-01 12:15:59.143 +0100 INFO: org.bonitasoft.engine.api.impl.PlatformAPIImpl THREAD\_ID=16 | HOSTNAME=User-PC | Start service of platform : org.bonitasoft.engine.classloader.ClassLoaderServiceImpl 2016-12-01 12:15:59.143 +0100 INFO: org.bonitasoft.engine.api.impl.PlatformAPIImpl THREAD\_ID=16 | HOSTNAME=User-PC | Start service of platform : org.bonitasoft.engine.cache.ehcache.PlatformEhCacheCacheService 2016-12-01 12:15:59.201 +0100 INFO: org.bonitasoft.engine.execution.work.RestartFlowNodesHandler THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Restarting flow nodes… 2016-12-01 12:15:59.215 +0100 INFO: org.bonitasoft.engine.execution.work.RestartFlowNodesHandler THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Found 0 flow nodes to restart on tenant 1 2016-12-01 12:15:59.248 +0100 INFO: org.bonitasoft.engine.execution.work.RestartProcessHandler THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Found 0 process to restart on tenant 1 2016-12-01 12:15:59.250 +0100 INFO: org.bonitasoft.engine.execution.work.BPMEventWorksHandler THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Reinitializing message instances in non-stable state to make them reworked by BPMEventHandlingJob 2016-12-01 12:15:59.265 +0100 INFO: org.bonitasoft.engine.execution.work.BPMEventWorksHandler THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | 0 message instances found and reset. 2016-12-01 12:15:59.265 +0100 INFO: org.bonitasoft.engine.execution.work.BPMEventWorksHandler THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Reinitializing waiting message events in non-stable state to make them reworked by BPMEventHandlingJob 2016-12-01 12:15:59.290 +0100 INFO: org.bonitasoft.engine.execution.work.BPMEventWorksHandler THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | 0 waiting message events found and reset. 2016-12-01 12:15:59.452 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.SetServiceState THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | start tenant-level service org.bonitasoft.engine.command.api.impl.CommandServiceImpl on tenant with ID 1 2016-12-01 12:15:59.515 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘getBusinessDataByQueryCommand’, description='Execute a named query in the BDM, and returns its Json representation. Use parameter keys : “queryName” the name of the query in the bdm, “returnType” the query expected return type, “returnsList” if result is a List or a single value, “queryParameters” a Map to value query parameters ', implementation=‘org.bonitasoft.engine.command.GetBusinessDataByQueryCommand’} 2016-12-01 12:15:59.581 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘isAllowedToSeeOverviewForm’, description=‘Check if one of many actors can be allowed to read overview form.’, implementation=‘org.bonitasoft.engine.external.permission.IsAllowedToSeeOverviewForm’} 2016-12-01 12:15:59.594 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘canStartProcessDefinition’, description='Return true if the user can start the process, false otherwise. Use parameter key USER\_ID\_KEY and PROCESS\_DEFINITION\_ID\_KEY ', implementation=‘org.bonitasoft.engine.external.permission.CanStartProcessDefinition’} 2016-12-01 12:15:59.603 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘isAllowedToStartProcesses’, description=‘Check if the user can be allowed to start all of processes.’, implementation=‘org.bonitasoft.engine.external.permission.IsAllowedToStartProcesses’} 2016-12-01 12:15:59.719 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘getSupervisor’, description=‘Get process supervisor. Use parameter key SUPERVISOR\_ID\_KEY’, implementation=‘org.bonitasoft.engine.external.process.GetSupervisor’} 2016-12-01 12:15:59.729 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘isAllowedToStartProcess’, description=‘Check if one of many actors can be allowed to start process.(who’s the process Initiator)’, implementation=‘org.bonitasoft.engine.external.permission.IsAllowedToStartProcess’} 2016-12-01 12:15:59.739 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘executeBDMQuery’, description='Execute a named query in the BDM. Use parameter keys : “queryName” the name of the query in the bdm, “returnType” the query expected return type, “returnsList” if result is a List or a single value, “queryParameters” a Map to value query parameters ', implementation=‘org.bonitasoft.engine.command.ExecuteBDMQueryCommand’} 2016-12-01 12:15:59.745 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘isUserProcessSupervisor’, description='Get if the user a supervisor of processDefinition. Use parameter keys USER\_ID\_KEY, PROCESS\_DEFINITION\_ID\_KEY ', implementation=‘org.bonitasoft.engine.external.process.IsUserProcessSupervisor’} 2016-12-01 12:15:59.751 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘isInvolvedInHumanTask’, description='Return true if a user is involved in a specific human task, false otherwise. Use parameter key USER\_ID\_KEY and HUMAN\_TASK\_INSTANCE\_ID\_KEY ', implementation=‘org.bonitasoft.engine.external.permission.IsInvolvedInHumanTask’} 2016-12-01 12:15:59.756 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchEntityMembersCommand’, description='Searches Entity member mappings: Parameter keys: DISCRIMINATOR\_ID\_KEY: the discriminator to isolate the different functional notions, SEARCH\_OPTIONS\_KEY: the Search options to filter and sort the results, MEMBER\_TYPE\_KEY: Member Type to search for (USER, GROUP, ROLE, or MEMBERSHIP). ', implementation=‘org.bonitasoft.engine.external.identitymapping.SearchEntityMembersCommand’} 2016-12-01 12:15:59.762 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchProcessSupervisors’, description=‘Search process supervisor for process definition.’, implementation=‘org.bonitasoft.engine.external.process.SearchProcessSupervisors’} 2016-12-01 12:15:59.769 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘deleteEntityMembersCommand’, description='Delete all Entity member mappings associated with provided externalId, for specific Discriminator. Parameter keys: EXTERNAL\_ID\_KEY: external id provided as is by the external system, DISCRIMINATOR\_ID\_KEY: the discriminator to isolate the different functional notions. ', implementation=‘org.bonitasoft.engine.external.identitymapping.DeleteEntityMembersCommand’} 2016-12-01 12:15:59.773 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchArchivedTasksSupervisedBy’, description='Returns the list of archived user tasks of process definition supervised by a user. Use parameter keys SUPERVISOR\_ID\_KEY: id of the supervisor, SEARCH\_OPTIONS\_KEY: the object containing all the search parameters ', implementation=‘org.bonitasoft.engine.external.task.supervisor.SearchArchivedTasksSupervisedBy’} 2016-12-01 12:15:59.779 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘removeEntityMemberCommand’, description=‘Removes a Entity member mapping: ENTITY\_MEMBER\_ID\_KEY: Entity member id to remove’, implementation=‘org.bonitasoft.engine.external.identitymapping.RemoveEntityMemberCommand’} 2016-12-01 12:15:59.787 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘deleteSessionCommand’, description=‘Deletes a tenant session based on its sessionId’, implementation=‘org.bonitasoft.engine.command.DeleteSessionCommand’} 2016-12-01 12:15:59.791 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchAssignedTasksSupervisedBy’, description=‘Returns the list of assigned user tasks of process definition supervised by a user.’, implementation=‘org.bonitasoft.engine.external.task.supervisor.SearchAssignedTasksSupervisedBy’} 2016-12-01 12:15:59.794 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘deleteSupervisor’, description=‘Delete process supervisor. Use parameter key SUPERVISOR\_ID\_KEY’, implementation=‘org.bonitasoft.engine.external.process.DeleteSupervisor’} 2016-12-01 12:15:59.801 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchWaitingEventsCommand’, description=‘Search waiting events. Parameter keys: searchOptions.’, implementation=‘org.bonitasoft.engine.command.system.SearchWaitingEventsCommand’} 2016-12-01 12:15:59.806 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘advancedStartProcessCommand’, description=‘Advanced start process.’, implementation=‘org.bonitasoft.engine.command.AdvancedStartProcessCommand’} 2016-12-01 12:15:59.809 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘createSupervisor’, description=‘Create process supervisor.’, implementation=‘org.bonitasoft.engine.external.process.CreateSupervisor’} 2016-12-01 12:15:59.812 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘addEntityMemberCommand’, description='Adds a Entity member to the provided identity notions. Parameter keys: EXTERNAL\_ID\_KEY: Entity member id provided as is by the external system, userId: -1 is not needed, roleId: -1 is not needed, groupId: -1 is not needed ', implementation=‘org.bonitasoft.engine.external.identitymapping.AddEntityMemberCommand’} 2016-12-01 12:15:59.817 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘executeActionsAndTerminate’, description=‘execute actions and terminate a user task instance’, implementation=‘org.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTask’} 2016-12-01 12:15:59.821 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘getBusinessDataById’, description=‘Get the business data via its identifier and class name, and returns its Json representation.’, implementation=‘org.bonitasoft.engine.command.GetBusinessDataByIdCommand’} 2016-12-01 12:15:59.824 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘multipleStartPointsProcessCommand’, description=‘Advanced start process using multiple start points.’, implementation=‘org.bonitasoft.engine.command.MultipleStartPointsProcessCommand’} 2016-12-01 12:15:59.827 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchSCommentSupervisedBy’, description='Returns the list of comments for processes supervised by a user. One mandatory parameter: supervisorId: ID of the user supervisor of the processes on which comments are. ', implementation=‘org.bonitasoft.engine.external.comment.SearchCommentsSupervisedBy’} 2016-12-01 12:15:59.830 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘isAllowedToSeeInstanciationForm’, description=‘Check if one of many actors can be allowed to read Instanciation form.’, implementation=‘org.bonitasoft.engine.external.permission.IsAllowedToSeeInstanciationForm’} 2016-12-01 12:15:59.833 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘exportDefaultProfilesCommand’, description=‘Export default profiles’, implementation=‘org.bonitasoft.engine.external.web.profile.command.ExportDefaultProfilesCommand’} 2016-12-01 12:15:59.838 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchEntityMembersForUserCommand’, description='Searches Entity member mappings: Parameter keys: USER\_ID\_KEY: the ID of the user to search Entity members for (directly associated, or through role or group), DISCRIMINATOR\_ID\_KEY: the discriminator to isolate the different functional notions, SEARCH\_OPTIONS\_KEY: the Search options to filter and sort the results. ', implementation=‘org.bonitasoft.engine.external.identitymapping.SearchEntityMembersForUserCommand’} 2016-12-01 12:15:59.842 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘importProfilesCommand’, description=‘Import profiles, profileEntries and profile mappings’, implementation=‘org.bonitasoft.engine.external.web.profile.command.ImportProfilesCommand’} 2016-12-01 12:15:59.845 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘searchProcessDefinitionsSupervisedBy’, description=‘Searching processeDefinitions whose supervisor is the specified user.’, implementation=‘org.bonitasoft.engine.external.supervisor.SearchProcessDefinitionsSupervisedBy’} 2016-12-01 12:15:59.850 +0100 INFO: org.bonitasoft.engine.command.api.impl.CommandServiceImpl THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Creating missing system command: CommandDeployment{name=‘getBusinessDataByIds’, description=‘Get the business data via its identifiers and class name, and returns its Json representation. ‘, implementation=‘org.bonitasoft.engine.command.GetBusinessDataByIdsCommand’} 2016-12-01 12:15:59.855 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.SetServiceState THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | start tenant-level service org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl on tenant with ID 1 2016-12-01 12:15:59.856 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.SetServiceState THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | start tenant-level service org.bonitasoft.engine.work.ExecutorWorkService on tenant with ID 1 2016-12-01 12:15:59.856 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.SetServiceState THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | start tenant-level service org.bonitasoft.engine.tracking.TimeTracker on tenant with ID 1 2016-12-01 12:15:59.856 +0100 INFO: org.bonitasoft.engine.tracking.TimeTracker THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | Starting TimeTracker… 2016-12-01 12:15:59.856 +0100 INFO: org.bonitasoft.engine.tracking.TimeTracker THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | TimeTracker started. 2016-12-01 12:15:59.856 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.SetServiceState THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | start tenant-level service org.bonitasoft.engine.theme.impl.ThemeServiceImpl on tenant with ID 1 2016-12-01 12:15:59.938 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.SetServiceState THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | start tenant-level service org.bonitasoft.engine.service.impl.PermissionServiceImpl on tenant with ID 1 2016-12-01 12:15:59.972 +0100 INFO: org.bonitasoft.engine.api.impl.transaction.SetServiceState THREAD\_ID=16 | HOSTNAME=User-PC | TENANT\_ID=1 | start tenant-level service org.bonitasoft.engine.page.impl.PageServiceImpl on tenant with ID 1 2016-12-01 12:16:00.262 +0100 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 0, SQLState: S1000 2016-12-01 12:16:00.264 +0100 SEVERE: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Packet for query is too large (4216713 \> 1048576). You can change this value on the server by setting the max\_allowed\_packet’ variable. 2016-12-01 12:16:00.316 +0100 INFO: org.bonitasoft.engine.EngineInitializer Exception while initializing the engine: org.bonitasoft.engine.platform.StartNodeException: Platform starting failed. 2016-12-01 12:16:00.317 +0100 SEVERE: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] Exception sending context initialized event to listener instance of class org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener java.lang.RuntimeException: Error while initializing the Engine at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:39) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.bonitasoft.engine.platform.StartNodeException: Platform starting failed. at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:210) at org.bonitasoft.engine.PlatformTenantManager.updatePlatform(PlatformTenantManager.java:53) at org.bonitasoft.engine.PlatformTenantManager.startPlatform(PlatformTenantManager.java:60) at org.bonitasoft.engine.EngineInitializer.startPlatform(EngineInitializer.java:147) at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:96) at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:36) … 13 more Caused by: org.bonitasoft.engine.exception.UpdateException: Unable to start service: org.bonitasoft.engine.page.impl.PageServiceImpl at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:81) at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:312) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:415) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:194) … 18 more Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not execute statement at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:406) at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:333) at org.bonitasoft.engine.page.impl.PageServiceImpl.getPageByName(PageServiceImpl.java:346) at org.bonitasoft.engine.page.impl.PageServiceImpl.importProvidedPage(PageServiceImpl.java:636) at org.bonitasoft.engine.page.impl.PageServiceImpl.importProvidedPage(PageServiceImpl.java:628) at org.bonitasoft.engine.page.impl.PageServiceImpl.start(PageServiceImpl.java:618) at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33) at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79) … 22 more Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3079) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521) at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67) at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1130) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1187) at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:909) at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:402) … 29 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4216713 \> 1048576). You can change this value on the server by setting the max\_allowed\_packet’ variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3675) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994) at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:543) at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64) at com.sun.proxy.$Proxy37.executeUpdate(Unknown Source) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) … 43 more 2016-12-01 12:16:00.399 +0100 SEVERE: org.bonitasoft.engine.api.impl.ServerAPIImpl THREAD\_ID=16 | HOSTNAME=User-PC | Node not started. Method ‘org.bonitasoft.engine.api.PlatformAPI.getClientPlatformConfigurations’ cannot be called until node has been started (PlatformAPI.startNode()). Exact class: org.bonitasoft.engine.api.impl.PlatformAPIImpl 2016-12-01 12:16:00.399 +0100 SEVERE: org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] Exception sending context initialized event to listener instance of class org.bonitasoft.console.common.server.servlet.PlatformTenantListener org.bonitasoft.engine.platform.NodeNotStartedException: USERNAME=local | The current node has not been started yet. Method PlatformAPI.startNode() must be called previously. at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:287) at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:430) at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:312) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86) at com.sun.proxy.$Proxy38.getClientPlatformConfigurations(Unknown Source) at org.bonitasoft.console.common.server.utils.PlatformManagementUtils.retrievePlatformConfiguration(PlatformManagementUtils.java:72) at org.bonitasoft.console.common.server.utils.PlatformManagementUtils.initializePlatformConfiguration(PlatformManagementUtils.java:84) at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:52) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 2016-12-01 12:16:00.404 +0100 INFO: org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener Initialization went wrong, no need to try to unload the Engine 2016-12-01 12:16:01.550 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 2016-12-01 12:16:01.551 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer d8888b. .d88b. d8b db d888888b d888888b .d8b. .d8888. .d88b. d88888b d888888b 2016-12-01 12:16:01.551 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88 `8D .8P Y8. 888o 88 `88’ ` ~~88~~' d8' `8b 88’ YP .8P Y8. 88’ ` ~~88~~' 2016-12-01 12:16:01.551 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88oooY' 88 88 88V8o 88 88 88 88ooo88 `8bo. 88 88 88ooo 88 2016-12-01 12:16:01.551 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88 ~~~b. 88 88 88 V8o88 88 88 88~~~ 88 `Y8b. 88 88 88~~~ 88 2016-12-01 12:16:01.551 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer 88 8D `8b d8’ 88 V888 .88. 88 88 88 db 8D `8b d8' 88 88 2016-12-01 12:16:01.552 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer Y8888P' `Y88P’ VP V8P Y888888P YP YP YP `8888Y' `Y88P’ YP YP 2016-12-01 12:16:01.553 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer ==================================================================================================== 2016-12-01 12:16:01.553 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer UI-DESIGNER : Community edition v.1.3.25 2016-12-01 12:16:01.553 +0100 INFO: org.bonitasoft.web.designer.SpringWebApplicationInitializer ==================================================================================================== 2016-12-01 12:16:01.806 +0100 INFO: org.bonitasoft.web.designer.config.DesignerConfigConditional Conf loaded : Community edition 2016-12-01 12:16:01.972 +0100 INFO: org.bonitasoft.web.designer.config.DesignerConfigConditional Conf loaded : Community edition 2016-12-01 12:16:01.998 +0100 INFO: org.bonitasoft.web.designer.config.DesignerConfigConditional Conf loaded : Community edition 2016-12-01 12:16:04.551 +0100 INFO: org.bonitasoft.web.designer.config.WebMvcConfiguration Adding welcome page: file:/C:/BonitaBPMCommunity-7.3.3/workspace/tomcat/webapps/designer/WEB-INF/classes/static/index.html 2016-12-01 12:16:05.118 +0100 WARNING: org.bonitasoft.console.server.listener.StudioWatchdogListener Bonita Studio watchdog process has started on port 6969 with a delay set to 5000 ms 2016-12-01 12:16:06.123 +0100 WARNING: org.bonitasoft.console.server.listener.StudioWatchdogListener Bonita Studio process has been killed, terminating tomcat process properly ---
**Author:** ![marius.kurti](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@marius.kurti](https://community.ofelia.com/u/marius.kurti)\ **Post date:** [14 December 2016 09:58 UTC](https://community.ofelia.com/t/connect-bonita-7-3-3-with-mysql/7988/6 "2016-12-14T09:58:17Z")
Thanks a lot for your effort Lionel Palacin…but i have followed another way to connect to databese. I have used JAVA API to comunicate with Bonita. Thanks in advance