It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×6,076
×5,819

question asked: Oct 12 '16, 11:45 p.m.
question was seen: 2,015 times
last updated: Aug 17 '17, 3:27 p.m.

Related questions

FAQ - How this Forum works

IBM DOORS 6 - MSSQL jts Create Tables failed

0
Reqman MD (13●3) | asked Oct 12 '16, 11:45 p.m.
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

0
permanent link
Paul Ellis (1.3k●6●13) | answered Oct 13 '16, 5:27 a.m.
JAZZ DEVELOPER 
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
Comments
Reqman MD commented Oct 14 '16, 4:17 a.m. | edited Oct 14 '16, 4:19 a.m.

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

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Daryl Walters (21●1●8) | answered Aug 17 '17, 3:27 p.m.

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

Your answer

Register or 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.