It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×7,386
×4,693
×3,952

question asked: Dec 27 '16, 1:55 a.m.
question was seen: 2,139 times
last updated: Jan 12 '17, 1:34 a.m.

Related questions

FAQ - How this Forum works

Upgrade of 6.0.2 to 6.0.3 failing while running the upgrade script for rm

0
vinay kumar bondugula (73●1●26●68) | asked Dec 27 '16, 1:55 a.m.
edited Dec 27 '16, 7:31 a.m.
 Hi,

We are performing upgrade from CLM 6.0.2 to CLM  6.0.3 (SQLSERVER) and the upgrade fails while running upgrade script for RM. The script fails during adding tables and error is as following:

2016-12-26 22:40:10,304 CRJAZ2521E An error occurred while attempting to modify the column "VERSION.CONCEPT".
2016-12-26 22:40:10,306 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.$Proxy115.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.$Proxy116.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.$Proxy141.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.$Proxy211.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)
... 64 more
2016-12-26 22:40:10,313 CRJAZ1791E The migration completed with errors. The imported database is unstable and should not be used without further analysis.

FYI, we have successfully executed the below commands on RM database to check the field size of the VVCMODEL.VERSION table.

ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(1000)
ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(1000)

Also, to ensure the database statistics are up-to-date

EXEC sp_updatestats


Please let me know in case of any information further to fix the issue.


Thanks,

Vinay

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Diane Everitt (278●3●5) | answered Jan 04 '17, 2:50 p.m.
Hello Vinay,

Please see technote:
http://www.ibm.com/support/docview.wss?uid=swg21980867

Diane
Comments
Ilona Krammer commented Jan 11 '17, 4:51 a.m. | edited Jan 12 '17, 1:34 a.m.

I am having the same problem, but the technote doesn't solve the problem for me. I'm still getting the same error messages - what can I do?

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.