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:
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?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 URL2FROM RIDW.VW_EXECUTION_WORKITEM T1INNER JOIN RIDW.VW_TESTPLAN T2ON (T2.TESTPLAN_ID = T1.TESTPLAN_ID)INNER JOIN RIDW.VW_EXECWORKITEM_TSTSUTE_LOOKUP LT1ON (T1.EXECWORKITEM_ID = LT1.EXECWORKITEM_ID)INNER JOIN RIDW.VW_TESTSUITE T3ON (T3.TESTSUITE_ID = LT1.TESTSUITE_ID)WHERE T3.PROJECT_ID = 30 AND T2.PROJECT_ID = 30 ANDT1.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)
One answer
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.