TFS Jobs

by Xavier Dilip Kumar 2. September 2013 08:18
Job Name

 Interval

Build Warehouse Sync Every 30 minutes
Common Structures Warehouse Sync Every 30 minutes
Test Management Warehouse Sync Every 30 minutes
Version Control Warehouse Sync Every 30 minutes
Work Item Tracking Warehouse Sync Every 30 minutes
Synchronize Test Cases Every 10 minutes
Repopulate Dynamic Suites Every hour
Identity Synchronization Job -
This job synchronizes few properties of every user that is a member of a group in the system with the windows active directory
Every hour
Team Foundation Server Coverage Analysis Every hour
Work Item Tracking Integration Synchronization Every hour
Incremental Analysis Database Sync  Every 2 hours
Cleanup Discussion Database Daily
Cleanup Test Management Database Daily
File Container Cleanup Daily
Job History Cleanup Job -
This job removes the internal job history log records that are older than 31 days
Daily
Full Analysis Database Sync  Daily
Security Identity Cleanup Job Daily
Team Foundation Server Activity Logging Administration -
To purge data in the activity log (tbl_Command) that is older than 14 days
Daily
Team Foundation Server Event Processing Daily
Team Foundation Server Framework Data Cleanup Daily
Team Foundation Server Framework File Service Cleanup Daily
Team Foundation Server Send Mail Job -
 This job is responsible for sending out email alert subscriptions and SOAP alert subscriptions. 
Daily
Version Control Administration -
This job removes content in the database that has been previously destroyed. Also, it removes content that gets staged to a temporary table as part of the large check - in
Daily
Version Control Code Churn Daily
Version Control Delta Processing Daily
Version Control Statistics Update Daily
Work Item Tracking Administration -
This Job operates on the work item tracking tables. It reorganizes fragmented indexes and updates table statistics. It also deletes work items and attachments no longer used by the system. It will also delete orphaned attachments, beacuse saving a work item and uploading an attachment are two separate transactions, and one can succeed wiyhout the other.
Daily
Work Item Tracking Remove Orphan Attachments Daily
Optimize Databases -
This job operates on the relational warehouse database. It reorganizes fragmented indexes and updates table statistics
Daily
Build Information Cleanup Job -
To reorganize/rebuild any indexes in SQL that exceed the fragmentation threshold
2 days
Message Queue Cleanup Job 2 days
Prune Registry Audit Log 7 days
Work Item Tracking Referenced Identities Update 7 days
Work Item Tracking Remove unused constants 14 days
Build Cleanup Job  
Upgrade - Version Control Code Churn Online -
This is a once-off job that runs after upgrade from TFS2010 to TFS2012. The format for storing the code churn data changed, so rather than converting that data during upgrade, it was done slowly over time post-upgrade by this job
 

Reference:

Tags: ,

TFS | TFS 2010 | TFS 2012

Exception calling "QueryActiveRequests" with "2" argument(s): "Value cannot be null.

by Xavier Dilip Kumar 29. August 2013 09:55

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

 

Tags: ,

TFS | TFS 2012

Process Template changes between TFS 2012 Update 1 to TFS 2012 Update 2

by Xavier Dilip Kumar 26. August 2013 19:24

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>

Tags: ,

TFS | TFS 2012

How to find the process template name used to create the team project in TFS 2012?

by Xavier Dilip Kumar 26. August 2013 18:49

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 

 

Tags: ,

TFS | TFS 2012

How to disable the work item moving to resolved state while associating to a checkin

by Xavier Dilip Kumar 21. August 2013 20:11

Work Around

Change the following key value to “False”.

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\TeamFoundation\SourceControl\Behavior\@ResolveAsDefaultCheckinAction

Tags: , ,

TFS | TFS 2010 | TFS 2012 | Visual Studio 2010 | Visual Studio 2012

Unable to publish to HTML fields from Excel

by Xavier Dilip Kumar 20. August 2013 21:45

Explanation:

HTML fields are only editable in Excel when the Work item is created. After the first revision has saved you can no longer edit it in Excel.

Tags: , ,

TFS | TFS 2010 | TFS 2012

Generic trust failure error while installing KB2662296 package to Visual Studio SP1

by Xavier Dilip Kumar 19. August 2013 12:43

Exception:

Explanation:

The error was due to incorrect or missing CDP URLs

Solution:

1. Open WIndows Command Prompt

2. Execute the following command

The above commands fetch the current CRL from the target URL and install it in this cert store to make it available for cert chain verification

Tags:

TFS | TFS 2012 | Visual Studio 2010

TF80012: The document cannot be opened because there is a problem with the installation of the Microsoft Visual Studio v10.0 Team Foundation Office integration components.

by Xavier Dilip Kumar 18. August 2013 11:51

Exception:

 

Solution:

1. Open Command Prompt Window as Administrator (Right click on CMD shortcut) 

2. Execute the follwoing command

Regsvr32 “C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\TFSOfficeAdd-in.dll”

 

Tags: ,

TFS | TFS 2010

Unable to create the Team Project Query

by Xavier Dilip Kumar 14. August 2013 18:17

Soultion

You need to set “Edit project-level information" permission to allow to create\edit any work item query

Tags: ,

TFS | TFS 2010 | TFS 2012 | Visual Studio 2012

TF221122: An error occurred running job Full Analysis Database Sync for team project collection. The trust relationship between the primary domain and the trusted domain failed

by Xavier Dilip Kumar 8. August 2013 11:40

Errors:

Microsoft.TeamFoundation.Server.WarehouseException: TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION.
Microsoft.TeamFoundation.Server.WarehouseException: Failed to Process Analysis Database 'Tfs_Analysis'.
System.SystemException: The trust relationship between the primary domain and the trusted domain failed.

Explanation

Analysis Database Sync failed all of a sudden stating "The trust relationship between the primary domain and the trusted domain failed".  The domain trust was fine.  

Soultion

1. open Microsoft SQL Server Management Studio

2. Connect to TFS Analysis Service

3. Expand Analysis Service Server name --> Database --> Tfs_Analysis --> Roles 

4. Double click on TfsWarehouseAdministrator --> Membership

5. Remove the invalid Ids (In my case I removed the SID ids displayed in the users list)

6. Repeat step 4 and 5 for TfsWarehouseDataReaders

7. open Microsoft SQL Server Management Studio

8. Connect to TFS Warehouse database

9. Expand Tfs_Warehouse database --> Security --> Roles --> Database Roles 

10. Double click on TfsWarehouseAdministrator

11. Remove the invalid Ids (In my case I removed the non domain ID which was not related to TFS.)

12. Start the sync again. Open http://<Server Name>:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

13. Click on ProcessAnalysisDatabase link

14. Invoke Full sync

15. Full sync should succeed :)

Tags: ,

TFS | TFS 2010 | TFS 2012

About the author

My name is Xavier Dilip Kumar Jayaraj and I am a Software Configuration Management Engineer with a background in application development, Build & packaging using Install Shield.

Profile in LinkedIn

  

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

Month List