Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Hello,everybody.Please help me to solve a jazz on the issue

I am the one-China jazzuser,just beginning to learn jazz.I am in accordance with the tutorial Web site to install the database encountered a problem.

the tutorial's name is:Building a Jazz Repository database

I want to use repotools (command-line) to build a database at my local computer. My database is Oracle database.

So I create a new file named teamserver.properties:

the content of the file like this:

###############################################################################
# Licensed Materials - Property of IBM
# (c) Copyright IBM Corporation 2005, 2008. All Rights Reserved.
#
# Note to U.S. Government Users Restricted Rights:
# Use, duplication or disclosure restricted by GSA ADP Schedule
# Contract with IBM Corp.
###############################################################################
# Properties file for configuring IBM Team Server

# Database settings

#
# DERBY Configuration
#

# JDBC DB location, specifying this property disables system-based selection of default location
#com.ibm.team.repository.db.vendor = DERBY
#com.ibm.team.repository.db.jdbc.location = repositoryDB

#
# DB2 configuration
#

# Comment out above lines, uncomment the following three lines and customize example location to use DB2
#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

#
# Oracle configuration
#

# Comment out above lines, uncomment the following three lines and customize example location to use Oracle
com.ibm.team.repository.db.vendor = ORACLE
# localhost connection strings should not include preceding //
com.ibm.team.repository.db.jdbc.location=thin:jazzDeveloper/{password}@localhost:1521/TXC
# non-localhost connection strings MUST include preceding //
#com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL
com.ibm.team.repository.db.jdbc.password=jazzDeveloper

#
# DB2i configuration
#

# Comment out above lines, uncomment the following three lines and customize example location to use DB2i
#com.ibm.team.repository.db.vendor = DB2i
#com.ibm.team.repository.db.jdbc.location=//hostname;hold statements=true;user=jazzDBuser;password={password};
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

#
# DB2z configuration
#

# Comment out above lines, uncomment the following lines and customize example location to use DB2z
#com.ibm.team.repository.db.vendor = db2z

# Location name of the DB2z sub-system.
# ipAddress, ipPort and location be obtained by running the DB2 command -DISPLAY DDF
#com.ibm.team.repository.db.jdbc.location=//ipAddress:ipPort/location:fullyMaterializeLobData=false;user=jazzDBuser;password={password};
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

# DB2z Database name
#com.ibm.team.repository.db.db2.dsn.dbname=JAZZDB

# DB2z Bufferpool name
#com.ibm.team.repository.db.db2.dsn.bufferpool=bpx

# DB2z Storage Group name
#com.ibm.team.repository.db.db2.dsn.stogroup=JAZZSTG

#
# J2EE database connection example
#
#com.ibm.team.repository.db.type = J2EE
#com.ibm.team.repository.db.vendor=<VENDOR>
#com.ibm.team.repository.db.j2ee.dataSource = /jdbc/jazz

# Setting this value to 'true' opens a wide security hole. Only set it to 'true'
# in development time, when security isn't important and the developer
# doesn't wish to spend time configuring true J2EE authentication.
com.ibm.team.repository.ws.allow.identity.assertion = false

# Used for product packaging
com.ibm.team.repository.web.pageorder = {"com.ibm.team.repository.web.admin": \
, \
"com.ibm.team.process.web.projectArea": \
,\
"com.ibm.team.process.web.projectAreaList": \
}

com.ibm.team.repository.web.suppressedPages = {"com.ibm.team.repository.web.admin": \
}

com.ibm.team.repository.web.helpuri = http://publib.boulder.ibm.com/infocenter/rtc/v1r0m0/index.jsp

#
# Freshness specification, in seconds, for ChangeEvent scrubbing. Items older than this are
# deleted from the database. For the itemTypes WorkItem and BuildResult (as specified in
# "changeEvent.expirationByType") freshness spec is 60 days and 2 days, respectively. The
# default age, (as specified in "changeEvent.expirationDefault") is 14 days.
#
# All times must be represented in seconds.
#
# Values for the "changeEvent.expirationByType" and "changeEvent.expirationByCategory"
# properties are space-delimited. Each value is a tuple of
# itemType shortName or longName, separated by ':', followed by a maxage
# value in seconds. Whitespace is not allowed between the itemType, ':', and
# maxage value. For "expirationByCategory", "itemType" is replaced by a category
# string, as would be found in the category field of ChangeEvent.
#
com.ibm.team.repository.changeEvent.expirationDefault = 1209600
com.ibm.team.repository.changeEvent.expirationByType = com.ibm.team.workitem.WorkItem:5184000 com.ibm.team.build.BuildResult:172800
com.ibm.team.repository.changeEvent.expirationByCategory = SystemLog:259200

# Fulltest index location
com.ibm.team.fulltext.indexLocation=workitemindex





I use the DOS command like this:
..\repotools.bat -createTables teamserver.properties=teamserver.properties



In the course of reported errors is as follows:

F:\>cd jazz\server\jazztalk

