CLM Upgrade 6.0.2 to 6.0.3: repotools_relm is failing on -addTables
I am getting the following errors when running the command: ./repotools-relm.sh -addTables
2016-12-28 16:11:43,807 Repo Tools 2016-12-28 16:11:43,807 java.version=1.7.0 2016-12-28 16:11:43,807 java.runtime.version=pxa6470_27sr3fp40-20160422_01 (SR3 FP40) 2016-12-28 16:11:43,811 Provisioning using "./conf/relm/provision_profiles". 2016-12-28 16:11:43,833 repotools-relm -addTables 2016-12-28 16:11:43,858 To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum. To find more information about a message, see the online product documentation. 2016-12-28 16:11:43,858 CRJAZ1363I Loading the configuration from "file:conf/relm/teamserver.properties". 2016-12-28 16:11:46,816 CRJAZ1365I The server is attempting to connect to the following database: "//sqlserver:1433;databaseName=relm;user=xxxxxxxx;password=xxxxxxxx" 2016-12-28 16:11:47,292 CRJAZ1364I The connection to the following database was successful: Db Product Name: Microsoft SQL Server Db Product Version: 11.00.6567 Db URL: jdbc:sqlserver://sqlserver:1433;databaseName=relm;user=xxxxxxxx;password=xxxxxxxx Jdbc Driver Name: Microsoft JDBC Driver 4.1 for SQL Server Jdbc Driver Version: 4.1.5605.100 SchemaPrefix: 2016-12-28 16:11:49,120 CRJAZ1780I This server is forced into APPLICATION mode by using the com.ibm.team.repository.server.mode property. 2016-12-28 16:11:49,125 CRJAZ2558I Setting the local server rename state to false and the openServerDescriptionServiceTemporarily state to false. 2016-12-28 16:11:49,201 CRJAZ2523I Setting the global server rename state to false and the validation state to false. 2016-12-28 16:11:49,335 CRJAZ1970I The application is configured with: Public URI: "https://clminfra:9443/relm" Jazz Team Server location: "https://clminfra:9443/jts/" 2016-12-28 16:11:49,769 CRJAZ2105I Checking for a running server... 2016-12-28 16:11:52,908 Adding tables to the database "//sqlserver:1433;databaseName=relm;user=xxxxxxxx;password=xxxxxxxx". 2016-12-28 16:11:52,976 CRJAZ1442I The component model of "com.ibm.team.repository" was updated from "37" to "38". 2016-12-28 16:11:56,239 CRJAZ1442I The component model of "com.ibm.team.jfs.resource" was updated from "8" to "9". 2016-12-28 16:11:56,566 CRJAZ1438I A new attribute "componentId" was added to class "com.ibm.team.jfs.resource.internal.Resource". 2016-12-28 16:12:03,142 CRJAZ1442I The component model of "com.ibm.team.markers" was updated from "2.0" to "3". 2016-12-28 16:12:03,204 CRJAZ1438I A new attribute "uri2" was added to class "com.ibm.team.dashboard.service.markers.Marker". 2016-12-28 16:12:03,793 CRJAZ1441I A new component model for "com.ibm.team.serviceability" was added. 2016-12-28 16:12:04,538 CRJAZ1442I The component model of "com.ibm.team.vvc" was updated from "10" to "13". 2016-12-28 16:12:04,909 CRJAZ3026I Size of string attribute "concept" in class "com.ibm.team.repository.service.internal.vvc.vvcmodel.Version" was decreased. 2016-12-28 16:12:04,915 CRJAZ3026I Size of string attribute "storage" in class "com.ibm.team.repository.service.internal.vvc.vvcmodel.Version" was decreased. 2016-12-28 16:12:04,998 CRJAZ1438I A new attribute "archived" was added to class "com.ibm.team.repository.service.internal.vvc.vvcmodel.Component". 2016-12-28 16:12:05,536 CRJAZ1440I A new type "ImplicitArchive" was added. 2016-12-28 16:12:05,543 CRJAZ1439I A new collection attribute "implicitlyArchivedItems" was added to class "ImplicitArchive". 2016-12-28 16:12:05,974 CRJAZ1442I The component model of "com.ibm.team.globalconfiguration" was updated from "2" to "3". 2016-12-28 16:12:06,207 CRJAZ1442I The component model of "com.ibm.team.links" was updated from "6" to "7". 2016-12-28 16:12:06,369 CRJAZ1438I A new attribute "internal" was added to class "com.ibm.team.repository.common.model.ConfigurationAwareAuditable". 2016-12-28 16:12:06,370 CRJAZ1438I A new attribute "ignored" was added to class "com.ibm.team.repository.common.model.ConfigurationAwareAuditable". 2016-12-28 16:12:06,370 CRJAZ1438I A new attribute "uri" was added to class "com.ibm.team.repository.common.model.ConfigurationAwareAuditable". 2016-12-28 16:12:06,370 CRJAZ1438I A new attribute "changeSetId" was added to class "com.ibm.team.repository.common.model.ConfigurationAwareAuditable". 2016-12-28 16:12:06,370 CRJAZ1438I A new attribute "componentId" was added to class "com.ibm.team.repository.common.model.ConfigurationAwareAuditable". 2016-12-28 16:12:07,095 The user "ADMIN" has logged out of the database "//sqlserver:1433;databaseName=relm;user=xxxxxxxx;password=xxxxxxxx". 2016-12-28 16:12:07,095 CRJAZ2521E An error occurred while attempting to modify the column "VERSION.CONCEPT". 2016-12-28 16:12:07,096 CRJAZ2521E An error occurred while attempting to modify the column "VERSION.CONCEPT". com.ibm.team.repository.common.TeamRepositoryException: CRJAZ2521E An error occurred while attempting to modify the column "VERSION.CONCEPT". at com.ibm.team.repository.service.TeamRepositoryExceptionHelper.wrapException(TeamRepositoryExceptionHelper.java:58) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.modifyColumnType(AbstractDbProvider.java:1968) at com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.modifyColumnType(SqlServerProvider.java:1526) 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.$Proxy93.modifyColumnType(Unknown Source) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.modifyColumnType(DatabaseMaintenanceService.java:2793) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.internalUpdateAllSchemas(DatabaseMaintenanceService.java:806) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService$8.run(DatabaseMaintenanceService.java:436) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService$8.run(DatabaseMaintenanceService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:572) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$2.run(RepositoryDatabase.java:356) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:487) at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source) 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.$Proxy94.withCurrentConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:353) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:316) at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runExclusive(PrimitiveTransactionService.java:147) 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.$Proxy119.runExclusive(Unknown Source) at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.updateAllSchemas(DatabaseMaintenanceService.java:431) 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.$Proxy190.updateAllSchemas(Unknown Source) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand$1.run(AddTablesCommand.java:67) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand$1.run(AddTablesCommand.java:1) at com.ibm.team.repository.service.internal.TeamServiceContext.runAsAdmin(TeamServiceContext.java:254) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.addTables(AddTablesCommand.java:60) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.execute(AddTablesCommand.java:205) 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 'VERSION_CONCEPT_DX' is dependent on column 'CONCEPT'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:58) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:70) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:55) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.executeStatement(AbstractDbProvider.java:869) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.modifyColumnType(AbstractDbProvider.java:1965) |
2 answers
Ralph Schoon (63.5k●3●36●46)
| answered Jan 05 '17, 5:03 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Consider to approach the product support.
|
I found this technote based on the SQL Server error message in the OP.
|
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.