Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

0 votes


Accepted answer

Permanent link
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

Reqman MD selected this answer as the correct answer

0 votes

Comments

Thanks Paul. I missed that error. Was doing a clean install from version 4. Forgot to check the system requirements.


One other answer

Permanent link

 What is the teamserver.properties value to override the SQL Server version issue?  

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,125

Question asked: Oct 12 '16, 11:45 p.m.

Question was seen: 2,521 times

Last updated: Aug 17 '17, 3:27 p.m.

Confirmation Cancel Confirm