Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

JRS 6.0.2 Not Returning Test Suites for Test Case Execution Records

 JRS 6.0.2 allows me to report on Test Case Execution Records and trace them to Test Suites.  This generates the following SQL:

SELECT DISTINCT T1.PROJECT_NAME,
       T1.REFERENCE_ID,
       T1.NAME AS URL1_title,
       T1.URL AS URL1,
       T2.REFERENCE_ID AS REFERENCE_ID1,
       T2.NAME AS URL2_title,
       T2.URL AS URL2
FROM RIDW.VW_EXECUTION_WORKITEM T1
INNER JOIN RIDW.VW_TESTPLAN T2
ON (T2.TESTPLAN_ID = T1.TESTPLAN_ID)
INNER JOIN RIDW.VW_EXECWORKITEM_TSTSUTE_LOOKUP LT1
ON (T1.EXECWORKITEM_ID = LT1.EXECWORKITEM_ID)
  INNER JOIN RIDW.VW_TESTSUITE T3
  ON (T3.TESTSUITE_ID = LT1.TESTSUITE_ID)
WHERE T3.PROJECT_ID = 30 AND T2.PROJECT_ID = 30 AND
  T1.PROJECT_ID = 30  AND
(T1.ISSOFTDELETED = 0 AND T2.ISSOFTDELETED = 0) AND
(T1.EXECWORKITEM_ID <> -1 AND T1.EXECWORKITEM_ID IS NOT NULL) AND
(T2.TESTPLAN_ID <> -1 AND T2.TESTPLAN_ID IS NOT NULL)

Unfortunately, the RIDW.VW_EXECWORKITEM_TSTSUTE_LOOKUP view in the Data Warehouse is empty.  Should we be looking at an issue with our Data Collection jobs?

0 votes



One answer

Permanent link

Hi Robert,

Please make sure that there is at least one TCER which has a link to TestSuite. Check the history of this TCER when this link has been created/modified. Then verify the dcc logs just after this date. 

Or try to add/modify one link between TCER and TestSuite, run the DCC job, then make sure this link has been added to this view (table).

If you believe there are many links between them and created in separated days, but none of them have been updated by dcc, then most likely this is not single dcc job failure, but something more fundamental.

0 votes

Comments

 Thanks, Kenji.  It appears that RIODS.EXECWORKITEM_TESTSUITE_LOOKUP has never been populated even though this system has been in production for years and has test execution records linked to test suites.  This must be a more fundamental problem, as you stated.  We will open a PMR on this.

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 360

Question asked: Jan 09 '18, 7:12 p.m.

Question was seen: 2,118 times

Last updated: Jan 10 '18, 10:14 a.m.

Confirmation Cancel Confirm