Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Silk Central - Missing Tests in Gridview

Silk Central - Missing Tests in Gridview

If tests do not show in Grid View, this could be an issue with the snapshot isolation or the LQM Updater within the database.

Tests get deleted while the LQM updater is running due to some invalid test plan node-ids in the project history (TM_ProjectHistory) of the imported project. The LQM updater uses this project history to find out which tests have been deleted and then removes the tests from the LQM_Tests table.

This will prevent some tests showing in the gridview even when they are within the list view.

To view the tests again in Grid View, use the following steps:

  1. Ensure snapshot isolation is on. Run the following query in SQL Database:

    ALTER DATABASE <your databasename> SET ALLOW_SNAPSHOT_ISOLATION ON;
     
  2. Execute the following update statement on the Silk Central database where the imported project is stored:

    UPDATE TM_ProjectHistory
    SET NodeID = -1
    WHERE ProjectID_fk = <PROJECT_ID> AND Action = 1 AND NodeType = 2

    Note: Replace "<PROJECT_ID>" with the project-id of the IMPORTED project. Check this ID in SCTM project list
     
  3. Next, repopulate the LQM tables:

    DELETE FROM LQM_DataLoads WHERE Action_pk = 'sctm_tests_update'
     
  4. Once the LQM updater has finished, you should see all tests in the Tests Grid view. To check if LQM updater is finished, execute the following sql:

    SELECT * from LQM_DataLoads;
     
  5. The loadState should be completed as a result.

Before executing the queries, create a backup of your database!

SI: 2795782
SI: 2811845

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2015-04-29 12:53
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.