It's all about the answers!

Ask a question

RQM Execution Trend report displays no data because the ITERATION_ID is always -1 in the Rational Insight data warehouse


Steve Mulligan (1761321) | asked Jan 21 '14, 10:08 a.m.
  • The RQM Execution Trend report has mandatory prompts "Test Plan" and "Test Milestone".  
  • The "Test Milestone" prompt values come from the Iteration values in the table RIODS.TESTPLAN_ITERATION_LOOKUP
  • The "Test Milestone" prompt displays the iteration value for the test plan correctly.
  • However, the table RIDW.F_EXECRESPOINTS_ITER_METRICS that is accessed to get the execution results has an ITERATION_ID value of -1 for all records.
  • The ITERATION_ID for the RIDW.F_EXECRESPOINTS_ITER_METRICS table is obtained from the RIODS.EXECUTION_RESULT table, which also has an ITERATION_ID value of -1 for all records.  It has a value of -1 for all records, because there is no lookup on the Iteration.
  • Selecting the correct "Test Milestone" results in no data displayed in the report, because the correct "Test Milestone" does not exist in the RIDW.F_EXECRESPOINTS_ITER_METRICS table.
  • We recently switched from a standalone data warehouse populated by the Java ETL to a shared Rational Insight data warehouse.  The Execution Trend report worked correct against the standalone data warehouse.
  • Looking at the standalone data warehouse, the RIODS.EXECUTION_RESULT table has a valid ITERATION_ID (not a value of -1 for all records), which means that the RIDW.F_EXECRESPOINTS_ITER_METRICS table also has a valid ITERATION_ID.
  • It appears that the Java ETL populates the ITERATION_ID correctly in the RIODS.EXECUTION_RESULT table, but the Rational Insight Data Manager ETL does not.
  1. Please verify that my understanding is correct.
  2. Is there a way to fix this in the Rational Insight DM ETL?

One answer



permanent link
Clara Forero (6212) | answered Jan 28 '14, 10:15 a.m.
JAZZ DEVELOPER
Please create a defect so we can investigate the issue.  Please include in the description the comments that you posted here so we'll have a starting point to try to reproduce it.

Comments
Steve Mulligan commented Jan 28 '14, 10:29 a.m.

I have created Rational Insight defect 104214 for this item.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.