I attempted to restart the the upgrade taking your suggestion to create a copy of the JTS database. This did not work. I continue to receive similar errors when running the CCM upgrade script. I have included a copy of the errors received in "Step 1" of the upgrade script below. I would be grateful for any suggestions pertaining to this issue in CCM.
Step 1: Add tables
------------------
Directory: "<CLM 5.0 install dir>\server"
Command:
repotools-ccm.bat -addTables
Enter [E] to execute this step, [S] to skip it or hit [Enter] to cancel the scri
pt execution:
e
Repo Tools
Provisioning using "<CLM 5.0 install dir>\server\conf\ccm\provision_profiles"
.
Jazz Foundation - Core Libraries, Version 5.0 M3 (RJF-I20140227-2357)
Change and Configuration Management - Core Libraries, Version 5.0 M3 (RTC-I201
40228-1725)
To submit questions about issues, go to the Jazz.net forum at https://jazz.net/
forum.
To find more information about a message, see the CLM Messages Information Cent
er at
https://jazz.net/help-dev/CLMErrorMessages/index.jsp.
CRJAZ1363I Loading the configuration from "file:conf/ccm/teamserver.properties".
CRJAZ1778I This server is configured as an application.
CRJAZ2558I Setting the local server rename state to false and the openServerDesc
riptionServiceTemporarily state to false.
CRJAZ1365I The server is attempting to connect to the following database: "//loc
alhost:1433;databaseName=CLM_CCM;user=xxxxxxxx;password=xxxxxxxx"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: Microsoft SQL Server
Db Product Version: 11.00.2100
Db URL: jdbc:sqlserver://localhost:1433;databaseName=CLM_CCM;user=xxxxxxxx;pas
sword=xxxxxxxx
Jdbc Driver Name: Microsoft JDBC Driver 4.0 for SQL Server
Jdbc Driver Version: 4.0.2206.100
CRJAZ1970I The application is configured with:
Public URI: "https://nwap9006.nnics.cjis:9443/ccm"
Jazz Team Server location: "https://nwap9006.nnics.cjis:9443/jts/"
CRJAZ2523I Setting the global server rename state to false and the validation st
ate to false.
CRJAZ2105I Checking for a running server...
WARNING: You are about to update the tables for the database "//localhost:1433;d
atabaseName=CLM_CCM;user=xxxxxxxx;password=xxxxxxxx".
This action cannot be undone. Do you wish to continue? Enter Y to confirm.
y
Adding tables to the database "//localhost:1433;databaseName=CLM_CCM;user=xxxxxx
xx;password=xxxxxxxx".
CRJAZ1442I The component model of "com.ibm.team.scm" was updated from "0.42" to
"0.43".
CRJAZ1438I A new attribute "historyGraphNode" was added to class "com.ibm.team.s
cm.common.internal.Configuration".
CRJAZ1438I A new attribute "creationDate" was added to class "com.ibm.team.scm.c
ommon.internal.Baseline".
CRJAZ1438I A new attribute "historyGraphNode" was added to class "com.ibm.team.s
cm.common.internal.Baseline".
CRJAZ1438I A new attribute "historyGraphNode" was added to class "com.ibm.team.s
cm.common.internal.ComponentEntry".
CRJAZ1441I A new component model for "com.ibm.team.vvc" was added.
CRJAZ1442I The component model of "com.ibm.team.build" was updated from "13" to
"14".
CRJAZ1440I A new type "BuildFolder" was added.
CRJAZ1440I A new type "BuildFolderEntry" was added.
CRJAZ1442I The component model of "com.ibm.team.jfs.resource" was updated from "
3" to "8".
CRJAZ1438I A new attribute "changeId" was added to class "com.ibm.team.jfs.resou
rce.internal.Resource".
CRJAZ1440I A new type "Configuration" was added.
CRJAZ1440I A new type "Version" was added.
CRJAZ8192I: Full-text Index Location: <CLM 5.0 install dir>\server\conf\ccm\i
ndices\workitemindex\_Fa77U_WJEeK27d5JyGflCA
CRJAZ2690I New type handler "ChangeHistoryTypeHandler" found for item type "Chan
geHistory". Item DB ID = 30.
CRJAZ2690I New type handler "HistoricBasisTypeHandler" found for item type "Hist
oricBasis". Item DB ID = 36.
CRJAZ2694I Starting online migration for the following models: {"com.ibm.team.bu
ild":["13","14"],"com.ibm.team.jfs.resource":["3","8"],"com.ibm.team.scm":["0.42
","0.43"],"com.ibm.team.vvc":[null,null]}
CRJAZ2693I Running online migration on 0 item states. 0 previously processed.
2 new type handlers.
CRJAZ2691I No more items to process.
CRJAZ2739I No state migration failures occurred during online migration.
CRJAZ2687I Online migration finished.
CRJAZ2696I Starting post-online-migration tasks.
CRJAZ2684I Cleaning table ITEM_STATES.
CRJAZ2740I Removed 0 deleted items from table ITEM_STATES in 140ms.
CRJAZ2683I Cleaned table ITEM_STATES in 156ms.
CRJAZ2684I Cleaning table ITEM_CURRENTS.
CRJAZ2740I Removed 0 deleted items from table ITEM_CURRENTS in 47ms.
CRJAZ2683I Cleaned table ITEM_CURRENTS in 47ms.
CRJAZ2684I Cleaning table ITEM_TYPES.
CRJAZ2740I Removed 0 deleted items from table ITEM_TYPES in 31ms.
CRJAZ2683I Cleaned table ITEM_TYPES in 31ms.
CRJAZ2684I Cleaning table JAZZ.PROPERTIES.
CRJAZ2683I Cleaned table JAZZ.PROPERTIES in 0ms.
CRJAZ2689I Post-online migration finished.
The user "ADMIN" has logged in to the database "//localhost:1433;databaseName=CL
M_CCM;user=xxxxxxxx;password=xxxxxxxx".
Running post addTables for "com.ibm.team.repository"...
CRJAZ2661I The database will now be searched for private contexts missing self r
eferences. Any missing references will be repaired.
Added self references to 0 contexts in 0 ms.
Running post addTables for "com.ibm.team.foundation.wiki"...
Running post addTables for "com.ibm.team.process"...
Running post addTables for "com.ibm.team.apt.resource"...
Running post addTables for "com.ibm.team.repository.auth"...
Running post addTables for "com.ibm.team.workitem.query"...
Running post addTables for "com.ibm.team.scm"...
Running post addTables for "com.ibm.teamz.supa.admin"...
Running post addTables for "com.ibm.team.scm.svn"...
Running post addTables for "com.ibm.team.apt"...
Running post addTables for "com.ibm.team.workitem"...
Items with a protected read access policy must use a valid context that appears
in the context tables. The provided context, "_1fwqEvYiEeKx3pPbAVRPqw", does no
t appear in the context tables.
Items with a protected read access policy must use a valid context that appears
in the context tables. The provided context, "_4PZssPYNEeKx3pPbAVRPqw", does no
t appear in the context tables.
Items with a protected read access policy must use a valid context that appears
in the context tables. The provided context, "_1fwqEvYiEeKx3pPbAVRPqw", does no
t appear in the context tables.
Items with a protected read access policy must use a valid context that appears
in the context tables. The provided context, "_4PZssPYNEeKx3pPbAVRPqw", does no
t appear in the context tables.
WorkItem Migration Status . See the log file "<CLM 5.0 install dir>\s
erver\repotools-ccm_addTables.log" for details.
Synchronization . See the log file "<CLM 5.0 install dir>\ser
ver\repotools-ccm_addTables.log" for details.
Items with a protected read access policy must use a val
id context that appears in the context tables. The provided context, "_1fwqEvYi
EeKx3pPbAVRPqw", does not appear in the context tables. Items with a protected r
ead access policy must use a valid context that appears in the context tables.
The provided context, "_1fwqEvYiEeKx3pPbAVRPqw", does not appear in the context
tables.. See the log file "<CLM 5.0 install dir>\server\repotools-ccm_addTabl
es.log" for details.
Items with a protected read access policy must use a val
id context that appears in the context tables. The provided context, "_4PZssPYN
EeKx3pPbAVRPqw", does not appear in the context tables. Items with a protected r
ead access policy must use a valid context that appears in the context tables.
The provided context, "_4PZssPYNEeKx3pPbAVRPqw", does not appear in the context
tables.. See the log file "<CLM 5.0 install dir>\server\repotools-ccm_addTabl
es.log" for details.
Synchronization . See the log file "<CLM 5.0 install dir>\ser
ver\repotools-ccm_addTables.log" for details.
Items with a protected read access policy must use a val
id context that appears in the context tables. The provided context, "_1fwqEvYi
EeKx3pPbAVRPqw", does not appear in the context tables. Items with a protected r
ead access policy must use a valid context that appears in the context tables.
The provided context, "_1fwqEvYiEeKx3pPbAVRPqw", does not appear in the context
tables.. See the log file "<CLM 5.0 install dir>\server\repotools-ccm_addTabl
es.log" for details.
Items with a protected read access policy must use a val
id context that appears in the context tables. The provided context, "_4PZssPYN
EeKx3pPbAVRPqw", does not appear in the context tables. Items with a protected r
ead access policy must use a valid context that appears in the context tables.
The provided context, "_4PZssPYNEeKx3pPbAVRPqw", does not appear in the context
tables.. See the log file "<CLM 5.0 install dir>\server\repotools-ccm_addTabl
es.log" for details.
Running post addTables for "com.ibm.team.workitem.linkClosure"...
Running post addTables for "com.ibm.team.build"...
Running post addTables for "com.ibm.team.markers"...
Running post addTables for "com.ibm.team.jfs.resource"...
Running post addTables for "com.ibm.team.links"...
Running post addTables for "com.ibm.team.interop"...
Running post addTables for "com.ibm.teami.scm"...
Running post addTables for "com.ibm.team.reports"...
Running post addTables for "com.ibm.team.filesystem"...
Running post addTables for "com.ibm.team.apt.snapshot"...
Running post addTables for "com.ibm.team.repository.friends"...
Running post addTables for "SCM Work Items Bridge Migration Handler"...
Running post addTables for "Interop ClearQuest Manager Migration Handler"...
Running post addTables for "Interop WorkItem Manager Migration Handler"...
Running post addTables for "Full Text Migration Handler"...
The user "ADMIN" has logged out of the database "//localhost:1433;databaseName=C
LM_CCM;user=xxxxxxxx;password=xxxxxxxx".
CRJAZ1791E The migration completed with errors. The imported database is unstabl
e and should not be used without further analysis.
The ccm upgrade failed at step 1. Correct the problem and run the script again
starting at step 1.
