r2 - 2019-07-25 - 14:27:17 - WilliamChenYou are here: TWiki >  Deployment Web > DeploymentInstallingUpgradingAndMigrating > QMCleanupTaskInMayCauseUnintendedDataDeletion

QM CleanupUnreferencedCollectionRecordsAsyncTask may cause unintended data deletion on 6.0.6.1todo.png

Authors: VidyaMalkarnekar, WilliamChen
Build basis: IBM Rational Quality Manager 6.0.6.1, 6.0.6.1 iFix001, and 6.0.6.1 iFix002

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.

Important: 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:


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.

Repair utility

A new repair utility is required to restore all impacted QM data. The issue is being tracked via this open Jazz workitem:

Create repair utility to recreate incorrectly removed Queryable table data.

Related topics: Deployment web home, Deployment web home

External links:

Additional contributors: ChristopherRobinson

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r2 < r1 | More topic actions
 
This site is powered by the TWiki collaboration platformCopyright © by the 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.
Ideas, requests, problems regarding the Deployment wiki? Create a new task in the RTC Deployment wiki project