It's all about the answers!

Ask a question

Urgent: Errors migrating repository from 1.x to 2.0


Sunil Kumar Perla (71143) | asked Aug 27 '09, 6:31 p.m.
Issues migrating from RTC 1.x Std Ed to 2.0 Ent Ed.

- Exported repository using repotools on 1.x
- Importing repository using repotools on 2.x threw some scm and db2 sql errors.

Here is the import log:

2009-08-27 10:18:00,968 repotools -import fromFile=/JZexport.tar
2009-08-27 10:18:00,983 java.version=1.5.0
2009-08-27 10:18:00,983 java.runtime.version=pxa64devifx-20090505 (SR9-0 +IZ45776+IZ49644+IZ49635)
2009-08-27 10:18:00,984 Repo Tools
2009-08-27 10:18:00,986 Rational Team Concert, Version 2.0 (I20090618-1753)
Jazz Foundation Server, Version 1.0 (I20090618-1753)

2009-08-27 10:18:01,007 Provisioning using "./conf/jazz/provision_profiles".
2009-08-27 10:18:16,728 Rational Jazz Team Server - Enterprise
2009-08-27 10:18:16,767 CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
2009-08-27 10:18:19,485 CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;
2009-08-27 10:18:20,224 CRJAZ1364I Initial database connection successful
Db Product Name: DB2/LINUXX8664
Db Product Version: SQL09070
Db URL: jdbc:db2://ips-db.swg.usma.ibm.com:50000/ipsrtc
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
2009-08-27 10:18:20,963 CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
2009-08-27 10:18:49,876 Creating the tables for the database "//ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;" without indices.
2009-08-27 10:21:06,033 The user "ADMIN" has logged in to the database "//ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;".
2009-08-27 10:21:06,524 The user "ADMIN" has logged out of the database "//ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;".
2009-08-27 10:21:06,525 The database tables were created successfully.
2009-08-27 10:21:07,495 CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;
2009-08-27 10:21:07,586 CRJAZ1364I Initial database connection successful
Db Product Name: DB2/LINUXX8664
Db Product Version: SQL09070
Db URL: jdbc:db2://ips-db.swg.usma.ibm.com:50000/ipsrtc
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
2009-08-27 10:21:12,068 The user "ADMIN" has logged in to the database "//ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;".
2009-08-27 10:21:12,069 Importing the data from the file "/JZexport.tar" into the database "//ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;".
2009-08-27 10:21:12,069 Using encoding "UTF-8"
2009-08-27 10:21:12,086
Reading the TAR file /JZexport.tar...
2009-08-27 10:21:14,906 Finished reading the TAR file "/JZexport.tar" in 2819 ms.
2009-08-27 10:21:14,907 Using deserializer caching options to improve migration performance.
2009-08-27 10:21:14,907 Configured to update database stats every 1800000ms.
2009-08-27 10:21:14,907 Importing contents from /JZexport.tar into the repository.
2009-08-27 10:21:16,234
Migrating data exported from the following model versions
2009-08-27 10:21:16,235 Namespace URI = com.ibm.team.analysis, Version = 1
2009-08-27 10:21:16,235 Namespace URI = com.ibm.team.apt, Version = 3
2009-08-27 10:21:16,235 Namespace URI = com.ibm.team.apt.resource, Version = 2
2009-08-27 10:21:16,235 Namespace URI = com.ibm.team.build, Version = 5
2009-08-27 10:21:16,235 Namespace URI = com.ibm.team.dashboard, Version = 1.2
2009-08-27 10:21:16,235 Namespace URI = com.ibm.team.filesystem, Version = 0.7
2009-08-27 10:21:16,235 Namespace URI = com.ibm.team.foundation.wiki, Version = 3
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.interop, Version = 17
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.links, Version = 4
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.opaque, Version = 1
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.process, Version = 6
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.process.simplefile, Version = 1
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.reports, Version = 1.3
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.repository, Version = 10
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.scm, Version = 0.28
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.scm.svn, Version = 1
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.workitem, Version = 7
2009-08-27 10:21:16,236 Namespace URI = com.ibm.team.workitem.query, Version = 4
2009-08-27 10:21:17,951
Registered Migration Handlers.
2009-08-27 10:21:17,952 Namespace URI = com.ibm.team.apt, Version = 7, Migration Handler = APT Migration Provider
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.apt.resource, Version = 3, Migration Handler = CRM Migration Provider
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.build, Version = 8, Migration Handler = Build Migration Handler
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.dashboard, Version = 1.7, Migration Handler = Dashboard Migration Handler
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.filesystem, Version = 0.8, Migration Handler = Filesystem Migration Handler
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.foundation.wiki, Version = 4, Migration Handler = Wiki Migration Provider
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.interop, Version = 18, Migration Handler = Interop Migration Handler
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.links, Version = 5, Migration Handler = Link Migration Handler to migrate from 1.0M1 and 1.0M2
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.process, Version = 11, Migration Handler = Process Migration Handler
2009-08-27 10:21:17,953 Namespace URI = com.ibm.team.process.simplefile, Version = <not>, Migration Handler = Simple File Migration Helper
2009-08-27 10:21:17,954 Namespace URI = com.ibm.team.reports, Version = 1.5, Migration Handler = Reports Migration Provider
2009-08-27 10:21:17,954 Namespace URI = com.ibm.team.repository, Version = 15, Migration Handler = Migration handler to migrate from 1.0M1 and 1.0M2D1
2009-08-27 10:21:17,954 Namespace URI = com.ibm.team.scm, Version = 0.33, Migration Handler = SCM Migration Handler
2009-08-27 10:21:17,954 Namespace URI = com.ibm.team.scm.svn, Version = 2, Migration Handler = SVN
2009-08-27 10:21:17,955 Namespace URI = com.ibm.team.workitem, Version = 11, Migration Handler = Work Item Migration Provider
2009-08-27 10:21:17,955 Namespace URI = com.ibm.team.workitem.query, Version = 6, Migration Handler = Query Migration Provider
2009-08-27 10:21:17,955 Bridge Migration Handler = Interop WorkItem Manager Migration Handler
2009-08-27 10:21:17,955 Bridge Migration Handler = SCM Work Items Bridge Migration Handler
2009-08-27 10:21:17,955 Bridge Migration Handler = Interop ClearQuest Manager Migration Handler
2009-08-27 10:21:17,955 Bridge Migration Handler = Full Text Migration Handler
2009-08-27 10:21:17,956 Data Migration Handler = Versioned Content Migration Handler
2009-08-27 10:21:17,956 Data Migration Handler = Repository Data Migration Handler
2009-08-27 10:21:17,956 Data Migration Handler = Jazz Data Warehouse Migration Handler
2009-08-27 10:21:17,956
2009-08-27 10:21:18,135 Running pre import for "com.ibm.team.repository" component...
2009-08-27 10:21:18,136 Pre Import for com.ibm.team.repository took 1 ms.

2009-08-27 10:21:18,137 Running pre import for "com.ibm.team.process" component...
2009-08-27 10:21:18,137 Pre Import for com.ibm.team.process took 0 ms.

2009-08-27 10:21:18,137 Running pre import for "com.ibm.team.interop" component...
2009-08-27 10:21:18,138 Pre Import for com.ibm.team.interop took 1 ms.

