It's all about the answers!

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

×10,960

question asked: Apr 02 '12, 4:27 a.m.
question was seen: 4,930 times
last updated: Apr 02 '12, 4:27 a.m.

Related questions

Problem upgrading from RQM 3.0 to 4.0RC1

0
David Hanslip (231●2●44●48) | asked Apr 02 '12, 4:27 a.m.
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?

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Robert Rassmann (992●3) | answered May 12 '12, 9:27 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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
permanent link
David Hanslip (231●2●44●48) | answered May 13 '12, 9:37 p.m.
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.

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.