After completing installation and changes to configuration files to manage MySql Database ( as per “http://documentation.bonitasoft.com/database-configuration-0” documentation), I launch the application and get error 500.
Inside bonita database I found two table created by initialization → actor and actormember ( both empty).
Below the bonita-log:
2015-04-07 09:37:23 org.bonitasoft.engine.EngineInitializer
INFO: Initializing Bonita Engine…
2015-04-07 09:37:23 org.bonitasoft.engine.EngineInitializer
INFO: Initializing Spring context…
2015-04-07 09:37:24 org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext
INFO: Refreshing org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@6d23121f: startup date [Tue Apr 07 09:37:24 CEST 2015]; root of context hierarchy
2015-04-07 09:37:24 org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext
INFO: Refreshing org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@28dbceb3: startup date [Tue Apr 07 09:37:24 CEST 2015]; parent: org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@6d23121f
2015-04-07 09:37:28 org.hibernate.dialect.H2Dialect
WARN: HHH000431: Unable to determine H2 database version, certain features may not work
2015-04-07 09:37:34 org.hibernate.dialect.H2Dialect
WARN: HHH000431: Unable to determine H2 database version, certain features may not work
2015-04-07 09:37:34 org.hibernate.type.TypeFactory
WARN: HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@63b2aaf9 after already scoped org.hibernate.internal.SessionFactoryImpl@49b8c130
2015-04-07 09:37:38 org.bonitasoft.engine.EngineInitializer
INFO: Initializing platform…
2015-04-07 09:37:38 org.bonitasoft.engine.EngineInitializer
INFO: Creating platform…
2015-04-07 09:37:38 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
WARN: SQL Error: 1146, SQLState: 42S02
2015-04-07 09:37:38 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
ERROR: Table ‘bonita.platform’ doesn’t exist
2015-04-07 09:37:39 org.bonitasoft.engine.platform.impl.PlatformServiceImpl
SEVERE: THREAD_ID=17 | HOSTNAME=ITS00128 | Following SQL command failed: CREATE TABLE category (
tenantid BIGINT NOT NULL,
id BIGINT NOT NULL,
name VARCHAR(50) NOT NULL,
creator BIGINT,
description LONGVARCHAR,
creationDate BIGINT NOT NULL,
lastUpdateDate BIGINT NOT NULL,
UNIQUE (tenantid, name),
PRIMARY KEY (tenantid, id)
)
2015-04-07 09:37:39 org.bonitasoft.engine.EngineInitializer
INFO: Platform is already initialized.
org.bonitasoft.engine.exception.CreationException: Platform Creation failed.
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:159)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:200)
at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:43)
at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:140)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
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:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
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.exception.SPlatformCreationException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR,
creationDate BIGINT NOT NULL,
lastUpdateDate BIGINT NOT NULL,
’ at line 6
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createTables(PlatformServiceImpl.java:179)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:143)
… 18 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR,
creationDate BIGINT NOT NULL,
lastUpdateDate BIGINT NOT NULL,
’ at line 6
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:389)
at com.mysql.jdbc.Util.getInstance(Util.java:372)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.doExecuteSQLThroughJDBC(PlatformServiceImpl.java:283)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResource(PlatformServiceImpl.java:258)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:199)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:189)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createTables(PlatformServiceImpl.java:175)
… 19 more
2015-04-07 09:37:39 org.bonitasoft.engine.EngineInitializer
INFO: Starting platform…
2015-04-07 09:37:39 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
WARN: SQL Error: 1146, SQLState: 42S02
2015-04-07 09:37:39 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
ERROR: Table ‘bonita.platform’ doesn’t exist
2015-04-07 09:37:39 org.bonitasoft.engine.EngineInitializer
INFO: Exception while initializing the engine: org.bonitasoft.engine.platform.PlatformNotFoundException: Can’t start or stop platform if it is not created
2015-04-07 09:37:39 org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener
SEVERE: Error while initializing the Engine
org.bonitasoft.engine.platform.PlatformNotFoundException: Can’t start or stop platform if it is not created
at org.bonitasoft.engine.PlatformTenantManager.updatePlatform(PlatformTenantManager.java:51)
at org.bonitasoft.engine.PlatformTenantManager.startPlatform(PlatformTenantManager.java:61)
at org.bonitasoft.engine.EngineInitializer.startPlatform(EngineInitializer.java:147)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:101)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
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:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
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)
2015-04-07 09:37:39 org.bonitasoft.console.common.server.servlet.PlatformTenantListener
SEVERE: Error while initializing the default tenant
org.bonitasoft.engine.platform.NodeNotStartedException: 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:286)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:279)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy7.login(Unknown Source)
at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.initializeDefaultTenant(PlatformTenantListener.java:61)
at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:44)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
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:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
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)
2015-04-07 09:37:39 org.bonitasoft.console.server.listener.StudioWatchdogListener
WARNING: Bonita Studio watchdog process has started on 6969 with a delay of 20000ms
2015-04-07 09:38:09 org.bonitasoft.console.common.server.login.servlet.LoginServlet
SEVERE: Unable to get the default tenant.
org.bonitasoft.engine.platform.NodeNotStartedException: 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:286)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:279)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy7.login(Unknown Source)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.getTenantId(LoginServlet.java:187)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doLogin(LoginServlet.java:168)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doPost(LoginServlet.java:89)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doGet(LoginServlet.java:72)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
2015-04-07 09:38:09 org.bonitasoft.console.common.server.login.servlet.LoginServlet
SEVERE: Error while trying to log in
org.bonitasoft.console.common.server.login.LoginManagerNotFoundException: The LoginManager implementation null does not exist!
at org.bonitasoft.console.common.server.login.LoginManagerFactory.getLoginManager(LoginManagerFactory.java:40)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.getLoginManager(LoginServlet.java:178)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doLogin(LoginServlet.java:170)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doPost(LoginServlet.java:89)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doGet(LoginServlet.java:72)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
2015-04-07 09:38:09 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[loginService]
SEVERE: Servlet.service() for servlet [loginService] in context with path [/bonita] threw exception [org.bonitasoft.console.common.server.login.LoginManagerNotFoundException: The LoginManager implementation null does not exist!] with root cause
org.bonitasoft.console.common.server.login.LoginManagerNotFoundException: The LoginManager implementation null does not exist!
at org.bonitasoft.console.common.server.login.LoginManagerFactory.getLoginManager(LoginManagerFactory.java:40)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.getLoginManager(LoginServlet.java:178)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doLogin(LoginServlet.java:170)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doPost(LoginServlet.java:89)
at org.bonitasoft.console.common.server.login.servlet.LoginServlet.doGet(LoginServlet.java:72)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)