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?