It's all about the answers!

Ask a question

CLM Upgrade 6.0.2 to 6.0.3: repotools_relm is failing on -addTables


Heather Linsk (1422352) | asked Dec 28 '16, 4:27 p.m.
edited Dec 28 '16, 4:29 p.m.
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



permanent link
Ralph Schoon (63.6k33646) | answered Jan 05 '17, 5:03 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Consider to approach the product support.

permanent link
Donald Nong (14.5k614) | answered Jan 08 '17, 8:07 p.m.

I found this technote based on the SQL Server error message in the OP.
http://www-01.ibm.com/support/docview.wss?uid=swg21980867

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.