IBM Support

ALERT: CleanupUnreferencedCollectionRecordsAsyncTask in 6.0.6.1 may cause unintended deletion of rows from certain internal database tables resulting in the data not being visible in some artifact section views.

Flashes (Alerts)


Abstract

In IBM Rational Quality Manager (RQM) 6.0.6.1, the newly added CleanupUnreferencedCollectionRecordsAsyncTask can cause unintended deletion of rows from certain internal database tables resulting in the data not being visible in some artifact section views.

This task is designed to remove rows that are no longer referenced from certain internal database tables.
However, it can incorrectly remove some rows that are still referenced.

Note: The data is still in the database and IBM is working on a tool to restore it.

Content

Symptoms:

Referenced test artifacts may be empty in the RQM web UI when performing query operations (for example, sorting or filtering in certain section views, such as Test Cases/Test Suites sections of the Test Plan editor).

Solution:
Apply the latest 6.0.6.1 iFix to the 6.0.6.1 environment immediately as the “CleanupUnreferencedCollectionRecordsAsyncTask” is disabled and removed as of 6.0.6.1 iFix003. 

If applying the latest 6.0.6.1 iFix is not possible, disable the “CleanupUnreferencedCollectionRecordsAsyncTask” immediately.


1. Navigate to the  RQM Administration page https://<server>:<port>/<QM context root>/admin.

2. Click the “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" under that entry to “-1”.

4. Restart the server.

As stated above, a repair utility to fix the data removal is currently being worked on.

This is being tracked by the following enhancement:
https://jazz.net/jazz/web/projects/Jazz Foundation#action=com.ibm.team.workitem.viewWorkItem&id=486231

If you have any further questions on this issue, contact IBM support.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUVV6","label":"IBM Engineering Test Management"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.0.6.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

RQM;CLM;Rational Quality Manager;Rational Quality Manager

Document Information

Modified date:
26 September 2022

UID

ibm10960013