It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,908
×5,999
×355
×191

question asked: Jan 09 '18, 7:12 p.m.
question was seen: 1,614 times
last updated: Jan 10 '18, 10:14 a.m.

Related questions

FAQ - How this Forum works

JRS 6.0.2 Not Returning Test Suites for Test Case Execution Records

0
Robert Huet (231●1●28●84) | asked Jan 09 '18, 7:12 p.m.

 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?

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kenji Sarai (960●2●9) | answered Jan 10 '18, 1:30 a.m.
edited Jan 10 '18, 1:34 a.m.

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.

Comments
Robert Huet commented Jan 10 '18, 10:14 a.m.

 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 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.