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

Results are not being displayed in SilkCentral Test Manager, how can I verify that the results have been saved to my MSSQL database?

Results are not being displayed in SilkCentral Test Manager, how can I verify that the results have been saved to my MSSQL database?

Problem:

Results are not being displayed in SilkCentral Test Manager, how can I verify that the results have been saved to my MSSQL database?

Resolution:

QUESTION
----------------------------------

After running executions the results are not being displayed in SilkCentral Test Manager. How can I verify that the results have been saved to my MSSQL database?

ANSWER
----------------------------------

The following query can be executed on your SilkCentral Test Manager database to return the results listed in the database between specific dates. Executing this query will allow you to see the results that have been returned from the execution server. Edit the last line of this query with the date and times you expected to have the missing results returned.

SELECT e.ExecutionTimestamp, etn.NodeName, edr.*
FROM TM_ExecDefinitionRuns edr
INNER JOIN TM_ExecTreeNodes etn ON (edr.ExecDefID_fk = etn.NodeID_pk)
INNER JOIN TM_Executions e ON (e.ExecutionID_pk = edr.ExecDefRunID_pk_fk)
WHERE (etn.NodeName = "Network" OR etn.NodeName = "Users") AND
(e.ExecutionTimestamp BETWEEN "2007-05-03 0:00:00" AND "2007-05-04 9:00:00")



If the execution results are listed in the data returned from the query and the results are not displayed on the Application server, there may be other issues preventing the Application server displaying the results.

Please click the following link for further information on displaying the results.

Why can I not find the results of executed Execution Definitions in the SilkCentral Test Manager Activities unit?



Old KB# 24493

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:
‎2013-02-15 19:46
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.