Cybersecurity
DevOps Cloud (ADM)
IT Operations Cloud
Results are not being displayed in SilkCentral Test Manager, how can I verify that the results have been saved to my MSSQL database?
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.