Rational Quality Manager Version 3.0.1.3 Release Notes

This release is a service release of Rational Quality Manager, Version 3.0.1. It contains new features and fixes for defects. See the Getting Started page for information on documentation and support resources, software and hardware requirements, and installation or upgrade steps.

The following notes detail important fixes and issues in the release of Rational Quality Manager. Please ensure that you also read the Jazz Foundation, Version 3.0.1.3 Release Notes, the Rational Requirements Composer, Version 3.0.1.3 Release Notes, and the Rational Team Concert, Version 3.0.1.3 Release Notes.

Fixes included in this release

The Version 3.0.1.3 release of Rational Quality Manager delivers APAR and non-APAR fixes. To review and explore completed work, see the Rational Quality Manager development dashboard and the Collaborative Lifecycle Management development dashboard.

View this query for a detailed list of fixes for this release.

APARs

View the Rational Quality Manager development dashboard APARs page for a summary list of APARs fixed for this release.

View this query for a detailed list of APARs fixed for this release.

APAR	Summary	Work Item
PM55622	BIRT Reporting: Fixes problem with the "The Execution Status by TER Count" report's handling of customised state names	60290
PM53448	Build Integration: Fixed a problem that prevented the display of Rational Team Concert builds	59169
PM57860	ClearQuest Integration: Enabled Clearquest OSLC integration where there is a customer ClearQuest Schema	61974
PM56186	CQTM Migration: Fixes a problem where the testcase order in a suite is not preserved in the CQTM migration	60819
PM51604	CQTM Migration: Enables CQTM migration to a non-SSL RQM server	58251
PM59087	DOORS Integration: Fixes a problem where requirements can only be exported to one test plan even if a second DOORS view is created	59508
PM58084	Integrations API: Fixes a problem where the API would be unable to access resources whose external ID contained a special character	61824
PM59970	Integrations OSLC: Improves performance when associating a defect to multiple TCERs	60004
PM60007	Integrations OSLC: Fixes an error that occurs when reconciling a requirement collection where a requirement had changed	62333
PM59338	Lab Management: Fixes a problem where selecting a lab resource to reserve based on a test environment causes a radio button to clear, making the reservation impossible to complete	56539
PM56647	Offline Execution: Fixes a problem with Japanese characters getting garbled when exported for offline execution	61060
PM53625	Offline Execution: Fixes a problem with the generated results from offline execution where a keyword would cause the results to contain an extra step	59059
PM54212	PDF Reporting: Added a section for custom attributes to the PDFs	57239
PM53677	PDF Reporting: Fixes a problem with the PDF for the Summary of View Test Case Execution Records where column values were overlapping	59134
PM57721	Reporting RDDI ETL: Fixes a problem where changing testplan-testsuite relationship were becoming out of sync	60692
PM56627	RequisitePro Integration: Fixes a problem with the history generated by adding a reference to a RequisitePro requirement	61040
PM53675	RequisitePro Integration: Fixes a problem that occurs when RequisitePro requirements with long names are imported	59309
PM59614	RQM Upgrade: Fixes a problem with the upgrade from 2.x where references to missing TERs or Configurations causes the migration to fail	62097
PM59951	Test Execution: Fixes a problem where using "Apply All" during a manual test execution would not cause correct timestamps to be set in all step results	63160
PM56770	Test Execution: Fixes a problem where selecting multiple TCERs does not enable the Run button	60933
PM55635	Test Execution: Fixes a timing issue where a testcase Run button could become enabled before the adapter had loaded	60042
PM55478	Test Execution: Fixes a problem where a deleted test script is still visible when running a test case	60253
PM55161	Test Execution: Fixes a problem viewing a test case result; choosing "Show all Sections" causes the Defect and Previous Results sections to become empty	60151
PM59738	Test Planning: Fixes a problem where duplication of a test script will fail if that script uses the same keyword more than once	62268
PM57812	Test Planning: Fixes a problem with selecting a category from the left navagation bar when the number of values for the category is greater than ten	62129
PM57472	Test Planning: Fixes a problem where deleted catagory values were still selectable	61580
PM54592	Test Planning: Fixes a problem where a view could not be sorted by a custom category if the category name contained a colon	59642
PM53374	Test Planning: Fixes a problem which could cause the bottom bar in the list views to become detached, potenitially blocking the view of one of the rows	59367
PM51263	Test Planning: Addresses an occasional issue when a test case is duplicated, the new test case is not opened for editing	47484
PM58996	Word/Excel Importer: Fixes a problem importing resources using categories with the Excel Import Tool	61397
PM56915	Word/Excel Importer: Fixes a problem with the creation of images with the Excel Import Tool	59967
PM56831	Word/Excel Importer: Fixes a problem with Japanese characters getting garbled when imported with the Excel Import Tool	60839
PM54765	Word/Excel Importer: Enables the setting of categories form the Word Import Tool	60019
PM56031	Word/Excel Importer: Enables Word and Excel import tool usage with basic authentication	60626
PM55489	Word/Excel Importer: Fixes a problem with the setting of the step type by the Word Import Tool	60260

Known problems and workarounds

The Rational Quality Manager Version 3.0.1.3 Release Notes query lists the known issues and workarounds in this version.

When using CLM reports, test plan to test suite relationships become inconsistent (PMR 80949 180 000)

In RQM V3.0.1.3 and earlier versions, test suites are associated with a test plan, but the current trigger works based on changes to the test suite. The trigger should work the other way around, based on test plan changes. See work item 60692.

There is a fix available for Rational Insight and RRDI users. If you do not use these products, the fix is not required because BIRT reports are not impacted.

