Troubleshooting
Problem
Lifecycle Query Engine (LQE) may report skipped resources when a DOORS module's configuration is changed from unset to a Global Configuration (GC) stream after objects have been created in the module.
Symptom
LQE shows skipped resources in the following scenario:
- The project is already added to the Working Set, and the database is not associated with the current
configuration of a GC stream. - We then add a module and create 3 objects in it.
- Entries are added to the trs.change_log table.
- Next, we associate the module with the current configuration of a GC stream.
- We add 2 more objects to the module.
- No entries are added to the trs.change_log table.
- As a result, LQE now contains some skipped resources.
Cause
The project is already added to the Working Set, and the module is not associated with the current configuration of a GC stream. So, When three objects were created, those three records also got inserted into the TRS feed. Then, when we associate the module with the current configuration of a GC stream, new modifications won't be inserted in the TRS feed (Known limitation - LQE can not index DOORS data associated with a GC stream).
So, previously added three records appear as skipped resources in LQE.
The root cause is a synchronization issue between the configuration change event and the TRS change log mechanism.
Resolving The Problem
Step 1: Open derby database console.
Run below “derby.run_ij.bat” from below DWA installed location.
C:\Program Files\IBM\Rational\DOORS Web Access\9.7.2.12\derby\scripts\derby.run_ij.bat
Step 2: Take the backup of trs.change_log table and truncate trs.change_log table by using following SQL queries. Update DDMMYYYY with current Date.
- CREATE TABLE trs.change_log_backup_DDMMYYYY AS SELECT * FROM trs.change_log WITH NO DATA;
- INSERT INTO trs.change_log_backup_DDMMYYYY SELECT * FROM trs.change_log;
- DELETE FROM trs.change_log;
Step 3: Trigger trs rebase
- Login into DWA in browser.
Update your DWA_HOST in below URL and hit this HTTPS GET request in browser.
https://DWA_HOST:8443/dwa/rm/trs-rebase
Step 4: Perform the Re-Index of the DOORS data provider from LQE.
Note: The above resolution is only possible with DWA 9.7.2.12.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
30 June 2026
UID
ibm17277522