E
dit
A
ttach
P
rintable
r3 - 2020-05-29 - 15:38:47 - Main.mguertin77
You are here:
TWiki
>
Deployment Web
>
DeploymentInstallingUpgradingAndMigrating
>
QMCleanupTaskInMayCauseUnintendedDataDeletion
<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 CleanupUnreferencedCollectionRecordsAsyncTask may cause unintended data deletion on 6.0.6.1<img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/todo.png" alt="todo.png" width="50" height="50" align="right"> %DKGRAY% Authors: Main.VidyaMalkarnekar, Main.WilliamChen<br> Build basis: IBM Rational Quality Manager 6.0.6.1, 6.0.6.1 iFix001, and 6.0.6.1 iFix002 %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> In IBM Rational Quality Manager (RQM) 6.0.6.1, the newly added CleanupUnreferencedCollectionRecordsAsyncTask may cause unintended deletion of rows from certain internal database tables resulting in the data not being visible in some artifact section views. The task is designed to remove rows that are no longer referenced from certain internal database tables. However, it may incorrectly remove some rows that are still referenced. Therefore, users must disable the CleanupUnreferencedCollectionRecordsAsyncTask on these 6.0.6.1 servers, including 6.0.6.1, 6.0.6.1 iFix001, and 6.0.6.1 iFix002. <b>Important</b>: The CleanupUnreferencedCollectionRecordsAsyncTask is disabled and removed from 6.0.6.1 iFix003 and above. ---++ Symptoms Users might see empty result lists when sorting or filtering in certain section views, e.g. Test Cases/Test Suites list view in Test Plans. Note: The data is still in the database and IBM is actively working on a repair tool to restore it. ---++ Temporarily solution Users must follow these steps to disable the CleanupUnreferencedCollectionRecordsAsyncTask on these servers: 6.0.6.1, 6.0.6.1 iFix001, and 6.0.6.1 iFix002: <verbatim> 1. Navigate to RQM Administration page via https://<server>:<port>/<QM context root>/admin page. 2. Click Advanced Properties link under Configuration. 3. Search for CleanupUnreferencedCollectionRecordsAsyncTask, and change the value for "The time interval in seconds between the execution of this task" to -1. 4. Save the new changes and restart the server. </verbatim> ---++ Repair utility A new repair utility is required to restore all impacted QM data. The instructions for how to run the repair utility can be found at the following locations: * 6.0.6.1: [[https://supportcontent.ibm.com/support/pages/repository-tools-command-recreate-incorrectly-removed-queryable-table-data-0][Repository tools command to recreate incorrectly removed queryable table data]] * 7.0: [[https://www.ibm.com/support/knowledgecenter/SSYMRC_7.0.0/com.ibm.jazz.install.doc/topics/r_repotools_repairqueryabletables.html][Repository tools command to recreate incorrectly removed queryable table data]] The issue was being tracked via this Jazz workitem: [[https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=486231][Create repair utility to recreate incorrectly removed Queryable table data.]] ---+++++!! Related topics: [[DeploymentWebHome][Deployment web home]], [[DeploymentWebHome][Deployment web home]] ---+++++!! External links: * [[https://www.ibm.com][IBM]] ---+++++!! Additional contributors: Main.ChristopherRobinson <sticky></div></sticky>
E
dit
|
A
ttach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
: r3
<
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
.