2009-08-27 10:21:18,138 Running pre import for "com.ibm.team.workitem" component...
2009-08-27 10:21:18,138 Pre Import for com.ibm.team.workitem took 0 ms.

2009-08-27 10:21:18,138 Running pre import for "com.ibm.team.scm" component...
2009-08-27 10:21:18,139 Pre Import for com.ibm.team.scm took 1 ms.

2009-08-27 10:21:18,139 Running pre import for "com.ibm.team.apt" component...
2009-08-27 10:21:18,139 Pre Import for com.ibm.team.apt took 0 ms.

2009-08-27 10:21:18,139 Running pre import for "com.ibm.team.workitem.query" component...
2009-08-27 10:21:18,139 Pre Import for com.ibm.team.workitem.query took 0 ms.

2009-08-27 10:21:18,140 Running pre import for "com.ibm.team.apt.resource" component...
2009-08-27 10:21:18,140 Pre Import for com.ibm.team.apt.resource took 0 ms.

2009-08-27 10:21:18,140 Running pre import for "com.ibm.team.foundation.wiki" component...
2009-08-27 10:21:18,140 Pre Import for com.ibm.team.foundation.wiki took 0 ms.

2009-08-27 10:21:18,140 Running pre import for "com.ibm.team.dashboard" component...
2009-08-27 10:21:18,141 Pre Import for com.ibm.team.dashboard took 1 ms.

2009-08-27 10:21:18,141 Running pre import for "com.ibm.team.build" component...
2009-08-27 10:21:18,141 Pre Import for com.ibm.team.build took 0 ms.

2009-08-27 10:21:18,141 Running pre import for "com.ibm.team.reports" component...
2009-08-27 10:21:18,142 Pre Import for com.ibm.team.reports took 1 ms.

2009-08-27 10:21:18,142 Running pre import for "com.ibm.team.links" component...
2009-08-27 10:21:18,142 Pre Import for com.ibm.team.links took 0 ms.

2009-08-27 10:21:18,142 Running pre import for "com.ibm.team.scm.svn" component...
2009-08-27 10:21:18,143 Pre Import for com.ibm.team.scm.svn took 0 ms.

2009-08-27 10:21:18,143 Running pre import for "com.ibm.team.filesystem" component...
2009-08-27 10:21:18,144 Pre Import for com.ibm.team.filesystem took 1 ms.

2009-08-27 10:21:18,144 Running pre import for "Interop WorkItem Manager Migration Handler"...
2009-08-27 10:21:18,145 Pre Import for Interop WorkItem Manager Migration Handler took 1 ms.

2009-08-27 10:21:18,145 Running pre import for "SCM Work Items Bridge Migration Handler"...
2009-08-27 10:21:18,145 Pre Import for SCM Work Items Bridge Migration Handler took 0 ms.

2009-08-27 10:21:18,145 Running pre import for "Interop ClearQuest Manager Migration Handler"...
2009-08-27 10:21:18,146 Pre Import for Interop ClearQuest Manager Migration Handler took 1 ms.

2009-08-27 10:21:18,146 Running pre import for "Full Text Migration Handler"...
2009-08-27 10:21:18,177 Pre Import for Full Text Migration Handler took 31 ms.

