IBM DOORS 6 - MSSQL jts Create Tables failed
On the interactive wizard, SQLDB connection is successful. But when try to create tables it gives me this error:
The "com.ibm.team.repository.service.internal.DatabaseCreationRestService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService", failed to be activated.ID CRJAZ1972E
com.ibm.team.repository.common.transport.TeamServiceRegistryException
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:384)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:753)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:292)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:301)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getServiceForRemoteAccess(OsgiServicesManager.java:696)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2433)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2315)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1794)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:138)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1287)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:778)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:150)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:93)
com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:207)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1020)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1142)
com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4867)
com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.handleRequest(DynamicVirtualHost.java:297)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:997)
com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:262)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:955)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:341)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:470)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:404)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:284)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:255)
com.ibm.ws.channel.ssl.internal.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1017)
com.ibm.ws.channel.ssl.internal.SSLConnectionLink.readyInboundPostHandshake(SSLConnectionLink.java:703)
com.ibm.ws.channel.ssl.internal.SSLConnectionLink$MyHandshakeCompletedCallback.complete(SSLConnectionLink.java:391)
com.ibm.ws.channel.ssl.internal.SSLUtils.handleHandshake(SSLUtils.java:942)
com.ibm.ws.channel.ssl.internal.SSLHandshakeIOCallback.complete(SSLHandshakeIOCallback.java:88)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:929)
com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1018)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627)
java.lang.Thread.run(Thread.java:809)
Caused by:
The "com.ibm.team.repository.service.internal.rdb.DatabaseStateService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.schemagen.IPersistentMappingService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:384)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:753)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:292)
... 52 more.
Caused by:
The "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" feature could not start. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1092E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:303)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.performActivation(AbstractActivationManagerOwner.java:704)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:766)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:212)
... 119 more.
Caused by:
The system schema could not be created. (java.lang.RuntimeException)ID CRJAZ0820E
com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.reset(PersistentMappingService.java:128)
com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:92)
com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:195)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:297)
... 122 more.
Caused by:
!SqlServerProvider.SqlServerVersionNotValid! (com.ibm.team.repository.common.TeamRepositoryException)
com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.assertRequiredVersion(SqlServerProvider.java:601)
com.ibm.team.repository.service.db.provider.AbstractDbProvider.assertRequiredVersion(AbstractDbProvider.java:1608)
com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDbVersion(AbstractDbProvider.java:1667)
com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDbVersion(AbstractDbProvider.java:1660)
... 141 more.Also when I try on cmd, it gives this error:
c:\Program Files\IBM\JazzTeamServer\server>repotools-jts -createTables
Repo Tools
Provisioning using "c:\Program Files\IBM\JazzTeamServer\server\conf\jts\provision_profiles".
To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum.
To find more information about a message, see the online product documentation.
CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1365I The server is attempting to connect to the following database: "//localhost:1433;databaseName=jts;user=xxxxxx
xx;password=xxxxxxxx"
CRJAZ1093E The "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" feature could not start.
CRJAZ1779I This server is configured as a JTS.
CRJAZ2558I Setting the local server rename state to false and the openServerDescriptionServiceTemporarily state to false
.
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.IServerDescriptionService".
CRJAZ2448I The public url property is not set. This is used to determine the running state of the server. The repotools
command will skip this check and continue processing the command.
CRJAZ1728E A Repository Tools error occurred. For more information, see this log file: c:\Program Files\IBM\JazzTeamServ
er\server\repotools-jts_createTables.log
Accepted answer
Hi,
The final caused by above is stating: SqlServerVersionNotValid -
If you see the 6.0.2 System Requirements for CLM (RDNG) then is states:
SQL Server 2012 and 2014.
So are you using a different version? You could potentially override this with a teamserver.properties entry, but
I would not recommend it. If you can confirm the version you're using then I can advise further.
Kind regards,
Paul