For the moment I can propose that you try the following steps:
1. Make sure that the project has been backed up recently 2. Login to Site Administration and select the affected project 3. Click on the + next to the project name from the Site Projects screen to see the list of tables in this projectâ s DB 4. Select the SYSTEM_FIELDS table 5. Paste the following query and click on â Execute SQLâ button. Make a note of the SF_ROOT_ID (pointer to a list maintained in the ALL_LIST table) value for this record SELECT * FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT' 6. Verify that there is no list associated with this root id: SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = (SELECT SF_ROOT_ID FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT') 7. Verify that the default list we intend to use for the â Subjectâ field still exists: SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = 2 8. Update the SYSTEM_FIELD table so that the â Subjectâ field correctly points to an existing list UPDATE SYSTEM_FIELD SET SF_ROOT_ID=2 WHERE SF_COLUMN_NAME='TS_SUBJECT' 9. Verify that the changes were made as expected SELECT SF_ROOT_ID FROM SYSTEM_FIELD WHERE SF_COLUMN_NAME='TS_SUBJECT' 10. Update the SEQUENCES table so that QC knows that fields have been modified UPDATE SEQUENCES SET SQ_SEQ_VALUE = SQ_SEQ_VALUE+1 WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION') 11. Verify that the updates were made correctly SELECT * FROM SEQUENCES WHERE SQ_SEQ_NAME IN ('FIELDS_VERSION', 'TABLES_VERSION') 12. Logout of Site Administration 13. Export Tests to QC using Excel add-in and verify that Tests are exported and no errors are noticed
The solution from HP Support for the error: "Field 'Subject': Value x is not a valid list item." was to execute the three queries below. The first will not have results (but no errors should occur) The second two will have results as shown below. The Excel Export macro should then work successfully.
SET SF_ROOT_ID = (SELECT AL_ITEM_ID FROM ALL_LISTS WHERE (0 = 0) AND AL_DESCRIPTION LIKE 'SUBJECT' AND AL_FATHER_ID = 0)
WHERE (0 = 1) OR SF_COLUMN_NAME LIKE 'TS_SUBJECT' OR SF_COLUMN_NAME LIKE 'BG_SUBJECT'
SELECT SF_TABLE_NAME AS 'Table', SF_COLUMN_NAME As 'Column', SF_ROOT_ID As 'Tree Root FK' FROM SYSTEM_FIELD WHERE (0 = 1) OR SF_COLUMN_NAME LIKE 'TS_SUBJECT' OR SF_COLUMN_NAME LIKE 'BG_SUBJECT';
Result: Table Column Tree Root FK ----------------------------------- BUG BG_SUBJECT 2 TEST TS_SUBJECT 2
SELECT AL_ITEM_ID As 'Tree Root ID', AL_FATHER_ID As 'Parent', AL_DESCRIPTION As 'Name' FROM ALL_LISTS WHERE (0 = 0) AND AL_DESCRIPTION LIKE 'SUBJECT' AND AL_FATHER_ID = 0;
Result: Tree Root ID Parent Name --------------------------- 2 0 Subject
I also require this functionality to use the product correctly. Has a patch for this been released? Is there an easier way to get this basic functionality to work without making changes directly to the database?