作者: fhhh_eyou 时间: 2015-11-4 11:05
value属性值信息错误。作者: hkxgzxt1987 时间: 2015-11-4 11:41
没人用QC吗？这个应该经常用啊作者: hkxgzxt1987 时间: 2015-11-4 12:04
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 projecta s DB
4. Select the SYSTEM_FIELDS table
5. Paste the following query and click on a Execute SQLa 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 a Subjecta field still exists:
SELECT * FROM ALL_LISTS WHERE AL_ITEM_ID = 2
8. Update the SYSTEM_FIELD table so that the a Subjecta 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作者: hkxgzxt1987 时间: 2015-11-4 12:05
自己解决了，还是谷歌搜索好用啊作者: 猫星人 时间: 2015-11-23 14:37
其实很少用。。。。作者: 休言一缘强为牵 时间: 2015-12-1 14:23
用英文试试
