How do I associate work item with check-in using TF.exe command line utility?

by Xavier Dilip Kumar 22. October 2015 13:25

Explanation:

You cannot associate work item with the check-in using tf.exe command line utility from Visual Studio command tools.

Workaround:

You can use the tf.exe from Team Explorer Everywhere to associate work item with the check-in.

tf checkin ItemSpec -associate:WorkItemIds

Tags:

TFS | TFS 2010 | TFS 2012 | TFS 2013 | TFS 2015

How to find the TFS scheduled jobs detail?

by Xavier Dilip Kumar 22. October 2015 09:23

Solution: 

You can query the Job details tables in Tfs_Configuration

Query:

SELECT tbl_JobSchedule.JobId, tbl_JobSchedule.ScheduledTime, tbl_JobSchedule.Interval,
tbl_JobSchedule.TimeZoneId, tbl_JobDefinition.JobName FROM tbl_JobDefinition
RIGHT OUTER JOIN tbl_JobSchedule ON tbl_JobDefinition.JobId = tbl_JobSchedule.JobId

Output:
JobId ScheduledTime Interval (Sec) TimeZoneId JobName
C03C29A7-00AE-4E02-94BC-18ACA80E2EA2 7/16/08 3:00 AM 86400 UTC Team Foundation Server Image Cleanup
DD7629E4-66BB-45F9-AD42-2651BD7E56B8 7/3/11 8:00 AM 86400 UTC Team Foundation Server Send Email Confirmation Job
3C601170-8080-4A7D-B8E7-48E991F80C4A 7/16/08 3:00 AM 86400 UTC Team Foundation Server Application Tier Maintanence Job
B1516502-4633-432B-BDB3-74C802C5F2B7 7/3/11 9:00 AM 86400 UTC Team Foundation Server Send Mail Job
544DD581-F72A-45A9-8DE0-8CD3A5F29DFE 7/16/08 3:00 AM 3600 UTC Team Foundation Server Periodic Identity Synchronization
B19DDD28-9A95-42E2-9697-966FD822F1CD 7/3/11 10:08 PM 604800 UTC Prune Registry Audit Log
2ABF4FAB-5E36-4731-9E9F-9694C3CF0592 8/23/12 10:08 PM 86400 UTC File Container Cleanup
63A78C70-8FE0-4743-BA2D-A00CF8C20FDF 7/16/08 3:00 AM 86400 UTC Security Identity Cleanup Job
7A3E559E-8EB7-4E90-A4F7-B7A2515D52B9 7/3/11 9:00 AM 86400 UTC Team Foundation Server Framework File Service Cleanup
AF87E4CD-D421-4A24-BF16-D3A68371703E 7/20/08 3:00 AM 604800 UTC Team Foundation Server Database Optimization
8FC76967-DA5D-4D53-937B-E3EFC6AF0FCB 7/16/08 3:00 AM 86400 UTC Job History Cleanup Job
A4804DCF-4BB6-4109-B61C-E59C2E8A9FF7 7/3/11 8:00 AM 86400 UTC Team Foundation Server Event Processing
AD9C60AE-5BF0-4AC0-BE56-F2988088859A 7/16/08 3:00 AM 86400 UTC Team Foundation Server Activity Logging Administration
81A90003-CA23-4E55-9320-F956F62A2477 7/16/08 3:00 AM 86400 UTC Team Foundation Server Data Maintanence

 

Tags:

TFS | TFS 2012 | TFS 2013 | TFS 2015

Send button remained disabled in TFS request feedback form.

by Xavier Dilip Kumar 21. October 2015 20:47

Solution:

You need to fill all the required fields in the feedback form to enable the activity buttons such as Back,Preview and Send. 

The required fields in the form are marked in yellow

Tags:

TFS | TFS 2012 | TFS 2013 | TFS 2015

How do I request feedback in TFS team project?

by Xavier Dilip Kumar 21. October 2015 20:39

Solution:

  • Open TFS team project's web access
  • On the Home page click on Request feedback under Activities

 

Tags:

TFS | TFS 2012 | TFS 2013 | TFS 2015

TFS Versions

by Xavier Dilip Kumar 9. October 2015 14:36
TFS RTM SP1 CU2        
2005 8.0.50727.147 8.0.50727.762          
2008 9.0.21022.8 9.0.30729.1          
2010 10.0.30319.1 10.0.40219.1 10.0.40219.371        
TFS RTM Update 1 Update 1 CU 1 Update 2 Update 3 Update 4 Update 5
2012 11.0.50727.1 11.0.51106.1 11.0.60123.100 11.0.60315.1 11.0.60610.1  11.0.61030.0  
2013 12.0.21005.1     12.0.30324.0 12.0.30723.0 12.0.31101.0  12.0.40629.0
2015 14.0.23128.0            