2009-08-27 10:21:18,862 Importing "ChangeEvent" items...
2009-08-27 10:28:01,550 Imported 18664 ChangeEvent items, 18664 item states in 406642 ms.
2009-08-27 10:28:01,551 Average time to process an item state: 21 ms.
2009-08-27 10:28:01,551
2009-08-27 10:28:01,551 Importing "LicenseType" items...
2009-08-27 10:28:01,719 Imported 9 LicenseType items, 9 item states in 168 ms.
2009-08-27 10:28:01,719 Average time to process an item state: 18 ms.
2009-08-27 10:28:01,719
2009-08-27 10:28:01,720 Importing "LicenseAssignment" items...
2009-08-27 10:28:12,742 Imported 944 LicenseAssignment items, 944 item states in 11023 ms.
2009-08-27 10:28:12,742 Average time to process an item state: 11 ms.
2009-08-27 10:28:12,742
2009-08-27 10:28:12,742 Importing "ContributorDetails" items...
2009-08-27 10:28:23,268 Imported 655 ContributorDetails items, 873 item states in 10526 ms.
2009-08-27 10:28:23,268 Average time to process an item state: 12 ms.
2009-08-27 10:28:23,268
2009-08-27 10:28:23,268 Importing "RepositoryRoot" items...
2009-08-27 10:28:23,301 Imported 1 RepositoryRoot items, 8 item states in 33 ms.
2009-08-27 10:28:23,302 Average time to process an item state: 4 ms.
2009-08-27 10:28:23,302
2009-08-27 10:28:23,302 Importing "Contributor" items...
2009-08-27 10:28:33,855 Imported 655 Contributor items, 1129 item states in 10553 ms.
2009-08-27 10:28:33,855 Average time to process an item state: 9 ms.
2009-08-27 10:28:33,855
2009-08-27 10:28:33,855 Importing "ProcessChangeEventCheck" items...
2009-08-27 10:28:34,399 Imported 1 ProcessChangeEventCheck items, 1 item states in 544 ms.
2009-08-27 10:28:34,399 Average time to process an item state: 544 ms.
2009-08-27 10:28:34,399
2009-08-27 10:28:34,399 Importing "ProjectArea" items...
2009-08-27 10:28:47,074 Imported 16 ProjectArea items, 444 item states in 12675 ms.
2009-08-27 10:28:47,074 Average time to process an item state: 28 ms.
2009-08-27 10:28:47,074
2009-08-27 10:28:47,074 Importing "TeamArea" items...
2009-08-27 10:28:56,393 Imported 43 TeamArea items, 243 item states in 9319 ms.
2009-08-27 10:28:56,393 Average time to process an item state: 38 ms.
2009-08-27 10:28:56,393
2009-08-27 10:28:56,393 Importing "ProcessDefinition" items...
2009-08-27 10:28:58,540 Imported 7 ProcessDefinition items, 41 item states in 2147 ms.
2009-08-27 10:28:58,540 Average time to process an item state: 52 ms.
2009-08-27 10:28:58,540
2009-08-27 10:28:58,540 Importing "DevelopmentLine" items...
2009-08-27 10:29:00,115 Imported 27 DevelopmentLine items, 128 item states in 1575 ms.
2009-08-27 10:29:00,115 Average time to process an item state: 12 ms.
2009-08-27 10:29:00,115
2009-08-27 10:29:00,115 Importing "Iteration" items...
2009-08-27 10:29:04,276 Imported 0 Iteration items, 234 item states in 4161 ms.
2009-08-27 10:29:04,276 Skipped 141 Iteration items, 141 item states
2009-08-27 10:29:04,276 Average time to process an item state: 11 ms.
2009-08-27 10:29:04,276
2009-08-27 10:29:04,276 Importing "IterationType" items...
2009-08-27 10:29:04,491 Imported 15 IterationType items, 15 item states in 215 ms.
2009-08-27 10:29:04,491 Average time to process an item state: 14 ms.
2009-08-27 10:29:04,491
2009-08-27 10:29:04,491 Importing "ProcessAttachment" items...
2009-08-27 10:29:48,138 Imported 318 ProcessAttachment items, 581 item states in 43647 ms.
2009-08-27 10:29:48,138 Skipped 749 ProcessAttachment items, 749 item states
2009-08-27 10:29:48,138 Average time to process an item state: 32 ms.
2009-08-27 10:29:48,138
2009-08-27 10:29:48,138 Importing "ExternalProxy" items...
2009-08-27 10:33:31,138 Imported 12870 ExternalProxy items, 27159 item states in 223000 ms.
2009-08-27 10:33:31,138 Average time to process an item state: 8 ms.
2009-08-27 10:33:31,138
2009-08-27 10:33:31,138 Importing "ExternalState" items...
2009-08-27 10:37:20,096 Imported 12870 ExternalState items, 14289 item states in 228958 ms.
2009-08-27 10:37:20,097 Average time to process an item state: 16 ms.
2009-08-27 10:37:20,097
2009-08-27 10:37:20,097 Importing "Deliverable" items...
2009-08-27 10:37:21,561 Imported 61 Deliverable items, 83 item states in 1464 ms.
2009-08-27 10:37:21,561 Average time to process an item state: 17 ms.
2009-08-27 10:37:21,562
2009-08-27 10:37:21,562 Importing "WorkItem" items...
2009-08-27 10:43:00,000 Imported 4661 WorkItem items, 20613 item states in 338438 ms.
2009-08-27 10:43:00,001 Average time to process an item state: 16 ms.
2009-08-27 10:43:00,001
2009-08-27 10:43:00,001 Importing "Category" items...
2009-08-27 10:43:05,263 Imported 204 Category items, 365 item states in 5262 ms.
2009-08-27 10:43:05,264 Average time to process an item state: 14 ms.
2009-08-27 10:43:05,264
2009-08-27 10:43:05,264 Importing "Attribute" items...
2009-08-27 10:43:13,603 Imported 563 Attribute items, 563 item states in 8339 ms.
2009-08-27 10:43:13,603 Average time to process an item state: 14 ms.
2009-08-27 10:43:13,603
2009-08-27 10:43:13,603 Importing "Attachment" items...
2009-08-27 10:43:45,936 Imported 636 Attachment items, 637 item states in 32333 ms.
2009-08-27 10:43:45,937 Average time to process an item state: 50 ms.
2009-08-27 10:43:45,937
2009-08-27 10:43:45,937 Importing "Workspace" items...
2009-08-27 10:43:49,818 Imported 130 Workspace items, 130 item states in 3881 ms.
2009-08-27 10:43:49,818 Average time to process an item state: 29 ms.
2009-08-27 10:43:49,818
2009-08-27 10:43:49,818 Importing "Configuration" items...
2009-08-27 10:46:36,699 Imported 0 Configuration items, 0 item states in 166881 ms.
2009-08-27 10:46:36,699 Skipped 696 Configuration items, 696 item states
2009-08-27 10:46:36,699 Average time to process an item state: 239 ms.
2009-08-27 10:46:36,699
2009-08-27 10:46:36,699 Importing "ChangeHistory" items...
2009-08-27 10:49:33,145 Imported 7379 ChangeHistory items, 7379 item states in 176446 ms.
2009-08-27 10:49:33,146 Average time to process an item state: 23 ms.
2009-08-27 10:49:33,146
2009-08-27 10:49:33,146 Importing "ComponentEntry" items...
2009-08-27 10:49:41,240 Imported 532 ComponentEntry items, 532 item states in 8094 ms.
2009-08-27 10:49:41,240 Average time to process an item state: 15 ms.
2009-08-27 10:49:41,240
2009-08-27 10:49:41,240 Importing "Suspended" items...
2009-08-27 10:49:41,441 Imported 17 Suspended items, 17 item states in 201 ms.
2009-08-27 10:49:41,441 Average time to process an item state: 11 ms.
2009-08-27 10:49:41,441
2009-08-27 10:49:41,441 Importing "BaselineSet" items...
2009-08-27 10:50:37,309 Imported 3785 BaselineSet items, 3785 item states in 55868 ms.
2009-08-27 10:50:37,310 Average time to process an item state: 14 ms.
2009-08-27 10:50:37,310
2009-08-27 10:50:37,310 Importing "HistoricBasis" items...
2009-08-27 10:51:16,307 Updating database stats...
2009-08-27 10:51:34,561 Updated database stats in 18254 ms.
2009-08-27 10:54:11,558 Imported 14096 HistoricBasis items, 14096 item states in 214248 ms.
2009-08-27 10:54:11,559 Average time to process an item state: 15 ms.
2009-08-27 10:54:11,559
2009-08-27 10:54:11,559 Importing "RepositoryProgressMonitor" items...
2009-08-27 10:54:11,848 Imported 0 RepositoryProgressMonitor items, 0 item states in 289 ms.
2009-08-27 10:54:11,848 Skipped 3 RepositoryProgressMonitor items, 3 item states
2009-08-27 10:54:11,848 Average time to process an item state: 96 ms.
2009-08-27 10:54:11,848
2009-08-27 10:54:11,848 Importing "ChangeSet" items...
2009-08-27 11:31:35,047 Updating database stats...
2009-08-27 11:31:51,050 Updated database stats in 16003 ms.
2009-08-27 12:11:18,422 Imported 3892 ChangeSet items, 24630 item states in 4626574 ms.
2009-08-27 12:11:18,423 Average time to process an item state: 187 ms.
2009-08-27 12:11:18,423
2009-08-27 12:11:18,423 Importing "Component" items...
2009-08-27 12:11:20,569 Imported 58 Component items, 65 item states in 2146 ms.
2009-08-27 12:11:20,570 Average time to process an item state: 33 ms.
2009-08-27 12:11:20,570
2009-08-27 12:11:20,570 Importing "Baseline" items...
2009-08-27 12:12:45,401 Imported 5716 Baseline items, 5718 item states in 84831 ms.
2009-08-27 12:12:45,401 Average time to process an item state: 14 ms.
2009-08-27 12:12:45,401
2009-08-27 12:12:45,401 Importing "Folder" items...
2009-08-27 12:15:31,144 Imported 13009 Folder items, 13284 item states in 165743 ms.
2009-08-27 12:15:31,144 Average time to process an item state: 12 ms.
2009-08-27 12:15:31,144
2009-08-27 12:15:31,144 Importing "IterationPlanRecord" items...
2009-08-27 12:15:44,143 Imported 56 IterationPlanRecord items, 722 item states in 12999 ms.
2009-08-27 12:15:44,143 Average time to process an item state: 18 ms.
2009-08-27 12:15:44,143
2009-08-27 12:15:44,143 Importing "QueryDescriptor" items...
2009-08-27 12:16:06,463 Imported 537 QueryDescriptor items, 955 item states in 22320 ms.
2009-08-27 12:16:06,463 Average time to process an item state: 23 ms.
2009-08-27 12:16:06,463
2009-08-27 12:16:06,463 Importing "ContributorAbsence" items...
2009-08-27 12:16:06,792 Imported 23 ContributorAbsence items, 24 item states in 329 ms.
2009-08-27 12:16:06,792 Average time to process an item state: 13 ms.
2009-08-27 12:16:06,792
2009-08-27 12:16:06,792 Importing "ContributorResourceDetails" items...
2009-08-27 12:16:07,507 Imported 14 ContributorResourceDetails items, 24 item states in 715 ms.
2009-08-27 12:16:07,508 Average time to process an item state: 29 ms.
2009-08-27 12:16:07,508
2009-08-27 12:16:07,508 Importing "WorkResourceDetails" items...
2009-08-27 12:16:08,132 Imported 47 WorkResourceDetails items, 51 item states in 624 ms.
2009-08-27 12:16:08,133 Average time to process an item state: 12 ms.
2009-08-27 12:16:08,133
2009-08-27 12:16:08,133 Importing "WikiPageAttachment" items...
2009-08-27 12:16:08,260 Imported 3 WikiPageAttachment items, 3 item states in 126 ms.
2009-08-27 12:16:08,260 Average time to process an item state: 42 ms.
2009-08-27 12:16:08,260
2009-08-27 12:16:08,260 Importing "WikiPage" items...
2009-08-27 12:16:11,856 Imported 57 WikiPage items, 156 item states in 3596 ms.
2009-08-27 12:16:11,857 Average time to process an item state: 23 ms.
2009-08-27 12:16:11,857
2009-08-27 12:16:11,857 Importing "Dashboard" items...
2009-08-27 12:16:17,568 Imported 180 Dashboard items, 180 item states in 5711 ms.
2009-08-27 12:16:17,569 Average time to process an item state: 31 ms.
2009-08-27 12:16:17,569
2009-08-27 12:16:17,569 Importing "DashboardContributorInfo" items...
2009-08-27 12:16:22,116 Imported 233 DashboardContributorInfo items, 233 item states in 4547 ms.
2009-08-27 12:16:22,116 Average time to process an item state: 19 ms.
2009-08-27 12:16:22,116
2009-08-27 12:16:22,116 Importing "JUnitTestSuiteContribution" items...
2009-08-27 12:16:52,597 Imported 2116 JUnitTestSuiteContribution items, 2116 item states in 30481 ms.
2009-08-27 12:16:52,597 Average time to process an item state: 14 ms.
2009-08-27 12:16:52,598
2009-08-27 12:16:52,598 Importing "BuildEngineActivity" items...
2009-08-27 12:16:52,786 Imported 12 BuildEngineActivity items, 12 item states in 188 ms.
2009-08-27 12:16:52,786 Average time to process an item state: 15 ms.
2009-08-27 12:16:52,786
2009-08-27 12:16:52,787 Importing "JUnitTestClass" items...
2009-08-27 12:17:25,354 Imported 1978 JUnitTestClass items, 1978 item states in 32567 ms.
2009-08-27 12:17:25,354 Average time to process an item state: 16 ms.
2009-08-27 12:17:25,354
2009-08-27 12:17:25,354 Importing "BuildAverageData" items...
2009-08-27 12:17:25,971 Imported 25 BuildAverageData items, 25 item states in 617 ms.
2009-08-27 12:17:25,971 Average time to process an item state: 24 ms.
2009-08-27 12:17:25,971
2009-08-27 12:17:25,971 Importing "BuildResultContributions" items...
2009-08-27 12:21:51,053 Updating database stats...
2009-08-27 12:22:13,843 Updated database stats in 22790 ms.
2009-08-27 12:24:35,310 Imported 29318 BuildResultContributions items, 29318 item states in 429339 ms.
2009-08-27 12:24:35,311 Average time to process an item state: 14 ms.
2009-08-27 12:24:35,311
2009-08-27 12:24:35,311 Importing "BuildActivities" items...
2009-08-27 12:24:37,380 Imported 75 BuildActivities items, 75 item states in 2069 ms.
2009-08-27 12:24:37,380 Average time to process an item state: 27 ms.
2009-08-27 12:24:37,380
2009-08-27 12:24:37,380 Importing "BuildResult" items...
2009-08-27 12:24:40,601 Imported 75 BuildResult items, 329 item states in 3221 ms.
2009-08-27 12:24:40,601 Average time to process an item state: 9 ms.
2009-08-27 12:24:40,601
2009-08-27 12:24:40,601 Importing "BuildEngine" items...
2009-08-27 12:24:42,088 Imported 12 BuildEngine items, 104 item states in 1487 ms.
2009-08-27 12:24:42,089 Average time to process an item state: 14 ms.
2009-08-27 12:24:42,089
2009-08-27 12:24:42,089 Importing "BuildDefinition" items...
2009-08-27 12:24:48,103 Imported 25 BuildDefinition items, 375 item states in 6014 ms.
2009-08-27 12:24:48,103 Average time to process an item state: 16 ms.
2009-08-27 12:24:48,103
2009-08-27 12:24:48,103 Importing "BuildRequest" items...
2009-08-27 12:24:50,830 "Simple files" were found in the exported database but will not be imported. Simple files are no longer supported and there is no replacement. If you need to recover the simple files that were in your database, you will need to start up an old version of the server on your old database, connect with an Eclipse client, and then save the files to a local hard disk using the "Simple Files" view. Note that simple files with names like "eclipse.process.ibm.com.zip" and "openup.process.eclipse.org.zip" are likely leftovers from previous versions of the Eclipse Way and OpenUp process templates and can safely be ignored. The list of affected files follows.
2009-08-27 12:24:50,832 Simple file found, but not imported: Jazz_SCM_Workflow.jpg
2009-08-27 12:24:50,895 Imported 75 BuildRequest items, 147 item states in 2792 ms.
2009-08-27 12:24:50,895 Average time to process an item state: 18 ms.
2009-08-27 12:24:50,895
2009-08-27 12:24:50,895 Importing "AuditableLink" items...
2009-08-27 12:33:53,898 Imported 35689 AuditableLink items, 35689 item states in 543002 ms.
2009-08-27 12:33:53,898 Average time to process an item state: 15 ms.
2009-08-27 12:33:53,898
2009-08-27 12:33:53,898 Importing "ReportDescriptor" items...
2009-08-27 12:34:55,273 Imported 776 ReportDescriptor items, 776 item states in 61375 ms.
2009-08-27 12:34:55,273 Average time to process an item state: 79 ms.
2009-08-27 12:34:55,273
2009-08-27 12:34:55,273 Importing "FolderDescriptor" items...
2009-08-27 12:34:56,912 Imported 80 FolderDescriptor items, 80 item states in 1638 ms.
2009-08-27 12:34:56,912 Average time to process an item state: 20 ms.
2009-08-27 12:34:56,912
2009-08-27 12:34:56,912 Importing "ReportQueryDescriptor" items...
2009-08-27 12:35:05,434 Imported 450 ReportQueryDescriptor items, 450 item states in 8522 ms.
2009-08-27 12:35:05,434 Average time to process an item state: 18 ms.
2009-08-27 12:35:05,434
2009-08-27 12:35:05,434 Importing "FileItem" items...
2009-08-27 12:39:44,517 Item import took more than 20000 ms : _fSebsSSNEd6XyfoxZs9j8A in 23060 ms.
2009-08-27 12:47:38,266 Item import took more than 20000 ms : _dBRuocu4Ed271pcvrpTe1g in 25288 ms.
2009-08-27 13:18:43,119 Item import took more than 20000 ms : _LcfwIV9vEd6XasXHNXjFbA in 28589 ms.
2009-08-27 13:22:13,947 Updating database stats...
2009-08-27 13:22:51,547 Updated database stats in 37600 ms.
2009-08-27 13:33:22,230 Imported 70005 FileItem items, 110973 item states in 3496796 ms.
2009-08-27 13:33:22,231 Average time to process an item state: 31 ms.
2009-08-27 13:33:22,231
2009-08-27 13:33:22,231
Importing data com.ibm.team.datawarehouse/Jazz_FS51yk...
2009-08-27 13:41:08,688 Imported com.ibm.team.datawarehouse/Jazz_FS51yk in 466457ms.
2009-08-27 13:41:08,689
2009-08-27 13:41:08,690 Importing deferred items...
2009-08-27 13:56:19,810 Finished importing deferred items.

