repotools -createTables doesn't seem to work on RTC2.0 beta1
Steps
1. Download and unzip RTC-Standard-Server-2.0Beta1-Win.zip 2. Followed the link here https://jazz.net/help/rational-team-concert/1.0.1/topic/com.ibm.team.install.doc/topics/t_s_server_installation_setup_db2.html a) I ran db2 create database JAZZ on c: using codeset UTF-8 territory en b) There was only one file called teamserver.properties (no teamserver.derby...). I commented the derby database properties, uncommented the db2 ones. c) com.ibm.team.repository.db.vendor = DB2 com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=db2admin;password={password}; com.ibm.team.repository.db.jdbc.password=db2admin # DB2 requires a path where the content tablespace should be created, examples for Win and Linux follow com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace # Configure the size of the tablespace to be created, in 4K pages. # This is a hard limit and will need to be raised for a production database. # Your DB2 DBA will need to monitor the utilization of the CONTENTS tablespace and grow it as needed. # Defaulting to 250,000 pages, or 1GB. com.ibm.team.repository.db.db2.content.tablespace.numpages=250000 d) ran repotools -createTables e) It failed. f) Here is the output D:\ram\rtcSS2beta1\jazz\server>repotools.bat -createTables Repo Tools, Version 2.0 M2 - I20090316-0438 Provisioning using "D:\ram\rtcSS2beta1\jazz\server\\provision_profiles". Rational Jazz Team Server - Standard Loading configuration from "file:teamserver.properties". Attempting Initial Database Connection Using Db Name/Location: //localhost:50000/JAZZ:fullyMaterializeLobData=false;user=xx xxxxxx;password=xxxxxxxx; CRJAZ0503I Failed to connect to the database: " jav a.util.Properties object passed to java.sql.Driver.connect() cannot be overridde n by URL: jdbc:db2://localhost:50000/JAZZ:fullyMaterializeLobData=false;user=db2 admin;password=db2admin;." Db Name/Location: "//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=x xxxxxxx;password=xxxxxxxx;" CRJAZ1093I Service failed to activate. CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r db.IDatabaseStateService". CRJAZ1203I Could not determine the database location. CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseSt ateService" is not available. Creating the tables for the database "//localhost:50000/JAZZ:fullyMaterializeLob Data=false;user=xxxxxxxx;password=xxxxxxxx;" with indices. CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r db.IDatabaseCreationService". CRJAZ1309I The database connectivity service is not ready. The database tables were not created. By the way can the output of the command be fixed to not print the password in clear text ? So I went back to RTC 1011 and retried the above steps and it worked. Here is my RTC 1011 output D:\ram\rtcSS1011\jazz\server>repotools.bat -createTables Repo Tools, Version 1.0.1.1 - M20090225-1543 Provisioning using "D:\ram\rtcSS1011\jazz\server\\provision_profiles". Rational Jazz Team Server - Standard Loading configuration from "file:teamserver.properties". Attempting Initial Database Connection Using Db Name/Location: //localhost:50000/JAZZ:fullyMaterializeLobData=false;user=xx xxxxxx;password=xxxxxxxx; Initial database connection successful Db Product Name: DB2/NT Db Product Version: SQL09050 Db URL: jdbc:db2://localhost:50000/JAZZ Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture Jdbc Driver Version: 3.6.60 CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\ Creating the tables for the database "//localhost:50000/JAZZ:fullyMaterializeLob Data=false;user=xxxxxxxx;password=xxxxxxxx;" with indices. The database tables were created successfully. |
One answer
Hi!
ramanday wrote: com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=db2admin;password={password}; A recent change had made the "fullyMaterializeLobData" parameter in the connection spec cause failures. You can see more details in work item 74941. To get past the problem, remove that parameter from your connection spec: com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password}; Thanks, Craig Chaney Jazz Server team |
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.