It's all about the answers!

Ask a question

Getting following error in Express setup "com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService". Error: CRJAZ2654E


Princi Verma (28115) | asked Nov 24 '16, 2:06 a.m.
edited Nov 24 '16, 3:49 a.m.
 Hi,

I am getting the following error during Express Setup after login into 'https://localhost:9443/jts' with user id & password both as  ADMIN -


An error occurred during property validation for service "com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService". Error: [CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08001, SQLCODE: 40000). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information.] Use the Custom Setup to run the setup instead of using the Express Setup.ID CRJAZ2258E


My teamserver.properties(server->conf->jts) file look like this ---

#This configuration update was requested by "myadmin".  The old contents of this file were copied to "C:\Users\A622734\SSCProject\RTC5Dev\installs\JazzTeamServer\server\conf\jts\teamserver-1479969862231bakup.properties".
#Thu Nov 24 12:14:22 IST 2016
com.ibm.team.repository.user.registry.type=DETECT
com.ibm.team.datawarehouse.db.net.port=
com.ibm.team.repository.db.jdbc.location=
com.ibm.team.repository.db.jdbc.password=[qoSGR4gvSUY\=]
com.ibm.team.repository.server.webapp.url=https\://localhost\:9443/jts
com.ibm.team.datawarehouse.db.vendor=DERBY
com.ibm.team.repository.ws.allow.admin.access=true
com.ibm.team.repository.db.vendor=DERBY
com.ibm.team.datawarehouse.db.jdbc.password=[qoSGR4gvSUY\=]
com.ibm.team.repository.db.type=JDBC
com.ibm.team.datawarehouse.datawarehouse.provider=Remote
com.ibm.team.datawarehouse.auth.userId=a426027ccdab44b2b035a6bf5e7b8f02
com.ibm.team.datawarehouse.auth.type=JTS
com.ibm.team.datawarehouse.auth.password=[n0akI9CI6LFUQ0CIGl3vsWyVTDYZwFervvQw/H5XyRs00LmTV4OUM6krzZs7PjoL]
com.ibm.team.datawarehouse.db.jdbc.location=
com.ibm.team.repository.db.repoLockId.skipCheck=true
com.ibm.team.repository.notification.mail.enabled=false
com.ibm.team.datawarehouse.db.type=JDBC


Please suggest some solution.


Now after doing the changes in datawarehouse port, repository location and datawarehouse location in the teamserver.properties i am getting error in Configure Email-Notification -

An error occurred while executing request "https://localhost:9443/jts/service/com.ibm.team.repository.service.internal.IServerConfigurationRestService/configurationValidation" Use the Custom Setup to run the setup instead of using the Express Setup.ID CRJAZ2594E



Below is the changes done by me in teamserver.properties file

#Thu Nov 24 12:46:59 IST 2016
com.ibm.team.repository.user.registry.type=DETECT
com.ibm.team.datawarehouse.db.net.port=1527
com.ibm.team.repository.db.jdbc.location=conf/jts/derby/repositoryDB
com.ibm.team.repository.db.jdbc.password=[qoSGR4gvSUY\=]
com.ibm.team.repository.server.webapp.url=https\://localhost\:9443/jts
com.ibm.team.datawarehouse.db.vendor=DERBY
com.ibm.team.repository.ws.allow.admin.access=true
com.ibm.team.repository.db.vendor=DERBY
com.ibm.team.datawarehouse.db.jdbc.password=[qoSGR4gvSUY\=]
com.ibm.team.repository.db.type=JDBC
com.ibm.team.datawarehouse.datawarehouse.provider=Remote
com.ibm.team.datawarehouse.auth.userId=a426027ccdab44b2b035a6bf5e7b8f02
com.ibm.team.datawarehouse.auth.type=JTS
com.ibm.team.datawarehouse.auth.password=[n0akI9CI6LFUQ0CIGl3vsWyVTDYZwFervvQw/H5XyRs00LmTV4OUM6krzZs7PjoL]
com.ibm.team.datawarehouse.db.jdbc.location=conf/jts/derby/warehouseDB
com.ibm.team.repository.db.repoLockId.skipCheck=true
com.ibm.team.repository.notification.mail.enabled=false
com.ibm.team.datawarehouse.db.type=JDBC


Please help.

Comments
Princi Verma commented Nov 24 '16, 2:07 a.m. | edited Nov 24 '16, 2:48 a.m.

Hi

In the teamserver.properties file I have changed "com.ibm.team.repository.ws.allow.admin.access=true" as true but was false.


Donald Nong commented Nov 24 '16, 2:47 a.m.

Is it the same issue as this one? If true, let's close one of them first.
https://jazz.net/forum/questions/231513/getting-error-in-express-setup-as-below


Donald Nong commented Nov 24 '16, 2:49 a.m.

Also, if you want to add clarification, modify the OP or add a comment. If you "answer" your own question, others may not look into it as it is already "answered".


Princi Verma commented Nov 24 '16, 3:55 a.m.

yes Donald this is the same question. We have deleted other question.

One answer



permanent link
Donald Nong (14.4k314) | answered Nov 24 '16, 4:26 a.m.
Did you change the teamserver.properties file before running the Express Setup? If so, it will not be Express Setup any more and you have to do Custom Setup. On the first screen, it clearly says the Express Setup will use the _default_ Derby database, which is conf/jts/derby/repositoryDB for the JTS DB and conf/jts/derby/warehouseDB for the data warehouse. For the data warehouse, you should have to following content in the teamserver.properties file.
com.ibm.team.datawarehouse.db.automatic.setup=true
com.ibm.team.datawarehouse.db.jdbc.location=conf/jts/derby/warehouseDB
com.ibm.team.datawarehouse.db.jdbc.password=[qoSGR4gvSUY\=]
com.ibm.team.datawarehouse.db.net.port=1527
com.ibm.team.datawarehouse.db.type=JDBC
com.ibm.team.datawarehouse.db.vendor=DERBY
BTW, don't use "localhost" for the public URI unless you enjoy using CLM on a single machine only. You can always add hostname to the hosts file to map to 127.0.0.1 even if you just want local access.

Comments
Princi Verma commented Nov 24 '16, 4:45 a.m. | edited Nov 24 '16, 4:54 a.m.

Hi Donald,

I didn't change the teamserver.properties file before running the Express Setup. I changed in the file when Express Setup was showing error in the last setup link that means in Configure Data Warehouse Database. After doing this it was showing me the error in Configure Email-Notification. But when I tried it again then the setup done successfully there is no error.


Your answer


Register or to post your answer.