Tags:

TFS

Not able to create _PublishedWebsite folder using Visual Studio 2015 and the new Team Build 2015

by Xavier Dilip Kumar 9. October 2015 10:06

Solution:

Add the following property value pair to the MSBuild arguments field in the Build definition.

/p:OutDir=$(build.stagingDirectory)

Tags:

TFS | TFS 2015 | Visual Studio 2015

Uppercase and lowercase issue in Work Item field custom values

by Xavier Dilip Kumar 9. October 2015 08:31

Issue:

The uppercase value entered for a Work Item field is displayed as lowercase once the Work Item template is deployed.

Example:

The N/A value is displayed as n/a

Explanation:

The custom values defined in the Work Item templates are stored in the collection database table named Constants

SELECT [ConstID],[DisplayPart],[String] FROM [Tfs_DefaultCollection].[dbo].[Constants] where DisplayPart = 'N/A 

Workaround:

Manually update the DisplayPart data to required case letter.

Update [Tfs_DefaultCollection].[dbo].[Constants] set [DisplayPart] = 'N/A' where [ConstID] = '7777' 

Warning: Manipulating TFS tables directly is neither recommended nor supported and might corrupt the database leading to unrecoverable state.

Tags:

TFS

TFS Server Firewall Rules Requirements

by Xavier Dilip Kumar 8. October 2015 20:18

Details:

Source
Destination Protocol Name Protocol Type Default Ports
Client Environment        
Team Foundation Server Client TFS App Tier(s) or Load balanced HTTP / HTTPS TCP 8080 / 443
Team Foundation Server Client TFS Proxy HTTP TCP 8081
TFS Proxy TFS App Tier(s) or Load balanced HTTP / HTTPS TCP 8080 / 443
Build Environment        
Build Controller TFS App Tier(s) or Load balanced HTTP / HTTPS TCP 8080 / 443
Build Agent TFS App Tier(s) or Load balanced HTTP / HTTPS TCP 8080 / 443
Build Controller Build Agent SOAP over HTTP TCP 9191
Build Agent Build Controller SOAP over HTTP TCP 9191
TFS App Tier(s) / Load balanced Build Agent SOAP over HTTP TCP 9191
Test Environment        
TFS App Tier(s) / Load balanced Test Controller .NET Remoting TCP 6901
Test Controller TFS App Tier(s) or Load balanced HTTP / HTTPS TCP 8080 / 443
Test Controller Test Agent .NET Remoting TCP 6910
Test Agent Test Controller .NET Remoting TCP 6901
Data Tier, TFS warehouse , SSAS & SSRS
TFS App Tier(s) / Load balanced Data Tier(s) or Cluster MS-SQL TCP 1433
TFS App Tier(s) / Load balanced TFS Warehouse SQL Server MS-SQL TCP 1433
TFS App Tier(s) / Load balanced Data Tier(s) or Cluster MS-SQL TCP 1433
TFS App Tier(s) / Load balanced Reporting Services HTTP TCP 80
Team Foundation Server Client Reporting Services HTTP TCP 80
Data Tier(s) / Cluster Analysis Services MS-AS TCP 2382 or 2383
Collaboration Environment        
TFS App Tier(s) / Load balanced SharePoint Server HTTP TCP 80 / 17012
SharePoint Server Data Tier(s) or Cluster MS-SQL TCP 1433
Team Foundation Server Client Share Point Portal HTTP TCP 80

Tags: , ,

TFS | TFS 2015

Can TFS service account be non interactive?

by Xavier Dilip Kumar 8. October 2015 19:34

Explanation:

Yes. The TFS service account can be non interactive. But the account which is used to install and configure should be interactive and should have the following permissions.

  • Local admin on the TFS Server
  • SysAdmin on SQL Server

The interactive admin account used to install and configure the TFS will grant the necessary permissions to the non interactive Service account

 

Tags: ,

TFS | TFS 2010 | TFS 2012 | TFS 2013

TF31002: Unable to connect to this Team Foundation Server

by Xavier Dilip Kumar 14. May 2015 06:52
Explanation:
Ensure the proxy settings are set correct. You may face TFS connection issues when the proxy settings 
have changed or are incorrect.

Note: The .NET and Visual Studio use the proxy settings from Internet Explorer 

Tags: ,

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

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