2009-08-27 13:56:19,810 Rebuilding indices...
2009-08-27 14:00:22,308 End rebuilding indices.
2009-08-27 14:00:22,368 Running post import for "com.ibm.team.repository" component...
2009-08-27 14:00:22,369 Post Import for com.ibm.team.repository took 1 ms.

2009-08-27 14:00:22,369 Running post import for "com.ibm.team.process" component...
2009-08-27 14:00:42,962 Post Import for com.ibm.team.process took 20593 ms.

2009-08-27 14:00:42,962 Running post import for "com.ibm.team.interop" component...
2009-08-27 14:14:04,843 Post Import for com.ibm.team.interop took 801881 ms.

2009-08-27 14:14:04,844 Running post import for "com.ibm.team.workitem" component...
2009-08-27 14:17:01,656 Post Import for com.ibm.team.workitem took 176812 ms.

2009-08-27 14:17:01,657 Running post import for "com.ibm.team.scm" component...
2009-08-27 14:17:01,658 Post Import for com.ibm.team.scm took 1 ms.

2009-08-27 14:17:01,658 Running post import for "com.ibm.team.apt" component...
2009-08-27 14:17:06,347 Post Import for com.ibm.team.apt took 4689 ms.

2009-08-27 14:17:06,347 Running post import for "com.ibm.team.workitem.query" component...
2009-08-27 14:17:06,347 Post Import for com.ibm.team.workitem.query took 0 ms.

