E
dit
A
ttach
P
rintable
r2 - 2019-06-05 - 16:56:42 - Main.wbchen
You are here:
TWiki
>
Deployment Web
>
DeploymentInstallingUpgradingAndMigrating
>
QMAddTablesFailedOn6061Upgrade
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! QM addTables command can fail on 6.0.6.1 upgrade <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/todo.png" alt="todo.png" width="50" height="50" align="right"> %DKGRAY% Authors: Main.WilliamChen <br> Build basis: IBM Rational Quality Manager 6.0.x. %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> This wiki page provides detailed steps to resolve an addTables command error during 6.0.6.1 upgrade. This known issue is being tracked via Jazz defect [[https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=482936][482936.]] The failure was only observed on two separate instances. *Important*: Consult an DBA before running queries from steps 2 through 5. ---+++ Step 1 - Check QM addTables log This example is from DB2 database: <verbatim> 2019-05-14 10:49:13,496 The user "ADMIN" has logged out of the database "//dbServer:port/instanceName:user=xxxxxxxx;password=xxxxxxxx;". 2019-05-14 10:49:13,496 CRJAZ3138E The total number of rows copied to the new version table, REPOSITORY.VERSION, does not match the total number of rows of the older version table(s). 2019-05-14 10:49:13,497 CRJAZ3138E The total number of rows copied to the new version table, REPOSITORY.VERSION, does not match the total number of rows of the older version table(s). com.ibm.team.repository.common.TeamRepositoryException: CRJAZ3138E The total number of rows copied to the new version table, REPOSITORY.VERSION, does not match the total number of rows of the older version table(s). 2019-05-14 10:49:13,498 CRJAZ1791E The migration completed with errors. The imported database is unstable and should not be used without further analysis. </verbatim> ---+++ Step 2 - Run these two queries to check if there is a mismatch <verbatim> select count(*) from [qm database name].[EXECUTION].[VEXECUTION_RECORD] </verbatim> <verbatim> select count(*) from [qm database name].[EXECUTION].[VEXECUTION_RECORD] join [qm database name].[REPOSITORY].[ITEM_TYPES] on [qm database name].[REPOSITORY].[ITEM_TYPES].[ITEM_UUID]= [qm database name].[EXECUTION].[VEXECUTION_RECORD].[ITEM_ID] </verbatim> Note: Be sure to replace [qm database name] with valid QM database name. The total number of rows should be different if there is a mismatch. ---+++ Step 3 - Restore QM database This must be done before proceeding to step 4. ---+++ Step 4 - Run this custom insert command <verbatim> insert into REPOSITORY.ITEM_TYPES select distinct REPOSITORY.ITEM_STATES.ITEM_UUID, REPOSITORY.ITEM_STATES.ITEM_TYPE_DBID from EXECUTION.VEXECUTION_RECORD join REPOSITORY.ITEM_STATES on ITEM_ID=ITEM_UUID where ITEM_ID not in ( select ITEM_UUID from REPOSITORY.ITEM_TYPES) </verbatim> This custom insert command should correct the row count discrepancy. Please use next step to verify the information. ---+++ Step 5 - Repeat step 2 to confirm there is no mismatch Run both queries again to confirm there is no mismatch. Then complete the remaining 6.0.6.1 upgrade steps. ---+++++!! Related topics: [[DeploymentWebHome][Deployment web home]], [[DeploymentWebHome][Deployment web home]] ---+++++!! External links: * [[https://www.ibm.com][IBM]] ---+++++!! Additional contributors: Main.VidyaMalkarnekar, Main.GlennBardwell <sticky></div></sticky>
E
dit
|
A
ttach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
: r2
<
r1
|
M
ore topic actions
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
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
.