repoTools -createTables fails with error 2.0M3(I200904101131

Sorry, another post about an error running repoTools this time using the
2.0 M3 (I20090410-1131) build

I tried to run repotools -createTables teamserver.properties=<myfile>

Error I see is (see below)
*Note I did not run the command with fullyMaterializeLobData because that would cause errors in itself.

---------------------------
Microsoft Windows XP
(C) Copyright 1985-2001 Microsoft Corp.

D:\ram\rtcSS0410Express\jazz\server>repotools.bat -createTables teamserver.prope
rties=teamserver.properties
Repo Tools
Jazz Foundation Server, Version 2.0 M3 (I20090410-1131)

Provisioning using "D:\ram\rtcSS0410Express\jazz\server\\provision_profiles".
Rational Jazz Team Server - Express
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //localhost:50000/JAZZ0406:user=xxxxxxxx;password=xxxxxxxx;
Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09050
Db URL: jdbc:db2://localhost:50000/JAZZ0406
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//localhost:50000/JAZZ0406:user=xxxxxxxx;p
assword=xxxxxxxx;" with indices.
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep
aring or executing statement => CREATE TABLE LINKS.AUDITABLE_LINK(STATE_ID CHAR(
23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, NAME_COL VARCHAR(250)
NOT NULL, SOURCE_REF_INTERNAL_ID CHAR(23) NOT NULL, SOURCE_REF_URI VARCHAR(1000
), SOURCE_REF_REFERENCE_TYPE INTEGER NOT NULL, SOURCE_REF_REFERENCED_ITM_TM_D CH
AR(23), JZ_REFERENCED_ITEM_DISCRIMINTR INTEGER, SOURCE_REF_COMMENT VARCHAR(250),
SOURCE_REF_REFERENCE_SIDE INTEGER NOT NULL, SOURCE_REF_EXTRA_INFO VARCHAR(1000)
, SOURCE_REF_CONTENT_TYPE VARCHAR(250), TARGET_REF_INTERNAL_ID CHAR(23) NOT NULL
, TARGET_REF_URI VARCHAR(1000), TARGET_REF_REFERENCE_TYPE INTEGER NOT NULL, TARG
ET_REF_REFERENCED_ITM_TM_D CHAR(23), JZ_REFERENCED_ITEM_DISCRIMNTR INTEGER, TARG
ET_REF_COMMENT VARCHAR(250), TARGET_REF_REFERENCE_SIDE INTEGER NOT NULL, TARGET_
REF_EXTRA_INFO VARCHAR(1000), TARGET_REF_CONTENT_TYPE VARCHAR(250))
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep
aring or executing statement => CREATE TABLE LINKS.AUDITABLE_LINK(STATE_ID CHAR(
23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, NAME_COL VARCHAR(250)
NOT NULL, SOURCE_REF_INTERNAL_ID CHAR(23) NOT NULL, SOURCE_REF_URI VARCHAR(1000
), SOURCE_REF_REFERENCE_TYPE INTEGER NOT NULL, SOURCE_REF_REFERENCED_ITM_TM_D CH
AR(23), JZ_REFERENCED_ITEM_DISCRIMINTR INTEGER, SOURCE_REF_COMMENT VARCHAR(250),
SOURCE_REF_REFERENCE_SIDE INTEGER NOT NULL, SOURCE_REF_EXTRA_INFO VARCHAR(1000)
, SOURCE_REF_CONTENT_TYPE VARCHAR(250), TARGET_REF_INTERNAL_ID CHAR(23) NOT NULL
, TARGET_REF_URI VARCHAR(1000), TARGET_REF_REFERENCE_TYPE INTEGER NOT NULL, TARG
ET_REF_REFERENCED_ITM_TM_D CHAR(23), JZ_REFERENCED_ITEM_DISCRIMNTR INTEGER, TARG
ET_REF_COMMENT VARCHAR(250), TARGET_REF_REFERENCE_SIDE INTEGER NOT NULL, TARGET_
REF_EXTRA_INFO VARCHAR(1000), TARGET_REF_CONTENT_TYPE VARCHAR(250))
CRJAZ0487I An exception occurred while creating the database schema for the pack
age "com.ibm.team.links".
The database tables were not created.

Note that 0410 is one of the intermediate builds. M3 is releasing end of this week.

Anyway, your problem is the db is created with 4K page size. You need to drop and recreate the db with 8K.

This problem is fixed last week. If you pick up one of the M3 builds this week, you will get a warning message about database created with 4K page size.

--- Balaji

Sorry, another post about an error running repoTools this time using the
2.0 M3 (I20090410-1131) build

I tried to run repotools -createTables teamserver.properties=<myfile>

Error I see is (see below)
*Note I did not run the command with fullyMaterializeLobData because that would cause errors in itself.

---------------------------
Microsoft Windows XP
(C) Copyright 1985-2001 Microsoft Corp.

D:\ram\rtcSS0410Express\jazz\server>repotools.bat -createTables teamserver.prope
rties=teamserver.properties
Repo Tools
Jazz Foundation Server, Version 2.0 M3 (I20090410-1131)

Provisioning using "D:\ram\rtcSS0410Express\jazz\server\\provision_profiles".
Rational Jazz Team Server - Express
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //localhost:50000/JAZZ0406:user=xxxxxxxx;password=xxxxxxxx;
Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09050
Db URL: jdbc:db2://localhost:50000/JAZZ0406
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//localhost:50000/JAZZ0406:user=xxxxxxxx;p
assword=xxxxxxxx;" with indices.
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep
aring or executing statement => CREATE TABLE LINKS.AUDITABLE_LINK(STATE_ID CHAR(
23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, NAME_COL VARCHAR(250)
NOT NULL, SOURCE_REF_INTERNAL_ID CHAR(23) NOT NULL, SOURCE_REF_URI VARCHAR(1000
), SOURCE_REF_REFERENCE_TYPE INTEGER NOT NULL, SOURCE_REF_REFERENCED_ITM_TM_D CH
AR(23), JZ_REFERENCED_ITEM_DISCRIMINTR INTEGER, SOURCE_REF_COMMENT VARCHAR(250),
SOURCE_REF_REFERENCE_SIDE INTEGER NOT NULL, SOURCE_REF_EXTRA_INFO VARCHAR(1000)
, SOURCE_REF_CONTENT_TYPE VARCHAR(250), TARGET_REF_INTERNAL_ID CHAR(23) NOT NULL
, TARGET_REF_URI VARCHAR(1000), TARGET_REF_REFERENCE_TYPE INTEGER NOT NULL, TARG
ET_REF_REFERENCED_ITM_TM_D CHAR(23), JZ_REFERENCED_ITEM_DISCRIMNTR INTEGER, TARG
ET_REF_COMMENT VARCHAR(250), TARGET_REF_REFERENCE_SIDE INTEGER NOT NULL, TARGET_
REF_EXTRA_INFO VARCHAR(1000), TARGET_REF_CONTENT_TYPE VARCHAR(250))
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep
aring or executing statement => CREATE TABLE LINKS.AUDITABLE_LINK(STATE_ID CHAR(
23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, NAME_COL VARCHAR(250)
NOT NULL, SOURCE_REF_INTERNAL_ID CHAR(23) NOT NULL, SOURCE_REF_URI VARCHAR(1000
), SOURCE_REF_REFERENCE_TYPE INTEGER NOT NULL, SOURCE_REF_REFERENCED_ITM_TM_D CH
AR(23), JZ_REFERENCED_ITEM_DISCRIMINTR INTEGER, SOURCE_REF_COMMENT VARCHAR(250),
SOURCE_REF_REFERENCE_SIDE INTEGER NOT NULL, SOURCE_REF_EXTRA_INFO VARCHAR(1000)
, SOURCE_REF_CONTENT_TYPE VARCHAR(250), TARGET_REF_INTERNAL_ID CHAR(23) NOT NULL
, TARGET_REF_URI VARCHAR(1000), TARGET_REF_REFERENCE_TYPE INTEGER NOT NULL, TARG
ET_REF_REFERENCED_ITM_TM_D CHAR(23), JZ_REFERENCED_ITEM_DISCRIMNTR INTEGER, TARG
ET_REF_COMMENT VARCHAR(250), TARGET_REF_REFERENCE_SIDE INTEGER NOT NULL, TARGET_
REF_EXTRA_INFO VARCHAR(1000), TARGET_REF_CONTENT_TYPE VARCHAR(250))
CRJAZ0487I An exception occurred while creating the database schema for the pack
age "com.ibm.team.links".
The database tables were not created.

I ran this command (got it from RTC 1011 install instructions page)

"db2 create database JAZZ on c: using codeset UTF-8 territory en"

to create the database, Is the command changed now ?

Note that 0410 is one of the intermediate builds. M3 is releasing end of this week.

Anyway, your problem is the db is created with 4K page size. You need to drop and recreate the db with 8K.

This problem is fixed last week. If you pick up one of the M3 builds this week, you will get a warning message about database created with 4K page size.

--- Balaji

Sorry, another post about an error running repoTools this time using the
2.0 M3 (I20090410-1131) build

I tried to run repotools -createTables teamserver.properties=<myfile>

Error I see is (see below)
*Note I did not run the command with fullyMaterializeLobData because that would cause errors in itself.

---------------------------
Microsoft Windows XP
(C) Copyright 1985-2001 Microsoft Corp.

D:\ram\rtcSS0410Express\jazz\server>repotools.bat -createTables teamserver.prope
rties=teamserver.properties
Repo Tools
Jazz Foundation Server, Version 2.0 M3 (I20090410-1131)

Provisioning using "D:\ram\rtcSS0410Express\jazz\server\\provision_profiles".
Rational Jazz Team Server - Express
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //localhost:50000/JAZZ0406:user=xxxxxxxx;password=xxxxxxxx;
Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09050
Db URL: jdbc:db2://localhost:50000/JAZZ0406
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//localhost:50000/JAZZ0406:user=xxxxxxxx;p
assword=xxxxxxxx;" with indices.
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep
aring or executing statement => CREATE TABLE LINKS.AUDITABLE_LINK(STATE_ID CHAR(
23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, NAME_COL VARCHAR(250)
NOT NULL, SOURCE_REF_INTERNAL_ID CHAR(23) NOT NULL, SOURCE_REF_URI VARCHAR(1000
), SOURCE_REF_REFERENCE_TYPE INTEGER NOT NULL, SOURCE_REF_REFERENCED_ITM_TM_D CH
AR(23), JZ_REFERENCED_ITEM_DISCRIMINTR INTEGER, SOURCE_REF_COMMENT VARCHAR(250),
SOURCE_REF_REFERENCE_SIDE INTEGER NOT NULL, SOURCE_REF_EXTRA_INFO VARCHAR(1000)
, SOURCE_REF_CONTENT_TYPE VARCHAR(250), TARGET_REF_INTERNAL_ID CHAR(23) NOT NULL
, TARGET_REF_URI VARCHAR(1000), TARGET_REF_REFERENCE_TYPE INTEGER NOT NULL, TARG
ET_REF_REFERENCED_ITM_TM_D CHAR(23), JZ_REFERENCED_ITEM_DISCRIMNTR INTEGER, TARG
ET_REF_COMMENT VARCHAR(250), TARGET_REF_REFERENCE_SIDE INTEGER NOT NULL, TARGET_
REF_EXTRA_INFO VARCHAR(1000), TARGET_REF_CONTENT_TYPE VARCHAR(250))
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error prep
aring or executing statement => CREATE TABLE LINKS.AUDITABLE_LINK(STATE_ID CHAR(
23) NOT NULL, ITEM_ID CHAR(23) NOT NULL, CONTEXT_ID CHAR(23) NOT NULL, MODIFIED
TIMESTAMP NOT NULL, MODIFIED_BY_ITEM_ID CHAR(23) NOT NULL, NAME_COL VARCHAR(250)
NOT NULL, SOURCE_REF_INTERNAL_ID CHAR(23) NOT NULL, SOURCE_REF_URI VARCHAR(1000
), SOURCE_REF_REFERENCE_TYPE INTEGER NOT NULL, SOURCE_REF_REFERENCED_ITM_TM_D CH
AR(23), JZ_REFERENCED_ITEM_DISCRIMINTR INTEGER, SOURCE_REF_COMMENT VARCHAR(250),
SOURCE_REF_REFERENCE_SIDE INTEGER NOT NULL, SOURCE_REF_EXTRA_INFO VARCHAR(1000)
, SOURCE_REF_CONTENT_TYPE VARCHAR(250), TARGET_REF_INTERNAL_ID CHAR(23) NOT NULL
, TARGET_REF_URI VARCHAR(1000), TARGET_REF_REFERENCE_TYPE INTEGER NOT NULL, TARG
ET_REF_REFERENCED_ITM_TM_D CHAR(23), JZ_REFERENCED_ITEM_DISCRIMNTR INTEGER, TARG
ET_REF_COMMENT VARCHAR(250), TARGET_REF_REFERENCE_SIDE INTEGER NOT NULL, TARGET_
REF_EXTRA_INFO VARCHAR(1000), TARGET_REF_CONTENT_TYPE VARCHAR(250))
CRJAZ0487I An exception occurred while creating the database schema for the pack
age "com.ibm.team.links".
The database tables were not created.