Unable to check if a default tenant already exists

Hi,

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: org.bonitasoft.console.common.server.utils.DefaultTenantIdException: Can't retrieve default tenant id
org.bonitasoft.console.common.server.sso.filter.SSOFilter.doFilter(SSOFilter.java:109)
root cause

org.bonitasoft.console.common.server.utils.DefaultTenantIdException: Can't retrieve default tenant id
org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:204)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.getTenantId(AuthorizationFilter.java:87)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:65)
org.bonitasoft.console.common.server.sso.filter.SSOFilter.doFilter(SSOFilter.java:103)
root cause

org.bonitasoft.engine.platform.LoginException: Unable to check if a default tenant already exists: org.hibernate.exception.SQLGrammarException: could not execute query
org.bonitasoft.engine.api.impl.LoginAPIImpl.getDefaultTenant(LoginAPIImpl.java:118)
org.bonitasoft.engine.api.impl.LoginAPIImpl.login(LoginAPIImpl.java:58)
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:239)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
com.sun.proxy.$Proxy4.login(Unknown Source)
org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:199)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.getTenantId(AuthorizationFilter.java:87)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:65)
org.bonitasoft.console.common.server.sso.filter.SSOFilter.doFilter(SSOFilter.java:103)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
java.lang.Thread.run(Thread.java:722)
══════════════════════════.()
org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getDefaultTenant(PlatformServiceImpl.java:491)
org.bonitasoft.engine.api.impl.transaction.platform.GetDefaultTenantInstance.execute(GetDefaultTenantInstance.java:36)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
org.bonitasoft.engine.api.impl.LoginAPIImpl.getDefaultTenant(LoginAPIImpl.java:111)
org.bonitasoft.engine.api.impl.LoginAPIImpl.login(LoginAPIImpl.java:58)
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:239)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
com.sun.proxy.$Proxy4.login(Unknown Source)
org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:199)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.getTenantId(AuthorizationFilter.java:87)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:65)
org.bonitasoft.console.common.server.sso.filter.SSOFilter.doFilter(SSOFilter.java:103)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
java.lang.Thread.run(Thread.java:722)
.Caused By:(Unable to check if a default tenant already exists: org.hibernate.exception.SQLGrammarException: could not execute query)
org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:407)
org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:324)
org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getDefaultTenant(PlatformServiceImpl.java:483)
org.bonitasoft.engine.api.impl.transaction.platform.GetDefaultTenantInstance.execute(GetDefaultTenantInstance.java:36)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
org.bonitasoft.engine.api.impl.LoginAPIImpl.getDefaultTenant(LoginAPIImpl.java:111)
org.bonitasoft.engine.api.impl.LoginAPIImpl.login(LoginAPIImpl.java:58)
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:239)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
com.sun.proxy.$Proxy4.login(Unknown Source)
org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:199)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.getTenantId(AuthorizationFilter.java:87)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:65)
org.bonitasoft.console.common.server.sso.filter.SSOFilter.doFilter(SSOFilter.java:103)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
java.lang.Thread.run(Thread.java:722)
.Caused By:(org.hibernate.exception.SQLGrammarException: could not execute query)
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2545)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
org.hibernate.loader.Loader.list(Loader.java:2271)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:399)
org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:324)
org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getDefaultTenant(PlatformServiceImpl.java:483)
org.bonitasoft.engine.api.impl.transaction.platform.GetDefaultTenantInstance.execute(GetDefaultTenantInstance.java:36)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
org.bonitasoft.engine.api.impl.LoginAPIImpl.getDefaultTenant(LoginAPIImpl.java:111)
org.bonitasoft.engine.api.impl.LoginAPIImpl.login(LoginAPIImpl.java:58)
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:239)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
com.sun.proxy.$Proxy4.login(Unknown Source)
org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:199)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.getTenantId(AuthorizationFilter.java:87)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:65)
org.bonitasoft.console.common.server.sso.filter.SSOFilter.doFilter(SSOFilter.java:103)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
java.lang.Thread.run(Thread.java:722)
.Caused By:(could not execute query)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:811)
sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
com.sun.proxy.$Proxy3.executeQuery(Unknown Source)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
org.hibernate.loader.Loader.doQuery(Loader.java:802)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
org.hibernate.loader.Loader.doList(Loader.java:2542)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
org.hibernate.loader.Loader.list(Loader.java:2271)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:399)
org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:324)
org.bonitasoft.engine.platform.impl.PlatformServiceImpl.getDefaultTenant(PlatformServiceImpl.java:483)
org.bonitasoft.engine.api.impl.transaction.platform.GetDefaultTenantInstance.execute(GetDefaultTenantInstance.java:36)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:53)
org.bonitasoft.engine.execution.TransactionExecutorImpl.execute(TransactionExecutorImpl.java:40)
org.bonitasoft.engine.api.impl.LoginAPIImpl.getDefaultTenant(LoginAPIImpl.java:111)
org.bonitasoft.engine.api.impl.LoginAPIImpl.login(LoginAPIImpl.java:58)
sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:601)
org.bonitasoft.engine.commons.ClassReflector.invokeMethod(ClassReflector.java:170)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:239)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:78)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:72)
com.sun.proxy.$Proxy4.login(Unknown Source)
org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:199)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.getTenantId(AuthorizationFilter.java:87)
org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:65)
org.bonitasoft.console.common.server.sso.filter.SSOFilter.doFilter(SSOFilter.java:103)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.