Data Warehouse reports are showing links to deleted artifacts

Resolving The Problem

Note: While the technote describes a known issue fixed in 6.0.1 iFix005 and 6.0.2, the steps below are required in order to run a full ETL load for DOORS Next Generation.

It is recommended you make a backup of the Data Warehouse database before proceeding.

Run the following SQL query against the Data Warehouse database:

1) SELECT DISTINCT SOURCE_ID FROM RIODS.REQUIREMENT


If only one ID is returned (aside from a row containing a value of -1), proceed by executing the following SQL statements. This statement will temporarily mark all DNG artifacts as deleted in the data warehouse until the full ETL is executed. It is important to know that data warehouse reports will not show DNG artifacts until the ETL has completed.

a) UPDATE RIODS.REQUIREMENT SET ISSOFTDELETED=1, REC_DATETIME = CURRENT_TIMESTAMP WHERE SOURCE_ID = '<ID FROM ABOVE QUERY>'


b) UPDATE RIODS.REQUIREMENT_COLLECTION SET ISSOFTDELETED=1, REC_DATETIME = CURRENT_TIMESTAMP WHERE SOURCE_ID = '<ID FROM ABOVE QUERY>'


Example:


UPDATE RIODS.REQUIREMENT SET ISSOFTDELETED=1, REC_DATETIME=CURRENT_TIMESTAMP WHERE SOURCE_ID = '_ZsMvUqgXEeW4wNRvJ2fzagRRC'

UPDATE RIODS.REQUIREMENT_COLLECTION SET ISSOFTDELETED=1, REC_DATETIME=CURRENT_TIMESTAMP WHERE SOURCE_ID = '_ZsMvUqgXEeW4wNRvJ2fzagRRC'


If multiple IDs are returned, you need to get the appropriate SOURCE_ID for the DNG repository/repositories being repaired. To do this, run the following SQL command against the Data Warehouse by using a known requirement URL for each DNG data set being repaired. For example:

SELECT SOURCE_ID FROM RIODS.REQUIREMENT WHERE URL = '<DNG Resource URL'>


Example:
SELECT SOURCE_ID FROM RIODS.REQUIREMENT WHERE URL = ' https: //clmweb.ibm.com/rm/resources/_sTCYASD_EeaxLPLal_NU8'


After the SOURCE_ID has been identified, run query #2 above with the SOURCE_ID.

When the UPDATE query has been run, proceed by running a full ETL for Rational DOORS Next Generation by using the following steps:

1) Log in to DCC

2) Click "Delta Load Configuration" in the left sidebar

3) Select the DNG repository to be reloaded. For example, "Rational DOORS Next Generation (0)"

4) Set the "Load Type" property to "Full Load" and click save

5) Let the ETL run on schedule, or run the "Requirement Management" job manually. It is strongly recommended that this be done off hours when possible.

The steps are also documented in Collecting Data with the Data Collection Component. Refer to the section titled Specify the load type for the next data collection job for complete documentation.