Problems setting up DB2 Datawarehouse
Hi,
I'm using RTC Server version: 3.0.1.2
Migration from 3.0.1 has been performed following instructions in
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Froadmap_clm_upgrade.html
Everything is working well except the DataWarehouse part.
I did not use neither DataWarehouse nor DataMart with 3.0.1, but I wanted to start using the reporting functionlity now and therefore I got a new DB2 database setup.
When I run "repotools-jts.sh -createWarehouse" command, the following error is returned:
I noticed that H_BUILD_REQU_PASS table does not exist in the datawarehouse db.
Any hints about what might be producing this problem?
I'm using RTC Server version: 3.0.1.2
Migration from 3.0.1 has been performed following instructions in
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Froadmap_clm_upgrade.html
Everything is working well except the DataWarehouse part.
I did not use neither DataWarehouse nor DataMart with 3.0.1, but I wanted to start using the reporting functionlity now and therefore I got a new DB2 database setup.
When I run "repotools-jts.sh -createWarehouse" command, the following error is returned:
2012-03-22 17:34:39,433 CRJAZ1318I A database connection error occurred.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
Parameter 0: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, DRIVER=3.57.82
SQL State: 57011
Error Code: -289
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.km.c(km.java:2506)
at com.ibm.db2.jcc.am.km.d(km.java:2483)
at com.ibm.db2.jcc.am.km.b(km.java:1903)
at com.ibm.db2.jcc.t4.db.h(db.java:220)
at com.ibm.db2.jcc.t4.db.b(db.java:46)
at com.ibm.db2.jcc.t4.t.b(t.java:38)
at com.ibm.db2.jcc.t4.sb.g(sb.java:114)
at com.ibm.db2.jcc.am.km.db(km.java:1898)
at com.ibm.db2.jcc.am.km.a(km.java:2899)
at com.ibm.db2.jcc.am.km.e(km.java:985)
at com.ibm.db2.jcc.am.km.execute(km.java:969)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178)
I noticed that H_BUILD_REQU_PASS table does not exist in the datawarehouse db.
Any hints about what might be producing this problem?
3 answers
Sorry for reviving an old thread, but I think we needed the solution documented here. The solution is either to have the following in your server/conf/jts/teamserver.properties:
com.ibm.team.datawarehouse.db.base.folder=
That means "equals NOTHING"!! The default will be "/jazzdw" but this will not work.
You can also run /jts/setup and then remove the /jazzdw from the table space folder text box.
com.ibm.team.datawarehouse.db.base.folder=
That means "equals NOTHING"!! The default will be "/jazzdw" but this will not work.
You can also run /jts/setup and then remove the /jazzdw from the table space folder text box.
Hi,
I'm using RTC Server version: 3.0.1.2
Migration from 3.0.1 has been performed following instructions in
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Froadmap_clm_upgrade.html
Everything is working well except the DataWarehouse part.
I did not use neither DataWarehouse nor DataMart with 3.0.1, but I wanted to start using the reporting functionlity now and therefore I got a new DB2 database setup.
When I run "repotools-jts.sh -createWarehouse" command, the following error is returned:
2012-03-22 17:34:39,433 CRJAZ1318I A database connection error occurred.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
Parameter 0: ALTER TABLE H_BUILD_REQU_PASS ADD CONSTRAINT H_BLD_REQU_PASS_PK PRIMARY KEY (BUILD_METRIC_ID,BUILD_ID)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, DRIVER=3.57.82
SQL State: 57011
Error Code: -289
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-289, SQLSTATE=57011, SQLERRMC=VSTR_IDX, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.km.c(km.java:2506)
at com.ibm.db2.jcc.am.km.d(km.java:2483)
at com.ibm.db2.jcc.am.km.b(km.java:1903)
at com.ibm.db2.jcc.t4.db.h(db.java:220)
at com.ibm.db2.jcc.t4.db.b(db.java:46)
at com.ibm.db2.jcc.t4.t.b(t.java:38)
at com.ibm.db2.jcc.t4.sb.g(sb.java:114)
at com.ibm.db2.jcc.am.km.db(km.java:1898)
at com.ibm.db2.jcc.am.km.a(km.java:2899)
at com.ibm.db2.jcc.am.km.e(km.java:985)
at com.ibm.db2.jcc.am.km.execute(km.java:969)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178)
I noticed that H_BUILD_REQU_PASS table does not exist in the datawarehouse db.
Any hints about what might be producing this problem?
Run the https://yourjtsserver:9334/jts/setup and on the datawarehouse pages enter the correct values - and click the create datawarehouse tables button there. I asume the driver is ok on your machine - eg that you are sing db2 for the other databases for jazz.
Hi,
running from jts/setup returns the same error.
The connection to the DB2 database is established successfully. The error appears during the "Create Tables" execution.
DB2 database structure has been setup using this commands:
running from jts/setup returns the same error.
The connection to the DB2 database is established successfully. The error appears during the "Create Tables" execution.
DB2 database structure has been setup using this commands:
CREATE BUFFERPOOL BPTEMP32K SIZE 4000 PAGESIZE 32768;
CREATE BUFFERPOOL BP_32K SIZE 8000 PAGESIZE 32768;
CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('$BASEDIRtempspace32k') BUFFERPOOL BPTEMP32K;
CREATE REGULAR TABLESPACE VNF_IDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvnf_idx.1' 5600) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;
CREATE REGULAR TABLESPACE VNF_32K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvnf_32k.1' 12000) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;
CREATE REGULAR TABLESPACE VSTR_IDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvstr_idx.1' 4000) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;
CREATE REGULAR TABLESPACE VSTR_32K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '$BASEDIRvstr_32k.1' 7200) BUFFERPOOL BP_32K AUTORESIZE YES INCREASESIZE 50 M MAXSIZE NONE;