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

Problem upgrading from RQM 3.0 to 4.0RC1

My upgrade from RQM 3.0 to 4.0RC1 is failing:

CRJAZ1363I Loading the configuration from "file:c:/IBM/JazzTeamServer/server/con
f/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1365I The server is attempting to connect to the following database: "//loc
alhost:50000/jts:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09070
Db URL: jdbc:db2://localhost:50000/jts:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ1971I The server is configured with:
Public URI: "https://andromeda:9443/jts"
CRJAZ1728E An unexpected error has been detected. See the log file "c:\IBM\JazzT
eamServer\server\repotools-jts_upgradeWarehouse.log" for more details.

The jts upgrade failed at step 2. Correct the problem and run the script again
starting at step 2.

Here are the relevant lines from the log:

2012-04-02 15:49:47,064 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09070
Db URL: jdbc:db2://localhost:50000/jts:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
2012-04-02 15:49:49,602 CRJAZ1971I The server is configured with:
Public URI: "https://andromeda:9443/jts"
2012-04-02 15:51:06,854 ALTER TABLE RIDW.F_C_REQUEST_AGING ADD CONSTRAINT F_C_REQ_AGD_FK11 FOREIGN KEY (CREATOR_ID) REFERENCES RIDW.D_RESOURCE(RESOURCE_ID)
com.ibm.team.repository.common.TeamRepositoryException: ALTER TABLE RIDW.F_C_REQUEST_AGING ADD CONSTRAINT F_C_REQ_AGD_FK11 FOREIGN KEY (CREATOR_ID) REFERENCES RIDW.D_RESOURCE(RESOURCE_ID)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:247)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSqlIgnoringGrantAndUserErrors(AbstractDataWarehouseDbProvider.java:123)

Any suggestions please?

0 votes



2 answers

Permanent link
My upgrade from RQM 3.0 to 4.0RC1 is failing:

CRJAZ1363I Loading the configuration from "file:c:/IBM/JazzTeamServer/server/con
f/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1365I The server is attempting to connect to the following database: "//loc
alhost:50000/jts:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09070
Db URL: jdbc:db2://localhost:50000/jts:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ1971I The server is configured with:
Public URI: "https://andromeda:9443/jts"
CRJAZ1728E An unexpected error has been detected. See the log file "c:\IBM\JazzT
eamServer\server\repotools-jts_upgradeWarehouse.log" for more details.

The jts upgrade failed at step 2. Correct the problem and run the script again
starting at step 2.

Here are the relevant lines from the log:

2012-04-02 15:49:47,064 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09070
Db URL: jdbc:db2://localhost:50000/jts:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
2012-04-02 15:49:49,602 CRJAZ1971I The server is configured with:
Public URI: "https://andromeda:9443/jts"
2012-04-02 15:51:06,854 ALTER TABLE RIDW.F_C_REQUEST_AGING ADD CONSTRAINT F_C_REQ_AGD_FK11 FOREIGN KEY (CREATOR_ID) REFERENCES RIDW.D_RESOURCE(RESOURCE_ID)
com.ibm.team.repository.common.TeamRepositoryException: ALTER TABLE RIDW.F_C_REQUEST_AGING ADD CONSTRAINT F_C_REQ_AGD_FK11 FOREIGN KEY (CREATOR_ID) REFERENCES RIDW.D_RESOURCE(RESOURCE_ID)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:247)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSqlIgnoringGrantAndUserErrors(AbstractDataWarehouseDbProvider.java:123)

Any suggestions please?

Sounds like a defect in RC1. Does this happen with later version? If it does if would be worth filing a work item.

0 votes


Permanent link
Hi. It's been suggested that there's a problem with the dw database. I'll leave it for now and hope that the production system doesn't have the same problem.

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

Question asked: Apr 02 '12, 4:27 a.m.

Question was seen: 5,010 times

Last updated: Apr 02 '12, 4:27 a.m.

Confirmation Cancel Confirm