It's all about the answers!

Ask a question

Migration errors--RTC Upgrade from 2.0 to 3.0


K p (611216) | asked Dec 30 '10, 11:30 a.m.
Hi,

We are upgrading RTC from 2.0 to 3.0.
Existing Server 2.0 configuration (Tomact, SQL Server 2005, Windows server 2008 R2, LDAP)

For upgrade we choose to use the exiting Tomcat application server with new database for JTS.

We did followed the upgrade instructions. We are getting migration errors at "Repository database migration" at step 4command to import user information into the JTS database.
repotools-jts -migration_importJTSData fromFile=jtsData.tar createMappingFile=rtc-mapping.txt createTables.

************OUTPUT****************

2010-12-29 14:24:15,015 Using encoding "windows-1252"
2010-12-29 14:24:15,031
Reading the TAR file jtsData1.tar...
2010-12-29 14:24:15,062 Finished reading the TAR file "jtsData1.tar" in 31 ms.
2010-12-29 14:24:15,062 Using deserializer caching options to improve migration performance.
2010-12-29 14:24:15,062 Configured to update database stats every 1800000ms.
2010-12-29 14:24:15,062 Importing contents from jtsData1.tar into the repository.
2010-12-29 14:24:15,515
Migrating data exported from the following model versions
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.apt, Version = 8
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.apt.plansnapshot, Version = 1
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.apt.resource, Version = 4
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.apt.snapshot, Version = 2
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.build, Version = 11
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.compatibilitypack, Version = 1
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.dashboard, Version = 1.7
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.filesystem, Version = 0.8
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.foundation.wiki, Version = 4
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.interop, Version = 18
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.jfs.resource, Version = 3
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.links, Version = 5
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.opaque, Version = 1
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.process, Version = 13
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.reports, Version = 1.6
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.repository, Version = 21
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.repository.auth, Version = 3
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.repository.friends, Version = 2
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.scm, Version = 0.37
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.scm.svn, Version = 2
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.workitem, Version = 14
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.workitem.linkClosure, Version = 1
2010-12-29 14:24:15,515 Namespace URI = com.ibm.team.workitem.query, Version = 6
2010-12-29 14:24:15,515 Namespace URI = com.ibm.teami.scm, Version = 0.01
2010-12-29 14:24:15,515 Namespace URI = com.ibm.teamz.dsdef, Version = 2
2010-12-29 14:24:15,515 Namespace URI = com.ibm.teamz.langdef, Version = 2
2010-12-29 14:24:15,515 Namespace URI = com.ibm.teamz.supa.admin, Version = 1
2010-12-29 14:24:15,562
Registered Migration Handlers.
2010-12-29 14:24:15,562 Namespace URI = com.ibm.team.dashboard, Version = 1.7, Migration Handler = Dashboard Migration Handler
2010-12-29 14:24:15,562 Namespace URI = com.ibm.team.jfs.resource, Version = 3, Migration Handler = JFS Migration Handler
2010-12-29 14:24:15,562 Namespace URI = com.ibm.team.links, Version = 5, Migration Handler = Link Migration Handler to migrate version M to M
2010-12-29 14:24:15,562 Namespace URI = com.ibm.team.process, Version = 13, Migration Handler = Process Migration Handler
2010-12-29 14:24:15,562 Namespace URI = com.ibm.team.reports, Version = 1.6, Migration Handler = Reports Migration Provider
2010-12-29 14:24:15,562 Namespace URI = com.ibm.team.repository, Version = 21, Migration Handler = Repository Migration Handler to migrate data from version M to M
2010-12-29 14:24:15,562 Namespace URI = com.ibm.team.repository.friends, Version = 2, Migration Handler = migrateFriendsConfig
2010-12-29 14:24:15,562 Bridge Migration Handler = Full Text Migration Handler
2010-12-29 14:24:15,562 Data Migration Handler = Index Data Migration Handler
2010-12-29 14:24:15,562 Data Migration Handler = Repository Data Migration Handler
2010-12-29 14:24:15,562 Data Migration Handler = Jazz Data Warehouse Migration Handler
2010-12-29 14:24:15,562
2010-12-29 14:24:15,593 Running pre import for "com.ibm.team.repository" component...
2010-12-29 14:24:15,593 Pre Import for com.ibm.team.repository took 0 ms.

