The server status cannot be retrieved.ID CRJAZ1505E
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:
- TLS 1.0
- TLS 1.1
- DES
- 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.