Explanation:

One of the QA Lead reported me that the test suite was lost after the migration from TFS 2010 to TFS 2012. Actually the test suite folder was renamed by the QA Lead and reported as deleted :(

How did I resolved it?

• Queried the TFS 2012 collection database to get the deleted suite id, But I was not able to identify any test suite delete for the reported project in the collection.

           Select * from tbl_auditlog where ObjectType = 11

• To get the basic information of test suite like ProjectName, TestPlanId, ParentSuiteId, Title, SuiteType, Query, RequirementId, I queried the TFS 2012 collection database as below

           Select p.ProjectName, s.* from tbl_suite s join  tbl_Project p on s.ProjectId = p.ProjectId

• I was able to identify the suite information which was reported as deleted. With the suite id, I was able to identify who renamed the test suite and when

           Select LastUpdated,LastUpdatedBy FROM tbl_Suite where [SuiteId] = 'XXXX' 

           Select * from tbl_Identity where Id = ' LastUpdatedBy ' 

Reference:

Exception:

Exception calling "QueryActiveRequests" with "2" argument(s): "Value cannot be null.
Parameter name: second"
At C:\Builds\Service.ps1:2 char:30
+ $tfsadmin.QueryActiveRequests <<<< ($null, "False") | %{ $_.ActiveRequests } | ft StartTime,UserName,MethodName,RemoteComputer
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

Explanation:

The following powershell script to monitor the TFS active requests work on TFS 2010 but fails with the above exception on TFS 2012.

$tfsadmin = New-WebServiceProxy –UseDefaultCredential -URI http://tfs:8080/tfs/TeamFoundation/administration/v3.0/AdministrationService.asmx?WSDL
$tfsadmin.QueryActiveRequests($null, "False") | %{ $_.ActiveRequests } | ft StartTime,UserName,MethodName,RemoteComputer

While accessing TFS 2012 server, the QueryActiveRequests web method fails to accept null value as an argument.

Workaround:

The workaround is to pass the TFS 2012 HostId as first parameter instead of $null

Following are the step to find the TFS host id

1. Open Microsoft SQL Server Management Studio

2. Connect to TFS 2012 data tier

3. Execute the below query

USE [Tfs_Configuration]
SELECT [HostId], [Name] FROM [Tfs_Configuration].[dbo].[tbl_ServiceHost] where [Name] = 'TEAM FOUNDATION'

Result
-------

HostId                                                       Name
AAAAAAAA-96A2-4BA8-A74C-11422B123456 TEAM FOUNDATION

4. Replace $null with the HostId

$tfsadmin = New-WebServiceProxy –UseDefaultCredential -URI http://tfs:8080/tfs/TeamFoundation/administration/v3.0/AdministrationService.asmx?WSDL
$tfsadmin.QueryActiveRequests("AAAAAAAA-96A2-4BA8-A74C-11422B123456","False") | %{ $_.ActiveRequests } | sort StartTime | ft StartTime,UserName,MethodName,RemoteComputer

Explanation:

System field named "Tags" column was added on the product backlog Workitem Type.

<ProductBacklog>
<Columns>
<Column refname="System.Title" width="400" />
<Column refname="System.State" width="100" />
<Column refname="Microsoft.VSTS.Scheduling.StoryPoints" width="50" />
<Column refname="Microsoft.VSTS.CMMI.RequirementType" width="50" />
<Column refname="System.IterationPath" width="200" />
<Column refname="System.Tags" width="200" />
</Columns>

Solution:

Open Team project Web Access page

The project created using Scrum process template will have “Product Backlog Item” and “Bug” work items as Product Backlog Type

 The project created using Agile process template will have “User Story” work items as Product Backlog Type 

The project created using CMMI process template  will have  “Requirement” work items as Product Backlog  Type