2009-08-27 14:17:06,347 Running post import for "com.ibm.team.apt.resource" component...
2009-08-27 14:17:06,347 Post Import for com.ibm.team.apt.resource took 0 ms.

2009-08-27 14:17:06,347 Running post import for "com.ibm.team.foundation.wiki" component...
2009-08-27 14:17:07,704 Post Import for com.ibm.team.foundation.wiki took 1357 ms.

2009-08-27 14:17:07,704 Running post import for "com.ibm.team.dashboard" component...
2009-08-27 14:17:10,930 Unable to locate report parameters map for report id: build.MicroCodeCoverage
2009-08-27 14:17:10,931 Unable to locate report parameters map for report id: build.MicroStaticAnalysis
2009-08-27 14:17:27,869 Post Import for com.ibm.team.dashboard took 20165 ms.

2009-08-27 14:17:27,869 Running post import for "com.ibm.team.build" component...
2009-08-27 14:56:17,261 Post Import for com.ibm.team.build took 2329392 ms.

2009-08-27 14:56:17,261 Running post import for "com.ibm.team.reports" component...
2009-08-27 15:00:31,965 Post Import for com.ibm.team.reports took 254704 ms.

2009-08-27 15:00:31,965 Running post import for "com.ibm.team.links" component...
2009-08-27 15:00:31,965 Post Import for com.ibm.team.links took 0 ms.

2009-08-27 15:00:31,965 Running post import for "com.ibm.team.scm.svn" component...
2009-08-27 15:00:31,966 Post Import for com.ibm.team.scm.svn took 1 ms.

2009-08-27 15:00:31,966 Running post import for "com.ibm.team.filesystem" component...
2009-08-27 15:00:32,005 Post Import for com.ibm.team.filesystem took 39 ms.

2009-08-27 15:00:32,006 Running post import for "Interop WorkItem Manager Migration Handler"...
2009-08-27 15:00:32,006 Post Import for Interop WorkItem Manager Migration Handler took 0 ms.

2009-08-27 15:00:32,006 Running post import for "SCM Work Items Bridge Migration Handler"...
2009-08-27 15:00:32,007 Post Import for SCM Work Items Bridge Migration Handler took 1 ms.

2009-08-27 15:00:32,007 Running post import for "Interop ClearQuest Manager Migration Handler"...
2009-08-27 15:00:32,056 Post Import for Interop ClearQuest Manager Migration Handler took 49 ms.

2009-08-27 15:00:32,056 Running post import for "Full Text Migration Handler"...
2009-08-27 15:00:32,056 Post Import for Full Text Migration Handler took 0 ms.

