It's all about the answers!

Ask a question

The server status cannot be retrieved.ID CRJAZ1505E


RTC User Prime (215) | asked Jun 14 '22, 8:16 a.m.

 Currently using CLM 5.0.6 with SQL 2012. Recently there were some changes from the DB team with the below 

Protocol and Ciphers to Disable:

  1. TLS 1.0
  2. TLS 1.1
  3. DES
  4. Triple DES

Since the change the below error is seen in all the applications. 
JTS 
The "com.ibm.team.repository.service.internal.discovery.FriendsAdminRestService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.IServerDescriptionService", failed to be activated.ID CRJAZ1972E
com.ibm.team.repository.common.transport.TeamServiceRegistryException
Caused by:
The "com.ibm.team.repository.service.internal.ServerDescriptionService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.IBaseServerDescriptionService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
Caused by:
The "com.ibm.team.repository.service.internal.BaseServerDescriptionService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.mapping.internal.IInternalPrefixUrlLockService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
Caused by:
The "com.ibm.team.repository.service.mapping.internal.DatabasePrefixUrlLockService" 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
Caused by:
The "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" feature could not start. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1092E
Caused by:
The system schema could not be created. (java.lang.RuntimeException)ID CRJAZ0820E
Caused by:
The server was unable to connect to the database. Exception: "CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information." (com.ibm.team.repository.common.TeamRepositoryException)ID CRJAZ0503E
Caused by:
The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information. (java.sql.SQLException)ID CRJAZ2654E


Tried a perform a DB start as per the below, which did not help either.

The teamserver.properties is below.
com.ibm.team.repository.user.registry.type=UNSUPPORTED
com.ibm.team.datawarehouse.db.net.port=1527
com.ibm.team.repository.db.jdbc.location=//<DB>\:1428;databaseName\=jts;user\=jtsDBuser;password\={password}
com.ibm.team.lpa.storage.area.label=Jazz Lifecycle Project Administration
com.ibm.team.repository.db.jdbc.pool.wait=6000
com.ibm.team.repository.db.jdbc.password=[OCVcgD1sfdE3L/ZfFbgbWg\=\=]
com.ibm.team.jfs.index.root.directory=indices
com.ibm.team.repository.changeEvent.expirationDefault=1209600
com.ibm.team.repository.server.webapp.url=https\://clmtest\:9443/jts
com.ibm.team.repository.db.repoLockId=_WNS48Gl7EeiDrqI6-eZhAw
com.ibm.team.lpa.storage.area.name=com.ibm.team.lpa.10f3dac2-38c5-4ff2-86f6-a6faaa63f60a
com.ibm.team.repository.completed.setup=true
com.ibm.team.datawarehouse.db.vendor=sqlserver
com.ibm.team.repository.ws.allow.admin.access=false
com.ibm.team.repository.licenseService.floatingLicenseServerURI=https\://clmtest\:9443/jts/
com.ibm.team.repository.web.suppressedPages={"com.ibm.team.repository.web.admin"\: ["com.ibm.team.repository.provision"]}
com.ibm.team.repository.db.timezone=Asia/Riyadh
com.ibm.team.datawarehouse.db.jdbc.password=[OCVcgD1sfdE3L/ZfFbgbWg\=\=]
com.ibm.team.repository.db.vendor=sqlserver
com.ibm.team.repository.web.helpuri=/clmhelp/index.jsp
com.ibm.team.repository.lastChange=/dcc,UPDATED,1528284266583
com.ibm.team.datawarehouse.db.automatic.setup=true
com.ibm.team.fulltext.indexLocation=conf/jts/indices/workitemindex
com.ibm.team.datawarehouse.db.jdbc.location=//<DB>\:1428;databaseName\=dw;user\=DWuser;password\={password}
com.ibm.team.datawarehouse.db.base.folder=G\:\Database_Data
com.ibm.team.repository.ws.allow.identity.assertion=false
com.ibm.team.repository.changeEvent.expirationByCategory=SystemLog\:259200
com.ibm.team.repository.default.licenseid.list=
com.ibm.team.datawarehouse.datawarehouse.jobs.enabled=true
com.ibm.team.repository.setup.completed.setup=true

Any specific change needs to be done on the file. 

One answer



permanent link
Ralph Schoon (63.3k33646) | answered Jun 14 '22, 8:24 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 For all I can tell, you broke the connection to the database. I am pretty sure that 6.0.5 does support TLS 1.1 but not TLS 1.2.


This is nothing that can be solved in the forum. Open a case with support. 

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.