repotools -createTable failure in M3D1

You need to use a database with 8k page size. I believe you are using the database with default page size (4k).

See bug https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/74765

--- Balaji
Jazz Server Team

While setting up a second installation to test M3D1 (1st instance is Beta1 and working fine), I get an error while creating db2 tables:

1 [C:\Program Files\IBM\JazzTeamServer_2.0_M3D1\server] repotools.bat -createTables

Repo Tools, Version 2.0 M3D1 - I20090327-1303

Provisioning using "C:\Program Files\IBM\JazzTeamServer_2.0_M3D1\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_1:user=xxxxxxxx;password=xxxxxxxx;

Initial database connection successful

  Db Product Name: DB2/NT

  Db Product Version: SQL09053

  Db URL: jdbc:db2://localhost:50000/JAZZ_1

  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_1:user=xxxxxxxx;password=xxxxxxxx;" with indices.

com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing 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, MODIFIEDTIMESTAMP 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 CHAR(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, TARGET_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 preparing 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, MODIFIEDTIMESTAMP 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, TARGET_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 package "com.ibm.team.links".

The database tables were not created.

Where can I look to understand what's going on?

I have my database created with 8K pagesize and i am getting this error. Any ideas ?

CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
Creating the tables for the database "//localhost:50000/RQM:user=xxxxxxxx;password=xxxxxxxx;" with indices.
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE TABLE LM.ABSTRACT_INSTANCE(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, FAMILY_ITEM_ID CHAR(23) NOT NULL, VISIBILITY BIGINT NOT NULL, JZ_DISCRIMINATOR INTEGER NOT NULL, CPU_CPU_CORES_INSTALLED INTEGER, CPU_CPU_DIES_INSTALLED INTEGER, CPU_CPU_SPEED INTEGER, CPU_CPU_COUNT INTEGER, CPU_CPU_MANUFACTURER VARCHAR(250), CPU_CPU_ARCHITECTURE_WIDTH VARCHAR(250), CPU_CPU_ARCHITECTURE VARCHAR(250), IP_INTERFACE_IP_V4_ADDRESS VARCHAR(250), IP_INTERFACE_IP_V6_ADDRESS VARCHAR(250), IP_INTERFACE_IP_V6_NOTATION_TP VARCHAR(250), IP_INTERFACE_NETMASK VARCHAR(250), IP_INTERFACE_SUBNET_ADDRESS VARCHAR(250), IP_INTERFACE_L2_INTERFACE_NAME VARCHAR(250), LAB_RESOURCE_INTERNAL_ID INTEGER, LAB_RESOURCE_CPU_ITEM_ID CHAR(23), LAB_RESOURCE_IP_ADDRESS VARCHAR(250), LAB_RESOURCE_MODEL VARCHAR(250), LAB_RESOURCE_MEMORY INTEGER, LAB_RESOURCE_OWNER_ITEM_ID CHAR(23), LAB_RESOURCE_GROUP_ITEM_ID CHAR(23), LAB_RESOURCE_NAME VARCHAR(250), LAB_RESOURCE_ADMIN_STATUS VARCHAR(250), LAB_RESOURCE_OP_STATUS VARCHAR(250), LAB_RESOURCE_DESCRIPTION VARCHAR(250), LAB_RESOURCE_PRIMARY_MAC_DDRSS VARCHAR(250), LAB_RESOURCE_SYSTEM_BUILD_UUID VARCHAR(250), LAB_RESOURCE_SYSTEM_ID VARCHAR(250), LAB_RESOURCE_SERIAL_NUMBER VARCHAR(250), LAB_RESOURCE_TOTAL_DISK_SIZE INTEGER, LAB_RESOURCE_FREE_DISK_SPACE INTEGER, LAB_RESOURCE_LOCATION VARCHAR(250), LAB_RESOURCE_MANUFACTURER VARCHAR(250), LAB_RESOURCE_MODEL_NUMBER VARCHAR(250), LAB_RESOURCE_NOTES VARCHAR(250), LAB_RESOURCE_VM_MEMORY_SIZE INTEGER, LAB_RESOURCE_VM_DISK_SIZE INTEGER, LAB_RESOURCE_VMID VARCHAR(250), LAB_RESOURCE_VM_STATE VARCHAR(250), LAB_RESOURCE_VM_FILE VARCHAR(250), LAB_RESOURCE_DATE_CREATED TIMESTAMP, LAB_RESOURCE_DATE_LAST_MODIFID TIMESTAMP, LAB_RESOURCE_IMAGE_TYPE VARCHAR(250), LAB_RESOURCE_CREATED_WTH_VM_TL VARCHAR(250), LAB_RESOURCE_VERSION_ITEM_ID CHAR(23), L2_INTERFACE_MTU INTEGER, L2_INTERFACE_SPEED INTEGER, L2_INTERFACE_HW_ADDRESS VARCHAR(250), L2_INTERFACE_LOOPBACK VARCHAR(250), OPERATING_SYSTEM_HOSTNAME VARCHAR(250), OPERATING_SYSTEM_TIME_ZONE VARCHAR(250), OPERATING_SYSTEM_OS_TYPE VARCHAR(250), OPERATING_SYSTEM_DISTRIBUTION VARCHAR(250), OPERATING_SSTM_FLL_QLFD_DMN_NM VARCHAR(250), OPERATING_SYSTEM_KERNL_RCHTCTR VARCHAR(250), OPERATING_SYSTEM_KERNEL_VERSIN VARCHAR(250), OPERATING_SYSTEM_KERNEL_WIDTH VARCHAR(250), OPERATING_SYSTEM_MANUFACTURER VARCHAR(250), OPERATING_SYSTEM_LOCALE VARCHAR(250), OPERATING_SYSTEM_VERSION_ITM_D CHAR(23), REMOTE_CONNECTION_URL VARCHAR(250), SOFTWARE_INSTALL_DESCRIPTION VARCHAR(250), SOFTWARE_INSTALL_DISPLAY_NAME VARCHAR(250), SOFTWARE_INSTALL_INSTALLD_LCTN VARCHAR(250), SOFTWARE_INSTALL_MANUFACTURER VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_NAME VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_ID VARCHAR(250), SOFTWARE_INSTALL_INSTALLED_DAT TIMESTAMP, SOFTWARE_INSTALL_EXECUTABLE_NM VARCHAR(250), SOFTWARE_INSTALL_VERSION_ITM_D CHAR(23), SOFTWARE_INSTALL_MA_PASSWORD VARCHAR(250), SOFTWARE_INSTALL_MA_USERNAME VARCHAR(250), SOFTWARE_INSTALL_BFA_PATH VARCHAR(250), SOFTWARE_PATCH_INSTALL_DATE TIMESTAMP, SOFTWARE_PATCH_PATCH_ID VARCHAR(250), SOFTWARE_PATCH_VERSION_ITEM_ID CHAR(23), VERSION_BUILD_LEVEL VARCHAR(250), VERSION_LEVEL INTEGER, VERSION_MAJOR_VERSION INTEGER, VERSION_MODIFIER INTEGER, VERSION_RELEASE INTEGER, VERSION_VERSION_STRING VARCHAR(250))
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE TABLE LM.ABSTRACT_INSTANCE(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, FAMILY_ITEM_ID CHAR(23) NOT NULL, VISIBILITY BIGINT NOT NULL, JZ_DISCRIMINATOR INTEGER NOT NULL, CPU_CPU_CORES_INSTALLED INTEGER, CPU_CPU_DIES_INSTALLED INTEGER, CPU_CPU_SPEED INTEGER, CPU_CPU_COUNT INTEGER, CPU_CPU_MANUFACTURER VARCHAR(250), CPU_CPU_ARCHITECTURE_WIDTH VARCHAR(250), CPU_CPU_ARCHITECTURE VARCHAR(250), IP_INTERFACE_IP_V4_ADDRESS VARCHAR(250), IP_INTERFACE_IP_V6_ADDRESS VARCHAR(250), IP_INTERFACE_IP_V6_NOTATION_TP VARCHAR(250), IP_INTERFACE_NETMASK VARCHAR(250), IP_INTERFACE_SUBNET_ADDRESS VARCHAR(250), IP_INTERFACE_L2_INTERFACE_NAME VARCHAR(250), LAB_RESOURCE_INTERNAL_ID INTEGER, LAB_RESOURCE_CPU_ITEM_ID CHAR(23), LAB_RESOURCE_IP_ADDRESS VARCHAR(250), LAB_RESOURCE_MODEL VARCHAR(250), LAB_RESOURCE_MEMORY INTEGER, LAB_RESOURCE_OWNER_ITEM_ID CHAR(23), LAB_RESOURCE_GROUP_ITEM_ID CHAR(23), LAB_RESOURCE_NAME VARCHAR(250), LAB_RESOURCE_ADMIN_STATUS VARCHAR(250), LAB_RESOURCE_OP_STATUS VARCHAR(250), LAB_RESOURCE_DESCRIPTION VARCHAR(250), LAB_RESOURCE_PRIMARY_MAC_DDRSS VARCHAR(250), LAB_RESOURCE_SYSTEM_BUILD_UUID VARCHAR(250), LAB_RESOURCE_SYSTEM_ID VARCHAR(250), LAB_RESOURCE_SERIAL_NUMBER VARCHAR(250), LAB_RESOURCE_TOTAL_DISK_SIZE INTEGER, LAB_RESOURCE_FREE_DISK_SPACE INTEGER, LAB_RESOURCE_LOCATION VARCHAR(250), LAB_RESOURCE_MANUFACTURER VARCHAR(250), LAB_RESOURCE_MODEL_NUMBER VARCHAR(250), LAB_RESOURCE_NOTES VARCHAR(250), LAB_RESOURCE_VM_MEMORY_SIZE INTEGER, LAB_RESOURCE_VM_DISK_SIZE INTEGER, LAB_RESOURCE_VMID VARCHAR(250), LAB_RESOURCE_VM_STATE VARCHAR(250), LAB_RESOURCE_VM_FILE VARCHAR(250), LAB_RESOURCE_DATE_CREATED TIMESTAMP, LAB_RESOURCE_DATE_LAST_MODIFID TIMESTAMP, LAB_RESOURCE_IMAGE_TYPE VARCHAR(250), LAB_RESOURCE_CREATED_WTH_VM_TL VARCHAR(250), LAB_RESOURCE_VERSION_ITEM_ID CHAR(23), L2_INTERFACE_MTU INTEGER, L2_INTERFACE_SPEED INTEGER, L2_INTERFACE_HW_ADDRESS VARCHAR(250), L2_INTERFACE_LOOPBACK VARCHAR(250), OPERATING_SYSTEM_HOSTNAME VARCHAR(250), OPERATING_SYSTEM_TIME_ZONE VARCHAR(250), OPERATING_SYSTEM_OS_TYPE VARCHAR(250), OPERATING_SYSTEM_DISTRIBUTION VARCHAR(250), OPERATING_SSTM_FLL_QLFD_DMN_NM VARCHAR(250), OPERATING_SYSTEM_KERNL_RCHTCTR VARCHAR(250), OPERATING_SYSTEM_KERNEL_VERSIN VARCHAR(250), OPERATING_SYSTEM_KERNEL_WIDTH VARCHAR(250), OPERATING_SYSTEM_MANUFACTURER VARCHAR(250), OPERATING_SYSTEM_LOCALE VARCHAR(250), OPERATING_SYSTEM_VERSION_ITM_D CHAR(23), REMOTE_CONNECTION_URL VARCHAR(250), SOFTWARE_INSTALL_DESCRIPTION VARCHAR(250), SOFTWARE_INSTALL_DISPLAY_NAME VARCHAR(250), SOFTWARE_INSTALL_INSTALLD_LCTN VARCHAR(250), SOFTWARE_INSTALL_MANUFACTURER VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_NAME VARCHAR(250), SOFTWARE_INSTALL_PRODUCT_ID VARCHAR(250), SOFTWARE_INSTALL_INSTALLED_DAT TIMESTAMP, SOFTWARE_INSTALL_EXECUTABLE_NM VARCHAR(250), SOFTWARE_INSTALL_VERSION_ITM_D CHAR(23), SOFTWARE_INSTALL_MA_PASSWORD VARCHAR(250), SOFTWARE_INSTALL_MA_USERNAME VARCHAR(250), SOFTWARE_INSTALL_BFA_PATH VARCHAR(250), SOFTWARE_PATCH_INSTALL_DATE TIMESTAMP, SOFTWARE_PATCH_PATCH_ID VARCHAR(250), SOFTWARE_PATCH_VERSION_ITEM_ID CHAR(23), VERSION_BUILD_LEVEL VARCHAR(250), VERSION_LEVEL INTEGER, VERSION_MAJOR_VERSION INTEGER, VERSION_MODIFIER INTEGER, VERSION_RELEASE INTEGER, VERSION_VERSION_STRING VARCHAR(250))
CRJAZ0487I An exception occurred while creating the database schema for the package "com.ibm.rational.test.lm".
The database tables were not created.