The solution includes:
(1) A hotfix for the schema in which the new trigger keeps the old name to ensure it will not break a migration to V4.0.
(2) A repair job to load the broken relationships.

Schema changes:

DB2:
================
SET CURRENT SCHEMA RIODS;
DROP TRIGGER TRG_TSTPLTLK;
CREATE TRIGGER TRG_TSTPLTLK AFTER UPDATE OF REC_DATETIME ON TESTPLAN REFERENCING NEW AS NEWROW OLD AS OLDROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC DELETE FROM TESTSUITE_TESTPLAN_LOOKUP WHERE TESTPLAN_ID=NEWROW.TESTPLAN_ID; END;
================

ORACLE:
================
ALTER SESSION SET CURRENT_SCHEMA=RIODS;
DROP TRIGGER TRG_TSTPLTLK;
CREATE TRIGGER TRG_TSTPLTLK AFTER UPDATE OF REC_DATETIME ON TESTPLAN FOR EACH ROW BEGIN DELETE FROM TESTSUITE_TESTPLAN_LOOKUP WHERE TESTPLAN_ID=:NEW.TESTPLAN_ID; END;

SQL SERVER:
================
DROP TRIGGER RIODS.TRG_TSTPLTLK
GO
CREATE TRIGGER RIODS.TRG_TSTPLTLK ON RIODS.TESTPLAN FOR UPDATE AS BEGIN DELETE FROM RIODS.TESTSUITE_TESTPLAN_LOOKUP WHERE TESTPLAN_ID IN (SELECT TESTPLAN_ID FROM INSERTED) END
GO
================

Hotfix procedure

This hotfix comprises two parts: a schema patch for your data warehouse and a repair job that reloads the relationships between all your test plans and their assigned test suites into the warehouse. The instructions cover how to run it with IBM Insight V1.0.1.1 or V1.1 as well as the RRDI that ships with CLM V3.0.1.2. The hotfix has been tested against CLM V3.0.1.2 and CLM V4.0 M7.

1. Apply the schema fix.
   1. Open a command tool for your database, such as Command Center for DB2.
   2. In "Schema changes" above, select the correct script for your respective database vendor. Copy, paste, and run the script. The script drops an existing trigger in the RIODS schema and recreates it with the correct definition.
2. If you have never run any ETLs, then you can stop here; the solution is complete. If you ran ETLs in the past, then you need to run a repair job to correct the data in your warehouse by completing steps in one of the following two alternatives:
   
   • Alternative 1: Run the warehouse repair job using Rational Insight.

     These instructions assume that you setup Rational Insight for CLM and already ran your ETLs successfully using Data Manager in the past. If you run your ETLs on a non-Windows machine using data movement tasks then the instructions for running the job with RRDI will also work for you instead.

     1. Download the file attached to this work item called "RQM_RepairPlanSuiteLookup.pkg".
     2. Start Data Manager.
     3. Click File > Import Package.
     4. When prompted to backup your catalog, do so.
     5. In the Package File dialog box, select the file you downloaded earlier; then click Open.
     6. In the Import Package Wizard dialog, only select the following entry: RQM_RepairPlanSuiteLookup. Then in the Dependent Components dialog box, clear the selection of everything except the mandatory selection RQM3_PlanSuiteLookup.
     7. Confirm that only the two component entries listed above are selected and no other components. Click Next; then click Finish.
     8. After the import, go to the Connections list and confirm that your settings for Rational Data Warehouse are still correct.
     9. Verify that your xdc files are configured correctly (your previous ETL jobs all succeeded and covered all your projects).
     10. Run the job in "Build and JobStreams > Jobs > RQMJobs > RQM3_MigrationJobs > RQM_RepairPlanSuiteLookup".
     11. Review the logs files and make sure all jobs completed successfully.
         
         
   • Alternative 2: Run the warehouse repair job using Rational Reporting for Development Intelligence (RRDI).
     1. Download the rqm3011.xdc or rqm4.0.xdc file and configure the ODBC data connection called "Rational Quality Manager." For detailed instructions, see Integrating the Collaborative Lifecycle Management XML data configuration files with Rational Insight in the CLM information center.
        
        Note: You only need to download and configure the rqm3011.xdc or rqm4.0.xdc file; you can ignore the other file described in the help page.
     2. Download the file, "RQM_RepairPlanSuiteLookup.zip," attached to jazz.net work item 60692.
     3. Place the file in the following folder: /cognos/deployment.
     4. To import this one file into the report server, see Importing the data models and reports on Rational Reporting for Development Intelligence.
     5. To create a new connection called "RIDW (ETL)", complete steps 1 through 2 (only) of these instructions.
        Note: it is important to use the DB admin user (or the user that you have created for the Java ETL jobs) here for the Signon user. Although these are instruction from RQM 2.x, this page describes the steps you need to do to get the "RIDW (ETL)" connection right.
     6. In Cognos Connection, go to the folder dataMovementTasks and execute the job called "RQM_RepairPlanSuiteLookup" that you imported earlier.
     7. Check the log files in /cognos/datamanager/log to make sure all jobs completed successfully.

Rational RequisitePro and Rational Quality Manager integration issue

You might see the following message in the Rational RequisitePro Server Administration page:
"The imported username and password for the following RequisitePro projects are invalid: Please update the username and password for these projects or delete the projects. If you have changed the username/password of projects, please Click here to upgrade this data again."

Workaround: The message is misleading and can be ignored. See work item 63006.

Money that Matters sample can cause ETL to hang

Occasionally, the the Rational Quality Manager ETL hangs after the creation of the Money that Matters sample. This problem might be occurring due to an interaction with testing automation.

Workaround: The problem can be fixed by restarting the server. See work item 59531.