2010-12-29 14:24:15,593 Running pre import for "com.ibm.team.process" component...
2010-12-29 14:24:15,593 Pre Import for com.ibm.team.process took 0 ms.

2010-12-29 14:24:15,593 Running pre import for "com.ibm.team.dashboard" component...
2010-12-29 14:24:15,593 Pre Import for com.ibm.team.dashboard took 0 ms.

2010-12-29 14:24:15,593 Running pre import for "com.ibm.team.links" component...
2010-12-29 14:24:15,609 Pre Import for com.ibm.team.links took 16 ms.

2010-12-29 14:24:15,609 Running pre import for "com.ibm.team.reports" component...
2010-12-29 14:24:15,609 Pre Import for com.ibm.team.reports took 0 ms.

2010-12-29 14:24:15,609 Running pre import for "com.ibm.team.jfs.resource" component...
2010-12-29 14:24:15,609 Pre Import for com.ibm.team.jfs.resource took 0 ms.

2010-12-29 14:24:15,609 Running pre import for "com.ibm.team.repository.friends" component...
2010-12-29 14:24:15,609 Pre Import for com.ibm.team.repository.friends took 0 ms.

2010-12-29 14:24:15,609 Running pre import for "Full Text Migration Handler"...
2010-12-29 14:24:15,609 Pre Import for Full Text Migration Handler took 0 ms.

2010-12-29 14:24:15,734 Importing "LicenseType" items...
2010-12-29 14:24:15,952 Imported 7 LicenseType items, 7 item states in 844 ms.
2010-12-29 14:24:15,952 Average time to process an item state: 120 ms.
2010-12-29 14:24:15,952
2010-12-29 14:24:15,952 Importing "ContributorRecord" items...
2010-12-29 14:24:24,296 Imported 88 ContributorRecord items, 88 item states in 8343 ms.
2010-12-29 14:24:24,312 Average time to process an item state: 94 ms.
2010-12-29 14:24:24,312
2010-12-29 14:24:24,312 Importing "ContributorDetails" items...
2010-12-29 14:24:33,202 Imported 87 ContributorDetails items, 87 item states in 8938 ms.
2010-12-29 14:24:33,202 Skipped 0 ContributorDetails items, 36 item states
2010-12-29 14:24:33,202 Average time to process an item state: 72 ms.
2010-12-29 14:24:33,202
2010-12-29 14:24:33,202 Importing "LicenseAssignment" items...
2010-12-29 14:24:37,937 Imported 60 LicenseAssignment items, 60 item states in 4750 ms.
2010-12-29 14:24:37,937 Average time to process an item state: 79 ms.
2010-12-29 14:24:37,937
2010-12-29 14:24:37,937 Rebuilding indices...
2010-12-29 14:25:09,156 CRJAZ1318I A database connection error occurred.
Serialization failure
SQL: UPDATE STATISTICS REPOSITORY.LICENSE_TYPE
SQL Exception #1
SQL Message: Transaction (Process ID 169) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQL State: 40001
Error Code: 1205

com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 169) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.collectStatistics(SqlServerProvider.java:398)
at com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.collectStatistics(SqlServerProvider.java:390)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy48.collectStatistics(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.createIndices(PluggableJdbcDbBuilder.java:200)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.internalCreateIndicesForSchema(DatabaseMaintenanceService.java:257)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.internalCreateIndicesForPackage(DatabaseMaintenanceService.java:238)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.internalCreateAllIndicesExcept(DatabaseMaintenanceService.java:215)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.access$3(DatabaseMaintenanceService.java:212)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService$5.run(DatabaseMaintenanceService.java:207)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:440)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:267)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:332)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy857.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:263)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:242)
at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy890.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.createAllIndicesExcept(DatabaseMaintenanceService.java:204)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy911.createAllIndicesExcept(Unknown Source)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.createIndices(AbstractMigrationService.java:1309)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerifyPreserve(AbstractMigrationService.java:773)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:714)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy1010.importRepositoryOptionalVerify(Unknown Source)
at com.ibm.team.repotools.commands.local.internal.ImportJTSDataCommand.importData(ImportJTSDataCommand.java:103)
at com.ibm.team.repotools.commands.local.internal.ImportCommand.execute(ImportCommand.java:135)
at com.ibm.team.repotools.commands.local.internal.ImportJTSDataCommand.execute(ImportJTSDataCommand.java:70)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:56)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
2010-12-29 14:25:09,187 CRJAZ0651I Error rebuilding index.
com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A database connection error occurred.
Serialization failure
SQL: UPDATE STATISTICS REPOSITORY.LICENSE_TYPE
SQL Exception #1
SQL Message: Transaction (Process ID 169) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQL State: 40001
Error Code: 1205

