It's all about the answers!

Ask a question

repotools -createTables doesn't seem to work on RTC2.0 beta1


Rajasimhan Mandayam (3811144) | asked Apr 03 '09, 2:14 p.m.
JAZZ DEVELOPER
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



permanent link
Craig Chaney (9212) | answered Apr 03 '09, 2:48 p.m.
JAZZ DEVELOPER
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


Register or to post 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.