How to query build controller and agent details in a collection database

by XDK 2. January 2014 08:51

Solution:

SELECT a.ControllerId "Controller ID", a.DisplayName "Controller Name" , a.Status "Controller Status(1 - Active)",

b.AgentId "Agent ID", b.DisplayName "Agent Name", b.Status  "Agent Status(1 - Active)" FROM tbl_BuildController a , tbl_BuildAgent b where a.ControllerId = b.ControllerId

Tags:

Azure DevOps on-premises | TFS 2010 | TFS 2012 | TFS 2013

w3wp.exe process is missing after TFS app tier reboot

by XDK 23. December 2013 11:12

Explanation:

w3wp.exe an Internet Information Services (IIS) worker process is a windows process which runs Web applications, and is responsible for handling requests sent to a Web Server for a specific application pool. W3wp.exe process will not be started automatically after App tier reboot or IIS restart or application pool restart. w3wp.exe will be launched once the first request is made to the TFS Application.

Solution:

1. Try accessing TFS application once http://tfs:8080/tfs. See whether the w3wp.exe is available in "Windows Task Manager" --> "Processes Tab"

2. You can configure Worker process started automatically by adding startMode attribute to TFS application pool to AlwaysRunning in your applicationHost.config

<applicationPools>

   <add name="Default App Pool" startMode="AlwaysRunning" />

</applicationPools>

Solution 2 will work for IIS 7.5 or newer

Tags:

Azure DevOps on-premises | TFS 2010 | TFS 2012 | TFS 2013

How to switch a workspace from source to target workspace mappings without affecting the folders and files in the target workspace.

by XDK 19. December 2013 08:02

Explanation:

A regular get operation will deleted each item in the target workspace folder and re-downloaded the folders and files from the server to target workspace folder.

Solution:

Use remap switch with tf get command

"tf get /remap"

Note: /remap switch does increase the load on server to process your request

Tags:

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

Cannot add new build templates or create team projects on TFS because of error ‘The File Exists’

by XDK 16. December 2013 08:14

Exception:

Explanation:

The error may occur when the following cache folder size increases.

C:\Users\<tfsservice account / Build account>\AppData\Local\Temp

Solution:

Clearing the content of the following cache folder location resolved issue with build and team project creation. 

C:\Users\<tfsservice account / Build account>\AppData\Local\Temp

Tags:

Azure DevOps on-premises | TFS 2010 | TFS 2012 | TFS 2013

TFS Versions

by XDK 16. December 2013 07:51
TFS Versions    
2005 RTM 8.0.50727.147
  SP1 8.0.50727.762
     
2008 RTM 9.0.21022.8
  SP1 9.0.30729.1
     
2010 RTM 10.0.30319.1
  SP1 10.0.40219.1
  CU2 10.0.40219.371
     
2012 RTM 11.0.50727.1
  Update 1 11.0.51106.1
  Update 2 11.0.60315.1
  Update 3 11.0.60610.1
  Update 4  
     
2013 RTM 12.0.21005.1

Tags:

Azure DevOps on-premises | TFS 2010 | TFS 2012 | TFS 2013

About the author

My name is Xavier Dilip Kumar Jayaraj having 13+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Microsoft Certified: Azure Administrator Associate

Microsoft Certified: Azure DevOps Engineer Expert

DevOps Engineer Certificate Program | Transcript 

OTP-AWSD5: AWS IoT: Developing and Deploying an Internet of Things

[PCEP-30-01] PCEP – Certified Entry-Level Python Programmer

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

CategoryList

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.