Connect Bonita 7.3.3 with MySQL

1
0
-1

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!

Comments

Submitted by kiran.neupane on Wed, 11/30/2016 - 23:10

I have done it few months back and it worked for me. Can you attach the log message.

Submitted by marius.kurti on Thu, 12/01/2016 - 13:02

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 8888' ~~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 8888' ~~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

2 answers

1
0
-1

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)

1
0
-1

Hi,

As indicated at the bottom of this documentation page, 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

Comments

Submitted by marius.kurti on Wed, 12/14/2016 - 10:58

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

Notifications