Trusted Contributor.
Trusted Contributor.

PC Support Tip: PC environment is slow or check host task is getting stuck

For PC 12.01 there is an issue with the table LAB_HOST_CHECK_RESULTS, the data in the table is not being deleted, it should be recycled automatically.  So the table needs to be truncated manually. This issue can cause errors messages in the test design page and collation issues.


The workaround is the following:


  1. Go to Site Administration > Lab Management, search for the table LAB_HOST_CHECK_RESULTS
  2. Check the number of entries in this table (you can use the query: SELECT count(*)  FROM "LAB_HOST_CHECK_RESULTS")
  3. If the number of entries in that table is very big then this is the problem, this table stores the results from the checks that ALM does to the host so this table can get very big
  4. As workaround for this you can perform a truncate on the LAB_HOST_CHECK_RESULTS table (truncate table "LAB_HOST_CHECK_RESULTS")
  5. But this issue has been already fixed in the PC 12.01 patch 1


HP Support

Labels (1)
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.