at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:99)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.logAndReturnException(StatementErrLogWrapper.java:66)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:67)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.collectStatistics(SqlServerProvider.java:398)
at com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.collectStatistics(SqlServerProvider.java:390)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy48.collectStatistics(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.createIndices(PluggableJdbcDbBuilder.java:200)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.internalCreateIndicesForSchema(DatabaseMaintenanceService.java:257)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.internalCreateIndicesForPackage(DatabaseMaintenanceService.java:238)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.internalCreateAllIndicesExcept(DatabaseMaintenanceService.java:215)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.access$3(DatabaseMaintenanceService.java:212)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService$5.run(DatabaseMaintenanceService.java:207)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:440)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:267)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:332)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy857.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:263)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:242)
at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy890.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.createAllIndicesExcept(DatabaseMaintenanceService.java:204)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy911.createAllIndicesExcept(Unknown Source)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.createIndices(AbstractMigrationService.java:1309)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerifyPreserve(AbstractMigrationService.java:773)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:714)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy1010.importRepositoryOptionalVerify(Unknown Source)
at com.ibm.team.repotools.commands.local.internal.ImportJTSDataCommand.importData(ImportJTSDataCommand.java:103)
at com.ibm.team.repotools.commands.local.internal.ImportCommand.execute(ImportCommand.java:135)
at com.ibm.team.repotools.commands.local.internal.ImportJTSDataCommand.execute(ImportJTSDataCommand.java:70)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:56)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 169) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
... 79 more
2010-12-29 14:25:09,187 End rebuilding indices.
2010-12-29 14:25:09,281 Running post import for "com.ibm.team.repository" component...
2010-12-29 14:25:09,781 Post Import for com.ibm.team.repository took 500 ms.

2010-12-29 14:25:09,781 Running post import for "com.ibm.team.process" component...
2010-12-29 14:25:09,859 Post Import for com.ibm.team.process took 78 ms.

2010-12-29 14:25:09,859 Running post import for "com.ibm.team.dashboard" component...
2010-12-29 14:25:09,874 Post Import for com.ibm.team.dashboard took 15 ms.

2010-12-29 14:25:09,874 Running post import for "com.ibm.team.links" component...
2010-12-29 14:25:09,874 Post Import for com.ibm.team.links took 0 ms.

2010-12-29 14:25:09,874 Running post import for "com.ibm.team.reports" component...
2010-12-29 14:25:09,890 Post Import for com.ibm.team.reports took 16 ms.

2010-12-29 14:25:09,890 Running post import for "com.ibm.team.jfs.resource" component...
2010-12-29 14:25:09,890 Post Import for com.ibm.team.jfs.resource took 0 ms.

2010-12-29 14:25:09,890 Running post import for "com.ibm.team.repository.friends" component...
2010-12-29 14:25:09,890 Post Import for com.ibm.team.repository.friends took 0 ms.

2010-12-29 14:25:09,890 Running post import for "Full Text Migration Handler"...
2010-12-29 14:25:09,890 Post Import for Full Text Migration Handler took 0 ms.

