Installation Problem
I'm evaluating RTC Standard 2.0.0.2i3, and I'm following the instructions for installing RTC server on Windows with Oracle. I get a successful DB connection, but then I get a failure when executing the "Create Tables" step (error below). The only reference to this message ID on the web is http://www-01.ibm.com/support/docview.wss?uid=swg21418911, which relates to Derby, not Oracle.
If I click on the "Test Connection" button I get The database exists, but is not configured to contain Jazz. Use the "Create Tables" button in Step 2.3 to configure the database for Jazz. I have verified that I can connect to the Oracle user with the configured username and password (using SQLDeveloper), and that it has the required permissions as described in the setup instructions. I have a short deadline for a presentation to Management, and really need to get past this point. Suggestions? CRJAZ1173I Service "com.ibm.team.repository.service.internal.IDatabaseCreationRestService" is not available. |
7 answers
Ralph Schoon (63.7k●3●36●47)
| answered Aug 12 '10, 5:05 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,
hard to tell what the issue is. did you follow the instruction on how to setup the Oracle DB? Have you looked into the ORACLE log files? You can also use the repotools -createTable command in a console. Maybe this gives you more information. Also in the past it was the best way to start with the teamserver.oracle.properties, copy it to teamserver.properties, edit it that manually to provide the connection infos needed for your DB and run repotools -createTables before running the Web setup app. Just some options, Ralph I'm evaluating RTC Standard 2.0.0.2i3, and I'm following the instructions for installing RTC server on Windows with Oracle. I get a successful DB connection, but then I get a failure when executing the "Create Tables" step (error below). The only reference to this message ID on the web is http://www-01.ibm.com/support/docview.wss?uid=swg21418911, which relates to Derby, not Oracle. |
Here's the output from repotools -createTables. The system is a Core i7-920, 12GB, Win7pro-x64
C:\rtc\jazz\server>repotools -createTables |
As a test I also tried different versions of the Oracle JDBC drivers:
ojdbc14.jar ojdbc5.jar ojdbc6.jar The only one that was able to connect to the database was ojdbc14.jar. |
Fails with SQLServer also. Again, I have verified that I can connect to the DB (MSSQLServer on localhost this time), and the messages indicate that the initial connection is successful:
C:\rtc\jazz\server>repotools -createTables Repo Tools Rational Team Concert, Version 2.0.0.2 iFix 3 (I20100602-1000) Jazz Foundation - Jazz Team Server, Version 1.0.0.2 iFix 3 (I20100602-1000) Rational Jazz Team Server - Standard CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties". CRJAZ1365I Attempting Initial Database Connection Using Db Name/Location: //localhost:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx; CRJAZ1364I Initial database connection successful Db Product Name: Microsoft SQL Server Db Product Version: 10.00.2531 Db URL: jdbc:sqlserver://localhost:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod =direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=j azz;applicationName=Microsoft SQL Server JDBC Driver; Jdbc Driver Name: Microsoft SQL Server JDBC Driver 3.0 Jdbc Driver Version: 3.0.1301.101 CRJAZ1093I Service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed to activate. CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService". CRJAZ1203I Could not determine the database location. CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService" is not available. Creating the tables for the database "//localhost:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;" with indices. CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseCreationService". CRJAZ1309I The database connectivity service is not ready. The database tables were not created. |
Ralph Schoon (63.7k●3●36●47)
| answered Aug 13 '10, 8:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,
this is strange. Could you anonymize you teamserver,properties and post it here. This indicates the database location can't be found. That you can't get it running for any DB could also indicate that the network does not allow the connection. Are there any logs on the ports? Anything in addition in the Jazz logs (server/logs)? Jdbc Driver Version: 3.0.1301.101 CRJAZ1093I Service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed to activate. CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService". CRJAZ1203I Could not determine the database location. CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService" is not available. Creating the tables for the database "//localhost:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;" with indices. CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseCreationService". |
I was able to get it working with Derby, nothing special required. That's not a usable long-term solution, obviously.
Here's a copy of my Oracle teamserver.properties (comments and blank lines removed) com.ibm.team.repository.db.vendor = ORACLE |
I filed a bug on this, (http://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=126065). The problem with Oracle is that it checks specifically for Oracle 10 and refuses to start if it finds Oracle 11. The solution is to add
com.ibm.team.repository.db.override.versioncheck=true to teamserver.properties. The problem with SQLServer seems to a codepage mismatch for which no solution is yet available. |
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.