Error 500 starting portal - org.bonitasoft.console.common.server.login.LoginManagerNotFoundException

Submitted by mdp438 on Tue, 04/07/2015 - 09:48
1
0
-1

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)

No answers yet.
Notifications