2010-12-29 14:25:09,890 Post processing change events...
2010-12-29 14:25:09,890 Setting the context for change events took 0ms.
2010-12-29 14:25:09,890
Deleting migration data store...
2010-12-29 14:25:10,327 Deleted migration data store in 437 ms.
2010-12-29 14:25:10,327
Verifying the repository contents using verification level 1.
2010-12-29 14:25:10,327 Verifying items present in the "com.ibm.team.process" component.
2010-12-29 14:25:10,671 Verifying items present in the "com.ibm.team.dashboard" component.
2010-12-29 14:25:10,687 Verifying items present in the "com.ibm.team.repository" component.
2010-12-29 14:25:17,874 Verifying context of com.ibm.team.repository/ChangeEvent items...
2010-12-29 14:25:17,906 Verifying context of com.ibm.team.repository/LicenseType items...
2010-12-29 14:25:17,952 Verifying context of com.ibm.team.repository/LicenseAssignment items...
2010-12-29 14:25:17,968 Verifying context of com.ibm.team.repository/FloatingLicenseLease items...
2010-12-29 14:25:17,984 Verifying context of com.ibm.team.repository/FloatingLicensePolicy items...
2010-12-29 14:25:17,984 Verifying context of com.ibm.team.repository/ContributorDetails items...
2010-12-29 14:25:18,046 Verifying context of com.ibm.team.repository/AuditableBaseline items...
2010-12-29 14:25:18,109 Verifying context of com.ibm.team.repository/RepositoryRoot items...
2010-12-29 14:25:18,109 Verifying context of com.ibm.team.repository/ServerVersionRecord items...
2010-12-29 14:25:18,156 Verifying context of com.ibm.team.repository/ContributorRecord items...
2010-12-29 14:25:18,187 Verifying context of com.ibm.team.repository/ContributorGroup items...
2010-12-29 14:25:18,187 Verifying context of com.ibm.team.process/ProcessChangeEventCheck items...
2010-12-29 14:25:18,202 Verifying context of com.ibm.team.process/ProjectArea items...
2010-12-29 14:25:18,218 Verifying context of com.ibm.team.process/TeamArea items...
2010-12-29 14:25:18,531 Verifying context of com.ibm.team.process/ProcessDefinition items...
2010-12-29 14:25:18,531 Verifying context of com.ibm.team.process/ProcessDomainDefinition items...
2010-12-29 14:25:18,546 Verifying context of com.ibm.team.process/DevelopmentLine items...
2010-12-29 14:25:18,562 Verifying context of com.ibm.team.process/Iteration items...
2010-12-29 14:25:18,562 Verifying context of com.ibm.team.process/IterationType items...
2010-12-29 14:25:18,577 Verifying context of com.ibm.team.process/ProcessAttachment items...
2010-12-29 14:25:18,593 Verifying context of com.ibm.team.process/ReadAccessList items...
2010-12-29 14:25:18,609 Verifying context of com.ibm.team.process/ProjectLink items...
2010-12-29 14:25:18,609 Verifying context of com.ibm.team.process/ProcessGenericItem items...
2010-12-29 14:25:18,624 Verifying context of com.ibm.team.dashboard/Dashboard items...
2010-12-29 14:25:18,640 Verifying context of com.ibm.team.dashboard/DashboardContributorInfo items...
2010-12-29 14:25:18,656 Verifying context of com.ibm.team.compatibilitypack/URIMapping items...
2010-12-29 14:25:18,656 Verifying context of com.ibm.team.opaque/Opaque items...
2010-12-29 14:25:18,671 Verifying context of com.ibm.team.links/AuditableLink items...
2010-12-29 14:25:18,687 Verifying context of com.ibm.team.reports/ReportDescriptor items...
2010-12-29 14:25:18,687 Verifying context of com.ibm.team.reports/FolderDescriptor items...
2010-12-29 14:25:18,702 Verifying context of com.ibm.team.reports/ReportQueryDescriptor items...
2010-12-29 14:25:18,718 Verifying items present in the "com.ibm.team.reports" component.
2010-12-29 14:25:18,796
Imported 242 items, 242 item states in 63734 ms. 36 item states skipped. Error importing 0 elements.
2010-12-29 14:25:18,812 com.ibm.team.repository
2010-12-29 14:25:18,812 ContributorRecord : 88 items, 88 item states imported.
2010-12-29 14:25:18,812 ContributorDetails : 87 items, 87 item states imported.
2010-12-29 14:25:18,812 LicenseAssignment : 60 items, 60 item states imported.
2010-12-29 14:25:18,812 LicenseType : 7 items, 7 item states imported.
2010-12-29 14:25:18,812
2010-12-29 14:25:18,812
2010-12-29 14:25:18,812 ##############################################################################################
2010-12-29 14:25:18,827 ****** Migration Errors ******
2010-12-29 14:25:18,827 CRJAZ0656I **ERROR** Migration completed with errors. The imported database is in an inconsistent state and should not be used without further analysis.
Check the migration log "C:\RTC\RTC3\server\repotools-jts_migration_importJTSData.log" for details.
2010-12-29 14:25:18,827 ##############################################################################################

We did open a ticket, But we are still waiting for that response. I thought jazz.net will be quicker way to get responses.

Please let us know your suggestions on it.

Thanks,
Kiran

Be the first one to answer this question!


Register or to post your answer.