2009-08-27 15:00:32,056 Post processing change events...
2009-08-27 15:10:37,173 Setting the context for change events took 605116ms.
2009-08-27 15:10:37,173
Deleting migration data store...
2009-08-27 15:10:41,161 Deleted migration data store in 3988 ms.
2009-08-27 15:10:41,181
Verifying the repository contents using verification level 1.
2009-08-27 15:10:41,182 Verifying items present in the "com.ibm.team.interop" component.
2009-08-27 15:10:43,338 Verifying items present in the "com.ibm.team.process" component.
2009-08-27 15:10:56,114 Verifying items present in the "com.ibm.team.workitem" component.
2009-08-27 15:10:58,883 Verifying items present in the "com.ibm.team.repository" component.
2009-08-27 15:11:09,879 Verifying context of com.ibm.team.repository/ChangeEvent items...
2009-08-27 15:11:13,564 Verifying context of com.ibm.team.repository/LicenseType items...
2009-08-27 15:11:13,577 Verifying context of com.ibm.team.repository/LicenseAssignment items...
2009-08-27 15:11:13,723 Verifying context of com.ibm.team.repository/ContributorDetails items...
2009-08-27 15:11:13,837 Verifying context of com.ibm.team.repository/AuditableBaseline items...
2009-08-27 15:11:13,870 Verifying context of com.ibm.team.repository/RepositoryRoot items...
2009-08-27 15:11:13,897 Verifying context of com.ibm.team.repository/Contributor items...
2009-08-27 15:11:13,970 Verifying context of com.ibm.team.repository/ServerVersionRecord items...
2009-08-27 15:11:13,988 Verifying context of com.ibm.team.process/ProcessChangeEventCheck items...
2009-08-27 15:11:14,017 Verifying context of com.ibm.team.process/ProjectArea items...
2009-08-27 15:11:14,050 Verifying context of com.ibm.team.process/TeamArea items...
2009-08-27 15:11:14,059 Verifying context of com.ibm.team.process/ProcessDefinition items...
2009-08-27 15:11:14,125 Verifying context of com.ibm.team.process/ProcessDomainDefinition items...
2009-08-27 15:11:14,152 Verifying context of com.ibm.team.process/DevelopmentLine items...
2009-08-27 15:11:14,165 Verifying context of com.ibm.team.process/Iteration items...
2009-08-27 15:11:14,206 Verifying context of com.ibm.team.process/IterationType items...
2009-08-27 15:11:14,214 Verifying context of com.ibm.team.process/ProcessAttachment items...
2009-08-27 15:11:14,327 Verifying context of com.ibm.team.process/ReadAccessList items...
2009-08-27 15:11:14,341 Verifying context of com.ibm.team.process/ProjectLink items...
2009-08-27 15:11:14,347 Verifying context of com.ibm.team.process/ProcessGenericItem items...
2009-08-27 15:11:14,367 Verifying context of com.ibm.team.interop/SyncInfo items...
2009-08-27 15:11:14,384 Verifying context of com.ibm.team.interop/ExternalRepositoryConnection items...
2009-08-27 15:11:14,406 Verifying context of com.ibm.team.interop/ExternalProxy items...
2009-08-27 15:11:17,345 Verifying context of com.ibm.team.interop/SyncRule items...
2009-08-27 15:11:17,358 Verifying context of com.ibm.team.interop/ExternalState items...
2009-08-27 15:11:18,656 Verifying context of com.ibm.team.workitem/Deliverable items...
2009-08-27 15:11:18,688 Verifying context of com.ibm.team.workitem/WorkItem items...
2009-08-27 15:11:19,579 Verifying context of com.ibm.team.workitem/Category items...
2009-08-27 15:11:19,643 Verifying context of com.ibm.team.workitem/Attribute items...
2009-08-27 15:11:19,709 Verifying context of com.ibm.team.workitem/Attachment items...
2009-08-27 15:11:19,790 Verifying context of com.ibm.team.opaque/Opaque items...
2009-08-27 15:11:19,810 Verifying context of com.ibm.team.apt/SharedPlanMode items...
2009-08-27 15:11:19,819 Verifying context of com.ibm.team.apt/IterationPlanRecord items...
2009-08-27 15:11:19,859 Verifying context of com.ibm.team.workitem.query/QueryDescriptor items...
2009-08-27 15:11:19,950 Verifying context of com.ibm.team.apt.resource/ContributorAbsence items...
2009-08-27 15:11:19,975 Verifying context of com.ibm.team.apt.resource/ContributorResourceDetails items...
2009-08-27 15:11:19,995 Verifying context of com.ibm.team.apt.resource/WorkResourceDetails items...
2009-08-27 15:11:20,008 Verifying context of com.ibm.team.foundation.wiki/WikiPageAttachment items...
2009-08-27 15:11:20,071 Verifying context of com.ibm.team.foundation.wiki/WikiPage items...
2009-08-27 15:11:20,087 Verifying context of com.ibm.team.dashboard/Dashboard items...
2009-08-27 15:11:20,172 Verifying context of com.ibm.team.dashboard/DashboardContributorInfo items...
2009-08-27 15:11:20,555 Verifying context of com.ibm.team.build/CompileContribution items...
2009-08-27 15:11:20,585 Verifying context of com.ibm.team.build/JUnitTestSuiteContribution items...
2009-08-27 15:11:22,281 Verifying context of com.ibm.team.build/BuildEngineActivity items...
2009-08-27 15:11:22,297 Verifying context of com.ibm.team.build/JUnitTestClass items...
2009-08-27 15:11:22,522 Verifying context of com.ibm.team.build/BuildAverageData items...
2009-08-27 15:11:22,533 Verifying context of com.ibm.team.build/CompilePackage items...
2009-08-27 15:11:22,546 Verifying context of com.ibm.team.build/BuildResultContributions items...
2009-08-27 15:11:22,900 Verifying context of com.ibm.team.build/BuildActivities items...
2009-08-27 15:11:22,917 Verifying context of com.ibm.team.build/BuildResult items...
2009-08-27 15:11:22,938 Verifying context of com.ibm.team.build/BuildEngine items...
2009-08-27 15:11:22,944 Verifying context of com.ibm.team.build/BuildDefinition items...
2009-08-27 15:11:22,962 Verifying context of com.ibm.team.build/BuildRequest items...
2009-08-27 15:11:22,976 Verifying context of com.ibm.team.reports/ReportDescriptor items...
2009-08-27 15:11:23,130 Verifying context of com.ibm.team.reports/FolderDescriptor items...
2009-08-27 15:11:23,236 Verifying context of com.ibm.team.reports/ReportQueryDescriptor items...
2009-08-27 15:11:23,317 Verifying context of com.ibm.team.links/AuditableLink items...
2009-08-27 15:11:26,417 Verifying context of com.ibm.team.scm.svn/SvnRepository items...
2009-08-27 15:11:26,432 Verifying items present in the "com.ibm.team.scm" component.
2009-08-27 15:11:55,794 CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: SELECT ss.JZ_ITEM_DISCRIMINATOR, ss.ITEM_ITEM_ID, ss.STATE_COL, ss.JZ_PARENT_ID FROM SCM.CONFIGURATION_SELECTIONS ss LEFT OUTER JOIN REPOSITORY.ITEM_STATES v ON v.KEY_UUID = ss.STATE_COL WHERE ss.STATE_COL IS NOT NULL AND v.KEY_UUID IS NULL
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-1218, SQLSTATE=57011, SQLERRMC=4097, DRIVER=3.53.70
SQL State: 57011
Error Code: -1218

