Getting following error in Express setup "com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService". Error: CRJAZ2654E
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. |
One answer
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.
Comments
Hi
In the teamserver.properties file I have changed "com.ibm.team.repository.ws.allow.admin.access=true" as true but was false.
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
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".
yes Donald this is the same question. We have deleted other question.