Problem with Tomcat and SQL SERVER2008

1
0
-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#configdatas... ERROR : "Server Apache Tomcat v6.0 (2) at localhost failed to start."

Comments

Submitted by ttoine on Wed, 05/28/2014 - 12:03

what is your version of Bonita ?

Submitted by adityakhedikar on Wed, 05/28/2014 - 12:40

6.3

Submitted by christine.mckinty on Wed, 05/28/2014 - 14:08

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.

Submitted by adityakhedikar on Wed, 05/28/2014 - 14:17

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)

Submitted by christine.mckinty on Wed, 05/28/2014 - 14:28

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?

Submitted by adityakhedikar on Wed, 05/28/2014 - 14:58

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?

No answers yet.
Notifications