test phase attribute of QM not visible in JRS
Hi All,
Accepted answer
Hi Shubham,
Firstly, if you are looking for solution urgently, please contact IBM support. I do not think anyone can address your problem by just looking at your problem description.
Let me clarify, did you update 3 categories (given that drop down menu), not attributes in test case summary section, didn't you? If so, the table you need to investigate is RIODS.TEST_CATEGORY. Here is the steps to verify the category by SQL query in Advanced section in Report Builder
1. Find internal testcase id
select TESTCASE_ID from RIODS.TESTCASE where REFERENCE_ID = 'XX'
(XX is the testcase id found in your RQM web UI)
2. Look for the all categories of this testcase
select TEST_CATEGORY_ID from RIODS.TESTCASE_CATEGORY_LOOKUP where TESTCASE_ID = 'YY'
(YY is the one found in step 1.)
3. select * from RIODS.TEST_CATEGORY where TEST_CATEGORY_ID = 'ZZ'
(ZZ is the one found in step 2. There should be at least 3, according to your description)
Then verify the 3 results (or more) if these are the categories you have added in testcase.
Note: If you have added both custom attributes and categories, then custom attributes are stored in completely different places.
If you cannot find them in RIODS.TEST_CATEGORY, then something went wrong in DCC job. Check dcc.log carefully. This is not the end of troubleshooting, and the next step is depending on this result. It would be very tedious. That's why I advise you to contact IBM support.
Comments
Don Yang
Feb 01 '18, 6:46 p.m.what is your RQM/JRS version and ifix level(both RQM and JRS)?
did you confirm DCC jobs run successfully?
shubham shahu
Feb 02 '18, 1:04 a.m.Yes i have confirm the DCC jobs ran successfully.