F:\jazz\server\jazztalk>..\repotools.bat -createTables teamserver.properties=tea
mserver.properties
Repo Tools, Version 1.0 - I20080618-1642
Provisioning using "F:\jazz\server\\provision_profiles".
Rational Jazz Team Server - Express-C ()
Loading configuration from "file:teamserver.properties".
CRJAZ1093I Service failed to activate.
CRJAZ1126I The service "com.ibm.team.repository.service.internal.rdb.ConnectionP
oolService" had some invalid configuration properties:
CRJAZ1125I The configuration property value "ORACLE" is not valid for th
e property "db.vendor". The "ORACLE" database vendor is not supported by the ser
ver license.

The database tables were not created.



I hope that friends help me solve this problem, thank you

0 votes



3 answers

Permanent link
It sounds like you have missed one of the steps for setting up Oracle.
There is documentation on the setup at:
https://jazz.net/jazzdocs/topic/com.ibm.team.install.doc/topics/t_e_server_installation_setup_oracle.html

Specifically, I think you might have skipped steps 5b and 5c.

-
Matt Lavin
Jazz Server Team


On Fri, 2008-11-21 at 02:37 +0000, txctxc wrote:
I am the one-China jazzuser,just beginning to learn jazz.I am in
accordance with the tutorial Web site to install the database
encountered a problem.

the tutorial's name is:Building a Jazz Repository database

I want to use repotools (command-line) to build a database at my local
computer. My database is Oracle database.

So I create a new file named teamserver.properties:

the content of the file like this:

###############################################################################
# Licensed Materials - Property of IBM
# (c) Copyright IBM Corporation 2005, 2008. All Rights Reserved.
#
# Note to U.S. Government Users Restricted Rights:
# Use, duplication or disclosure restricted by GSA ADP Schedule
# Contract with IBM Corp.
###############################################################################
# Properties file for configuring IBM Team Server

# Database settings

#
# DERBY Configuration
#

# JDBC DB location, specifying this property disables system-based
selection of default location
#com.ibm.team.repository.db.vendor = DERBY
#com.ibm.team.repository.db.jdbc.location = repositoryDB

#
# DB2 configuration
#

# Comment out above lines, uncomment the following three lines and
customize example location to use DB2
#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

#
# Oracle configuration
#

# Comment out above lines, uncomment the following three lines and
customize example location to use Oracle
com.ibm.team.repository.db.vendor = ORACLE
# localhost connection strings should not include preceding //
com.ibm.team.repository.db.jdbc.location=thin:jazzDeveloper/{password}@localhost:1521/TXC
# non-localhost connection strings MUST include preceding //
#com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL
com.ibm.team.repository.db.jdbc.password=jazzDeveloper

#
# DB2i configuration
#

# Comment out above lines, uncomment the following three lines and
customize example location to use DB2i
#com.ibm.team.repository.db.vendor = DB2i
#com.ibm.team.repository.db.jdbc.location=//hostname;hold
statements=true;user=jazzDBuser;password={password};
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

#
# DB2z configuration
#

# Comment out above lines, uncomment the following lines and customize
example location to use DB2z
#com.ibm.team.repository.db.vendor = db2z

# Location name of the DB2z sub-system.
# ipAddress, ipPort and location be obtained by running the DB2
command -DISPLAY DDF
#com.ibm.team.repository.db.jdbc.location=//ipAddress:ipPort/location:fullyMaterializeLobData=false;user=jazzDBuser;password={password};
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

# DB2z Database name
#com.ibm.team.repository.db.db2.dsn.dbname=JAZZDB

# DB2z Bufferpool name
#com.ibm.team.repository.db.db2.dsn.bufferpool=bpx

# DB2z Storage Group name
#com.ibm.team.repository.db.db2.dsn.stogroup=JAZZSTG

#
# J2EE database connection example
#
#com.ibm.team.repository.db.type = J2EE
#com.ibm.team.repository.db.vendor=<VENDOR>cd jazz\server\jazztalk

F:\jazz\server\jazztalk>..\repotools.bat -createTables
teamserver.properties=tea
mserver.properties
Repo Tools, Version 1.0 - I20080618-1642
Provisioning using "F:\jazz\server\\provision_profiles".
Rational Jazz Team Server - Express-C ()
Loading configuration from "file:teamserver.properties".
CRJAZ1093I Service failed to activate.
CRJAZ1126I The service
"com.ibm.team.repository.service.internal.rdb.ConnectionP
oolService" had some invalid configuration properties:
CRJAZ1125I The configuration property value "ORACLE"
is not valid for th
e property "db.vendor". The "ORACLE" database
vendor is not supported by the ser
ver license.

The database tables were not created.



I hope that friends help me solve this
problem, thank you

0 votes


Permanent link
Thank you for lavinm's answer.
but My RTC is Free version.
This version does not seem to support the Oracle database.

Do not know if there is no solution.

0 votes


Permanent link
You are correct. The Express-C version of RTC does not support Oracle.
If you would like to test out the Oracle support in the Standard
edition, you can install and test it for 60-days for free.

-
Matt Lavin
Jazz Server Team


On Mon, 2008-11-24 at 05:17 +0000, txctxc wrote:
Thank you for lavinm's answer.
but My RTC is Free version.
This version does not seem to support the Oracle database.

Do not know if there is no solution.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,937

Question asked: Nov 20 '08, 9:29 p.m.

Question was seen: 7,410 times

Last updated: Nov 20 '08, 9:29 p.m.

Confirmation Cancel Confirm