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?
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
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.