r3 - 2020-05-29 - 15:38:47 - Main.mguertin77You are here: TWiki >  Deployment Web > DeploymentInstallingUpgradingAndMigrating > QMCleanupTaskInMayCauseUnintendedDataDeletion

QM CleanupUnreferencedCollectionRecordsAsyncTask may cause unintended data deletion on

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

In IBM Rational Quality Manager (RQM), 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 servers, including, iFix001, and iFix002.

Important: The CleanupUnreferencedCollectionRecordsAsyncTask is disabled and removed from iFix003 and above.


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:, iFix001, and 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 instructions for how to run the repair utility can be found at the following locations:

The issue was being tracked via this 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: r3 < 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.