Problem with Tomcat and SQL SERVER2008

Q&A
1

I configured my SQL SERVER 2008 with steps in below link and i am getting below error at the start of Bonita.

link : http://documentation.bonitasoft.com/database-configuration-0#configdatasource
ERROR : “Server Apache Tomcat v6.0 (2) at localhost failed to start.”

2

what is your version of Bonita ?

3

6.3

4

Are there any other details in the Tomcat logs? It’s difficult to tell from just “failed to start” exactly where the problem might be.

5

now i moved from tomcat to jboss as its mentioned on bonita site is tomcat is not recommonded with sql server.

But Jboss is also giving problem.
showing

"500
org.bonitasoft.console.common.server.utils.DefaultTenantIdException

Oops. Error."

===============================
Here are the Jboss Logs

ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC
onnectionValve.java:158)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFi
xationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Unknown Source)
Caused by: org.bonitasoft.engine.platform.NodeNotStartedException: The current n
ode has not been started yet. Method PlatformAPI.startNode() must be called prev
iously.
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility
(ServerAPIImpl.java:292)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.
java:281)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIIm
pl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterce
ptor.java:88)
at $Proxy338.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.get
DefaultTenantId(TenantsManagementUtils.java:200)
… 36 more
17:42:39,130 ERROR [[homepage]] Servlet.service() for servlet homepage threw exc
eption
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:292)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.
java:281)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIIm
pl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterce
ptor.java:88)
at $Proxy338.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.get
DefaultTenantId(TenantsManagementUtils.java:200)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.getDefaul
tTenantId(TenantIdAccessor.java:52)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.ensureTen
antId(TenantIdAccessor.java:46)
at org.bonitasoft.console.common.server.login.filter.AutoLoginRule.doAut
horize(AutoLoginRule.java:31)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.isAuthorized(AuthorizationFilter.java:97)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.doAuthorizationFiltering(AuthorizationFilter.java:79)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.doFilter(AuthorizationFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter.doF
ilter(InternalSSOFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.SecurityFilter.doFi
lter(SecurityFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFil
ter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce
ss(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok
e(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC
onnectionValve.java:158)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFi
xationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Unknown Source)
17:42:40,583 ERROR [STDERR] Node not started. Method ‘org.bonitasoft.engine.api.
LoginAPI.login’ cannot be called until node has been started (PlatformAPI.startN
ode())
17:42:40,584 SEVERE [InternalSSOFilter] Can’t retrieve default tenant id
org.bonitasoft.console.common.server.utils.DefaultTenantIdException: Can’t retri
eve default tenant id
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.get
DefaultTenantId(TenantsManagementUtils.java:205)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.getDefaul
tTenantId(TenantIdAccessor.java:52)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.ensureTen
antId(TenantIdAccessor.java:46)
at org.bonitasoft.console.common.server.login.filter.AutoLoginRule.doAut
horize(AutoLoginRule.java:31)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.isAuthorized(AuthorizationFilter.java:97)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.doAuthorizationFiltering(AuthorizationFilter.java:79)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.doFilter(AuthorizationFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter.doF
ilter(InternalSSOFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.SecurityFilter.doFi
lter(SecurityFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFil
ter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce
ss(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok
e(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC
onnectionValve.java:158)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFi
xationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Unknown Source)
Caused by: org.bonitasoft.engine.platform.NodeNotStartedException: The current n
ode has not been started yet. Method PlatformAPI.startNode() must be called prev
iously.
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility
(ServerAPIImpl.java:292)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.
java:281)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIIm
pl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterce
ptor.java:88)
at $Proxy338.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.get
DefaultTenantId(TenantsManagementUtils.java:200)
… 36 more
17:42:40,592 ERROR [[homepage]] Servlet.service() for servlet homepage threw exc
eption
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:292)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.
java:281)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIIm
pl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterce
ptor.java:88)
at $Proxy338.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.get
DefaultTenantId(TenantsManagementUtils.java:200)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.getDefaul
tTenantId(TenantIdAccessor.java:52)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.ensureTen
antId(TenantIdAccessor.java:46)
at org.bonitasoft.console.common.server.login.filter.AutoLoginRule.doAut
horize(AutoLoginRule.java:31)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.isAuthorized(AuthorizationFilter.java:97)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.doAuthorizationFiltering(AuthorizationFilter.java:79)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter
.doFilter(AuthorizationFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter.doF
ilter(InternalSSOFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.SecurityFilter.doFi
lter(SecurityFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFil
ter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce
ss(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok
e(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC
onnectionValve.java:158)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFi
xationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Unknown Source)

6

I’m no expert, but I suspect the key it this:
Caused by: org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously.

What were you doing when you saw these errors?

Did you install with the JBoss bundle? Had you already done the database config when you got these errors? Can you try using the JBoss bundle with the default (h2) database, just as a test, and see if you get the same errors?

7

it is working excellent with default h2 database.
i want to use sql server 2008 as database but not able to do … trying 4m 2 days… any1 know how to do it?