MTM client doesn't display all test results -- even though they are in the TFS Warehouse DB.

Question

Running TS2010 on the server end.   Issue appears on all clients. (Visual Studio Ultimate) and Tester pcs that have Microsoft Test Professional installed. 

Answer 1

Hi,

Go to Test pane->Analyze test runs to view all the results. To view Manaul results, make sure you have selected the Manual results option.

Thanks,

Anuj

---

http://www.anujchaudhary.com

Answer 2

We already did that ... no test results... its like they disappeared... but the SQL DB says they are there.

 

Here's my query:

SELECT

TOP 1000 [ResultSK]

 

,[Outcome]

 

,[OutcomeId]

 

,[FailureType]

 

,[FailureTypeId]

 

,[ResolutionState]

 

,[ReadinessState]

 

,[ReadinessStateId]

 

,[Priority]

 

,[Owner__Name]

 

,[Owner__SID]

 

,[ExecutedBy__Name]

 

,[ExecutedBy__SID]

 

,[ResultBK]

 

,[LastUpdatedDateTime]

 

FROM [Tfs_Warehouse].[dbo].[vDimTestResultOverlay]

 

WHERE Owner__Name LIKE '%usergoeshere%' 

Answer 3

Hello vickyG_aus,

I am moving your case to the MTM forum as your issue is more related to the MTM.

In addition, as far as I know actually the data in the Tfs_Warehouse database is always postponed. So I think sometimes you need to refresh the Tfs_Warehouse database manually to get the latest data. You can refer to the following blog for detailed information:

http://www.ewaldhofman.nl/post/2009/11/25/Refresh-the-TFS-Warehouse-manually.aspx

In addition, when you view the test result in the MTM, please make sure you have set the Start date range to ALL from the dropdown list.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Thanks for moving this question to appropriate forum.   I didn't see this forum listed under MSDN Subscription.

I am hesitant about performing the refresh cache on the server ----  ( it probably will not hurt)

 When these test results were ran -- they did initially publish in MTM.  (Now they don't).  We believe there are many more test results that are not displaying.  Its hard for us to determine what's exactly in MTM -- if the test results disappear.  Of course,  we can perform SQL queries to verify this -- but  it seems an issue on the MTM Client end.