com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-1218, SQLSTATE=57011, SQLERRMC=4097, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:679)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.ul.b(ul.java:3712)
at com.ibm.db2.jcc.b.ul.a(ul.java:3694)
at com.ibm.db2.jcc.t4.db.a(db.java:730)
at com.ibm.db2.jcc.t4.db.m(db.java:719)
at com.ibm.db2.jcc.t4.db.i(db.java:244)
at com.ibm.db2.jcc.t4.db.c(db.java:52)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.sb.i(sb.java:153)
at com.ibm.db2.jcc.b.fm.db(fm.java:1974)
at com.ibm.db2.jcc.b.gm.e(gm.java:3311)
at com.ibm.db2.jcc.b.gm.Qb(gm.java:576)
at com.ibm.db2.jcc.b.gm.executeQuery(gm.java:550)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.scm.admin.server.SCMAdminServiceInternal.getScmSanityReport(SCMAdminServiceInternal.java:1427)
at com.ibm.team.scm.admin.server.SCMAdminService$7.run(SCMAdminService.java:231)
at com.ibm.team.scm.admin.server.SCMAdminService$7.run(SCMAdminService.java:1)
at com.ibm.team.scm.admin.server.SCMAdminService$2.run(SCMAdminService.java:140)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:328)
at sun.reflect.GeneratedMethodAccessor28.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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy286.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor34.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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy317.runInTransaction(Unknown Source)
at com.ibm.team.scm.admin.server.SCMAdminService.runInTransaction(SCMAdminService.java:137)
at com.ibm.team.scm.admin.server.SCMAdminService.getScmSanityReport(SCMAdminService.java:228)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy335.getScmSanityReport(Unknown Source)
at com.ibm.team.scm.service.internal.migration.ScmVerifierExtensionService.verify(ScmVerifierExtensionService.java:157)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy557.verify(Unknown Source)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verifyComponent(RepositoryVerificationService.java:96)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verify(RepositoryVerificationService.java:78)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy287.verify(Unknown Source)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.verifyRepository(AbstractMigrationService.java:1221)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerifyPreserve(AbstractMigrationService.java:714)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:651)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy360.importRepositoryOptionalVerify(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.importData(ImportCommand.java:153)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.execute(ImportCommand.java:114)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:161)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:671)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:702)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
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:386)
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:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
2009-08-27 15:11:55,799 CRRTC5003 SCMVerifier Error encountered in verification of states to query properties
com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: SELECT ss.JZ_ITEM_DISCRIMINATOR, ss.ITEM_ITEM_ID, ss.STATE_COL, ss.JZ_PARENT_ID FROM SCM.CONFIGURATION_SELECTIONS ss LEFT OUTER JOIN REPOSITORY.ITEM_STATES v ON v.KEY_UUID = ss.STATE_COL WHERE ss.STATE_COL IS NOT NULL AND v.KEY_UUID IS NULL
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-1218, SQLSTATE=57011, SQLERRMC=4097, DRIVER=3.53.70
SQL State: 57011
Error Code: -1218

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.executeQuery(PreparedStatementErrLogWrapper.java:77)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.scm.admin.server.SCMAdminServiceInternal.getScmSanityReport(SCMAdminServiceInternal.java:1427)
at com.ibm.team.scm.admin.server.SCMAdminService$7.run(SCMAdminService.java:231)
at com.ibm.team.scm.admin.server.SCMAdminService$7.run(SCMAdminService.java:1)
at com.ibm.team.scm.admin.server.SCMAdminService$2.run(SCMAdminService.java:140)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:328)
at sun.reflect.GeneratedMethodAccessor28.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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy286.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor34.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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy317.runInTransaction(Unknown Source)
at com.ibm.team.scm.admin.server.SCMAdminService.runInTransaction(SCMAdminService.java:137)
at com.ibm.team.scm.admin.server.SCMAdminService.getScmSanityReport(SCMAdminService.java:228)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy335.getScmSanityReport(Unknown Source)
at com.ibm.team.scm.service.internal.migration.ScmVerifierExtensionService.verify(ScmVerifierExtensionService.java:157)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy557.verify(Unknown Source)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verifyComponent(RepositoryVerificationService.java:96)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verify(RepositoryVerificationService.java:78)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy287.verify(Unknown Source)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.verifyRepository(AbstractMigrationService.java:1221)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerifyPreserve(AbstractMigrationService.java:714)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:651)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy360.importRepositoryOptionalVerify(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.importData(ImportCommand.java:153)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.execute(ImportCommand.java:114)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:161)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:671)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:702)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
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:386)
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:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Caused by:
com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-1218, SQLSTATE=57011, SQLERRMC=4097, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:679)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.ul.b(ul.java:3712)
at com.ibm.db2.jcc.b.ul.a(ul.java:3694)
at com.ibm.db2.jcc.t4.db.a(db.java:730)
at com.ibm.db2.jcc.t4.db.m(db.java:719)
at com.ibm.db2.jcc.t4.db.i(db.java:244)
at com.ibm.db2.jcc.t4.db.c(db.java:52)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.sb.i(sb.java:153)
at com.ibm.db2.jcc.b.fm.db(fm.java:1974)
at com.ibm.db2.jcc.b.gm.e(gm.java:3311)
at com.ibm.db2.jcc.b.gm.Qb(gm.java:576)
at com.ibm.db2.jcc.b.gm.executeQuery(gm.java:550)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
... 83 more
2009-08-27 15:11:55,801 CRJAZ1150I ** ERROR ** CRJAZ1145I Error verifying component "com.ibm.team.scm".
java.lang.NullPointerException
at com.ibm.team.scm.service.internal.migration.ScmVerifierExtensionService.verify(ScmVerifierExtensionService.java:166)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy557.verify(Unknown Source)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verifyComponent(RepositoryVerificationService.java:96)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verify(RepositoryVerificationService.java:78)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy287.verify(Unknown Source)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.verifyRepository(AbstractMigrationService.java:1221)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerifyPreserve(AbstractMigrationService.java:714)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:651)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy360.importRepositoryOptionalVerify(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.importData(ImportCommand.java:153)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.execute(ImportCommand.java:114)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:161)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:671)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:702)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
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:386)
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:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
2009-08-27 15:11:55,802 Verifying items present in the "com.ibm.team.apt" component.
2009-08-27 15:11:56,816 Verifying items present in the "com.ibm.team.dashboard" component.
2009-08-27 15:12:01,038 Verifying items present in the "com.ibm.team.build" component.
2009-08-27 15:12:03,893 Verifying items present in the "com.ibm.team.reports" component.
2009-08-27 15:12:07,537 Verifying items present in the "com.ibm.team.filesystem" component.
2009-08-27 15:15:30,093
Imported 243695 items, 341454 item states in 17655186 ms. 1589 item states skipped. Error importing 0 elements.
2009-08-27 15:15:30,093 com.ibm.team.workitem
2009-08-27 15:15:30,093 Attribute : 563 items, 563 item states imported.
2009-08-27 15:15:30,093 WorkItem : 4661 items, 20613 item states imported.
2009-08-27 15:15:30,094 Category : 204 items, 365 item states imported.
2009-08-27 15:15:30,094 Deliverable : 61 items, 83 item states imported.
2009-08-27 15:15:30,094 Attachment : 636 items, 637 item states imported.
2009-08-27 15:15:30,094 com.ibm.team.interop
2009-08-27 15:15:30,094 ExternalProxy : 12870 items, 27159 item states imported.
2009-08-27 15:15:30,094 ExternalState : 12870 items, 14289 item states imported.
2009-08-27 15:15:30,094 com.ibm.team.process
2009-08-27 15:15:30,094 IterationType : 15 items, 15 item states imported.
2009-08-27 15:15:30,094 ProjectArea : 16 items, 444 item states imported.
2009-08-27 15:15:30,094 TeamArea : 43 items, 243 item states imported.
2009-08-27 15:15:30,094 DevelopmentLine : 27 items, 128 item states imported.
2009-08-27 15:15:30,094 ProcessDefinition : 7 items, 41 item states imported.
2009-08-27 15:15:30,094 ProcessAttachment : 318 items, 581 item states imported.
2009-08-27 15:15:30,095 Iteration : 0 items, 234 item states imported.
2009-08-27 15:15:30,095 ProcessChangeEventCheck : 1 items, 1 item states imported.
2009-08-27 15:15:30,095 com.ibm.team.repository
2009-08-27 15:15:30,095 Contributor : 655 items, 1129 item states imported.
2009-08-27 15:15:30,095 ContributorDetails : 655 items, 873 item states imported.
2009-08-27 15:15:30,095 LicenseAssignment : 944 items, 944 item states imported.
2009-08-27 15:15:30,095 RepositoryRoot : 1 items, 8 item states imported.
2009-08-27 15:15:30,095 ChangeEvent : 18664 items, 18664 item states imported.
2009-08-27 15:15:30,095 LicenseType : 9 items, 9 item states imported.
2009-08-27 15:15:30,095 com.ibm.team.apt
2009-08-27 15:15:30,095 IterationPlanRecord : 56 items, 722 item states imported.
2009-08-27 15:15:30,095 com.ibm.team.scm
2009-08-27 15:15:30,095 ChangeHistory : 7379 items, 7379 item states imported.
2009-08-27 15:15:30,095 Component : 58 items, 65 item states imported.
2009-08-27 15:15:30,095 Suspended : 17 items, 17 item states imported.
2009-08-27 15:15:30,095 Baseline : 5716 items, 5718 item states imported.
2009-08-27 15:15:30,096 ChangeSet : 3892 items, 24630 item states imported.
2009-08-27 15:15:30,096 HistoricBasis : 14096 items, 14096 item states imported.
2009-08-27 15:15:30,096 BaselineSet : 3785 items, 3785 item states imported.
2009-08-27 15:15:30,096 ComponentEntry : 532 items, 532 item states imported.
2009-08-27 15:15:30,096 Configuration : 0 items, 0 item states imported.
2009-08-27 15:15:30,096 Workspace : 130 items, 130 item states imported.
2009-08-27

