Upgrade RTC 5.0.2 vers 6.0.3
Hello,
I upgrade RTC 5.0.2 to 6.0.3.
I execute the command upgrade\jts\jts_upgrade.bat -oldJTSHome d:\IBM\JazzTeamServer502\server\conf, but I have the error :
2017-02-20 10:22:22,636 CRJAZ1728E Une erreur liée à Repository Tools est survenue. Pour plus d'informations, consultez le fichier journal suivant : D:\IBM\JazzTeamServer603\server\repotools-jts_upgradeWarehouse.log
2017-02-20 10:22:22,636 ALTER TABLE RIODS.RESOURCE ALTER COLUMN REFERENCE_ID NVARCHAR(255)
com.ibm.team.repository.common.TeamRepositoryException: ALTER TABLE RIODS.RESOURCE ALTER COLUMN REFERENCE_ID NVARCHAR(255)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:434)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSqlIgnoringGrantAndUserErrors(AbstractDataWarehouseDbProvider.java:257)
at com.ibm.team.datawarehouse.service.sqlserver.internal.SqlServerDataWarehouseDbProvider.migrateDataWarehouseCALMTables(SqlServerDataWarehouseDbProvider.java:256)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy662.migrateDataWarehouseCALMTables(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$2.run(RemoteDatabaseService.java:349)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$6.run(RemoteDatabaseService.java:556)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:487)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:518)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.upgradeRemoteSchemas(RemoteDatabaseService.java:322)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy74.upgradeRemoteSchemas(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.UpgradeDataWarehouseCommand.execute(UpgradeDataWarehouseCommand.java:28)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:68)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:833)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:908)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 'RESOURCE_IDX10' is dependent on column 'REFERENCE_ID'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:242)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:173)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:71)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeStatement(AbstractDataWarehouseDbProvider.java:277)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:409)
I don't answer the error!
What should be corrected?
Guillaume
One answer
Hi Guillaume,
You should generate the upgrade scripts as follows:
1) Shutdown the CLM server
2) Run repotools-jts -generateWarehouseUpgradeScripts
3) Run the generated scripts
Here are more detailed instructions:
https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Fr_repotools_gen_dw_upgradescripts.html
You should look at the results of running each of the generated scripts and ensure the script had run correctly.
Scripts may fail to run certain steps if the artifact already exists in the data warehouse as a result of previous attempts to run the scripts. You should ignore those errors.
In case you will find errors like:
- Cannot find the user 'RPTUSER', because it does not exist or you do not have permission.
- Table 'RIDW.D_DATE' does not have the identity property. Cannot perform SET operation.
- The index 'RESOURCE_IDX10' is dependent on column 'REFERENCE_ID'.
ALTER TABLE ALTER COLUMN REFERENCE_ID failed because one or more objects access this column.
You can safely ignore the errors. They should be harmless.