It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,876

question asked: Apr 20 '09, 11:45 a.m.
question was seen: 5,741 times
last updated: Apr 20 '09, 11:45 a.m.

Related questions

repoTools -createTables fails with error 2.0M3(I200904101131

0
Rajasimhan Mandayam (381●1●14●4) | asked Apr 20 '09, 11:45 a.m.
JAZZ DEVELOPER
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.

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Balaji Krish (1.8k●1●2) | answered Apr 21 '09, 10:18 a.m.
JAZZ DEVELOPER
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.
0
permanent link
Rajasimhan Mandayam (381●1●14●4) | answered Apr 21 '09, 11:44 a.m.
JAZZ DEVELOPER
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.
0
permanent link
Balaji Krish (1.8k●1●2) | answered Apr 21 '09, 1:46 p.m.
JAZZ DEVELOPER
yes..it defaults to 4K page. Try
db2 create database JAZZ on c: using codeset UTF-8 territory en pagesize 8 K

--- Balaji
Jazz Server Team

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.

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.