4 answers



permanent link
Sunil Kumar Perla (71143) | answered Aug 27 '09, 6:40 p.m.
2009-08-27 15:15:30,096 Workspace : 130 items, 130 item states imported.
2009-08-27 15:15:30,096 RepositoryProgressMonitor : 0 items, 0 item states imported.
2009-08-27 15:15:30,096 Folder : 13009 items, 13284 item states imported.
2009-08-27 15:15:30,096 com.ibm.team.workitem.query
2009-08-27 15:15:30,096 QueryDescriptor : 537 items, 955 item states imported.
2009-08-27 15:15:30,096 com.ibm.team.apt.resource
2009-08-27 15:15:30,096 WorkResourceDetails : 47 items, 51 item states imported.
2009-08-27 15:15:30,096 ContributorResourceDetails : 14 items, 24 item states imported.
2009-08-27 15:15:30,096 ContributorAbsence : 23 items, 24 item states imported.
2009-08-27 15:15:30,096 com.ibm.team.dashboard
2009-08-27 15:15:30,096 Dashboard : 180 items, 180 item states imported.
2009-08-27 15:15:30,096 DashboardContributorInfo : 233 items, 233 item states imported.
2009-08-27 15:15:30,097 com.ibm.team.foundation.wiki
2009-08-27 15:15:30,097 WikiPage : 57 items, 156 item states imported.
2009-08-27 15:15:30,097 WikiPageAttachment : 3 items, 3 item states imported.
2009-08-27 15:15:30,097 com.ibm.team.build
2009-08-27 15:15:30,097 BuildResult : 75 items, 329 item states imported.
2009-08-27 15:15:30,097 BuildRequest : 75 items, 147 item states imported.
2009-08-27 15:15:30,097 BuildEngine : 12 items, 104 item states imported.
2009-08-27 15:15:30,097 BuildResultContributions : 29318 items, 29318 item states imported.
2009-08-27 15:15:30,097 BuildActivities : 75 items, 75 item states imported.
2009-08-27 15:15:30,097 JUnitTestClass : 1978 items, 1978 item states imported.
2009-08-27 15:15:30,097 BuildEngineActivity : 12 items, 12 item states imported.
2009-08-27 15:15:30,097 JUnitTestSuiteContribution : 2116 items, 2116 item states imported.
2009-08-27 15:15:30,097 BuildAverageData : 25 items, 25 item states imported.
2009-08-27 15:15:30,097 BuildDefinition : 25 items, 375 item states imported.
2009-08-27 15:15:30,097 com.ibm.team.reports
2009-08-27 15:15:30,097 ReportDescriptor : 776 items, 776 item states imported.
2009-08-27 15:15:30,098 FolderDescriptor : 80 items, 80 item states imported.
2009-08-27 15:15:30,098 ReportQueryDescriptor : 450 items, 450 item states imported.
2009-08-27 15:15:30,098 com.ibm.team.links
2009-08-27 15:15:30,098 AuditableLink : 35689 items, 35689 item states imported.
2009-08-27 15:15:30,098 com.ibm.team.filesystem
2009-08-27 15:15:30,098 FileItem : 70005 items, 110973 item states imported.
2009-08-27 15:15:30,098
2009-08-27 15:15:30,098
2009-08-27 15:15:30,098 ##############################################################################################
2009-08-27 15:15:30,098 ****** Migration Errors ******
2009-08-27 15:15:30,098 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 "/opt/IBM/JazzTeamServer/server/repotools_import.log" for details.
2009-08-27 15:15:30,098 ##############################################################################################
2009-08-27 15:15:30,108 The user "ADMIN" has logged out of the database "//ips-db.swg.usma.ibm.com:50000/ipsrtc:user=xxxxxxxx;password=xxxxxxxx;".


Repotools verify completed without any errors after that. Does this mean my database is good?

Any help on fixing the errors reported in the log would be much appreciated.

Thanks
Sunil

permanent link
Kevin Ramer (4.5k8183200) | answered Aug 29 '09, 10:53 a.m.
Issues migrating from RTC 1.x Std Ed to 2.0 Ent Ed.

- Exported repository using repotools on 1.x
- Importing repository using repotools on 2.x threw some scm and db2 sql errors.

Here is the import log:

--------8<-----8=------8<----------8=--------------------------
2009-08-27 15:11:55,794 CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: SELECT ss.JZ_ITEM_DISCRIMINATOR, ss.ITEM_ITEM_ID, ss.STATE_COL, ss.JZ_PARENT_ID FROM SCM.CONFIGURATION_SELECTIONS ss LEFT OUTER JOIN REPOSITORY.ITEM_STATES v ON v.KEY_UUID = ss.STATE_COL WHERE ss.STATE_COL IS NOT NULL AND v.KEY_UUID IS NULL
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-1218, SQLSTATE=57011, SQLERRMC=4097, DRIVER=3.53.70
SQL State: 57011
Error Code: -1218

com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-1218, SQLSTATE=57011, SQLERRMC=4097, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:679)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)

2009-08-27


DB2 says this about the above:

SQL1218N There are no pages currently available in bufferpool
"<buffpool>".

Explanation:

All of the pages in the bufferpool are currently being used. A
request to use another page failed.

The statement cannot be processed.

User Response:

The bufferpool is not large enough to provide pages to all
database processes or threads at this time. The bufferpool is
too small or there are too many active processes or threads.

The statement may be successful if executed again. If this
error occurs frequently, some or all of the following actions may
prevent further failures:

1. increase the bufferpool size

2. decrease the maximum number of database agents and/or
connections

3. decrease the maximum degree of parallelism

4. decrease the prefetch size for table spaces that are in this
bufferpool

5. move some table spaces into other bufferpools.

sqlcode : -1218

sqlstate : 57011

So for that action the db2 statement is likely to have failed (i.e not
not imported what was intended). To determine exactly what bufferpool
was involved you may have to search in the DB2 instance's sqllib/db2dump/db2diag.log or sqllib/db2dump/INSTANCE.nfy (INSTANCE
will be the instance name).

If your instance is configured to use db2cc you can look at the bufferpools for the database and alter them if necessary.

I cannot address the question if the import is good or bad. I wouldn't trust
it to be good myself.

permanent link
Balaji Krish (1.8k12) | answered Aug 31 '09, 3:44 p.m.
JAZZ DEVELOPER
You need to increase the number of pages in buffer pool.

Let us assume you have x (8K pages), try changing it to 2x and run the import again.

We ran into the same error while running the Jazz 2.0 server. See https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/90336

--- Balaji

permanent link
Sunil Kumar Perla (71143) | answered Aug 31 '09, 5:24 p.m.
Thanks for your help Kevin.

We reran this test migration and it completed successfully (no errors this time). We also completed the actual migration without any errors on Friday. However, we saw many sql errors and deadlock issues post migration and increased the buffer pool size to 4 times its existing value and this resolved all those errors (Balaji helped us with this solution).

We will look into modifying the other parameters you mentioned. Is there a technote / article that talks about configuring databases for RTC apart from the guide mentioning the use of 8K pagesize?

Thanks
Sunil

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.