TFS Web interface is not rendering the date field with respect to “daylight saving”

by Xavier Dilip Kumar 29. January 2015 18:28

Explanation:

TFS Web interface is not rendering the date field with respect to “daylight saving” which is causing the confusion between the date field displayed in web access and visual studio IDE. The TFS date fields populated with the date during “daylight saving” on and time as 23:00 are displayed as next day in Visual Studio IDE which is logical and expected.

Solution: 

Install latest "Daylight Saving Time (DST)" update for windows on your app tier(s).

More info: http://support.microsoft.com/gp/cp_dst

Tags: , ,

TFS 2010 | TFS 2012 | TFS 2013

Build.targets (19): TF10131: The shelveset name _Build_XXXXX?queueId=XXXX contains more than 64 characters, contains one of the following characters: "/:<>\|*?; or ends with a space. Type a valid name and try again. Build.targets (19): The "Get" task failed unexpectedly.

by Xavier Dilip Kumar 14. April 2014 11:41

Explanation:

This error occurs when attempting a gated checkin following environment:

* TFS 2012 Update 3 or earlier updates application server

* TFS 2010 SP1 Build Server

* "UpgradeTemplate.xaml" used for build process

Solution:

This is a known issue that has been fixed with TFS 2012 Update 4

Tags: , ,

TFS | TFS 2010 | TFS 2012

How to enable the TFS add-in for excel?

by Xavier Dilip Kumar 18. March 2014 11:33

Solution:

  • Open Excel
  • Click on “File” --> “Option” menu
  • Click on “Add-Ins”
  • Search for “Team Foundation Add-in”
  • If you see “Team Foundation Add-in” under “Disabled Application Add-in”
  • Select “Disabled Items” and click “Go” button  
  •  
  • Select “Team Foundation Add-in” and click “Enable”
  •  
  • Close and reopen excel

Tags:

TFS 2010 | TFS 2012 | TFS 2013

How to enable trace logs in the build environment?

by Xavier Dilip Kumar 18. March 2014 11:19

Explanation:

Following are the steps to enable trace logs in the build environment

1. On the Build machine (both controller and agent) ,  copy the attached .config file (TFSBuildServiceHost exe.config (2.25 kb)) to C:\Program Files\Microsoft Team Foundation Server 2010\Tools.

2. Create a new directory named c:\logs and ensure that the account under which the service Visual Studio Team Foundation Build Service Host has write permission on c:\logs.

3. Restart the build controller/agent service (net stop tfsbuildservicehost & net start tfsbuildservicehost).

4. Trace log will be generated under c:\logs

Steps to enable log in the windows event viewer 

1. On the Build machine, go to Event Viewer and navigate to the following path:

  • Application and Services Logs\Microsoft\Team-Foundation-Server\Build-Services.

 2. We want a detailed level tracing:

  • Go to the ‘View’ menu and select ‘Show Analytic and Debug Logs’. Once you do that there will be 2 channels available under this event source, Operational and Analytic

** The operational log is always on and provides high-level auditing of failures and events, while the Analytic log is off by default and provides very detailed information about activities in the build machine.

 

** You can enable the Analytic log, by right click and select Enable Log.


 

Tags:

Team Build | TFS 2010 | TFS 2012 | TFS 2013

TF259137: The following account does not have sufficient permissions to complete the operation: DOMAIN\user. The following permissions are needed to perform this action: Write.

by Xavier Dilip Kumar 10. March 2014 10:02

Solution:

Check whether the "[PROJECT NAME]\Project Administrators" group has permissions for the team project

Command to view current permissions

tfslabconfig.exe permissions /collection:<CollectionURL> /Url:VSTFS:///LabManagement/TeamProject/<TeamProject> 

Command to grant permissions

tfslabconfig.exe permissions /collection:<CollectionURL> /Url:VSTFS:///LabManagement/TeamProject/<TeamProject> 

/Group:"[PROJECT NAME]\Project Administrators" /allow:*

Tags:

TFS 2010 | TFS 2012 | TFS 2013

How to clone a build definitions from one project to another within a same collection?

by Xavier Dilip Kumar 7. March 2014 12:31

Solution:

You can use TFS power tools command line utility to clone a build definition across projects

Note: You can download and install TFS Power Tools from http://visualstudiogallery.msdn.microsoft.com/b1ef7eb2-e084-4cb8-9bc7-06c3bad9148f

1. Open "Visual Studio" command prompt

2. You can use the following command to preview the build definition clone

tfpt builddefinition /clone "<Source Team Project Name>\Build Definition" "<Target Team Project Name>\Build Definition" /Collection:http://tfs:8080/tfs/DefaultCollection /preview

3. You can use the following command to clone the build definition

tfpt builddefinition /clone "<Source Team Project Name>\Build Definition" "<Target Team Project Name>\Build Definition" /Collection:http://tfs:8080/tfs/DefaultCollection

Only the well-defined build definition can be cloned using this approach meaning the build source build definition should have all the mandatory (required) properties filled with values

For example:

The source build definition without Build controller name cannot be cloned using this approach.

You can also use * wildcard character to clone all build definitions at one shot, provided you have well-defined build definition at source team project.

tfpt builddefinition /clone "<Source Team Project Name>\*" "<Target Team Project Name>\"  /Collection:http://tfs:8080/tfs/DefaultCollection

Remember to update the following build properties to the cloned build definition. 

1. Disable build definition to prevent accidental triggering.

2. Change workspace mapping to target team project source.

3. Change drop location.

4. Change the build process template to point to the right projects.

5. If you use custom build workflow/tasks, make sure your build controller custom assembly references are pointed to target team project source control

6. Enable the build definition.

 

Tags: , ,

TFS 2010 | TFS 2012 | TFS 2013

How to change the work item maximum attachment size?

by Xavier Dilip Kumar 14. February 2014 08:16

Explanation:

By default, The maximum WI attachments size is set to 4 MB but the attachment size can be increased up to 2GB

Solution:

  1. Log on to the application-tier server for TFS.

  2. open the URL: http://localhost:8080/tfs/<Collection Name>/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx?op=SetMaxAttachmentSize

  3. Enter the size in bytes, and then choose Invoke. For 9.5 MB, enter  10000000.

    SetMaxAttachmentSize, ConfigurationSettingsService

Solution:

INSERT INTO [<Collection DB Name>].[dbo].[tbl_RegistryItems] VALUES (1,'#\Service\WorkItemTracking\Settings\','MaxAttachmentSize\',10000000);

Tags:

TFS 2010 | TFS 2012 | TFS 2013

Load Test: The test has not started yet

by Xavier Dilip Kumar 4. February 2014 14:06

Exception:

"The test has not started yet"

Explanation:

The test run result window just lists the name of the machine from which it ran, but it never opens the results and also Test run state remains pending. After I double click on the machine test item it just says "The Test has not started yet". Not able to view the result online during load test execution time. 

 

Solution:

The VS 2010 client version which I used to execute the load was SP1. But the test rig environment version was only VS 2010 RTM. 

1. Installed the SP1 on test controller and agents

2. Reconfigured the agents to controller again.

Tags:

TFS | TFS 2010 | Web Performance & Load Tests

About Test Attachment Cleaner

by Xavier Dilip Kumar 30. January 2014 11:37

Explanation:

A command line tool that only removes the attachments. It does not touch the test runs, which contain the pass/fail data. So, running Test Attachment Cleaner will not impact the record of the test runs.

You need to Test Attachment Cleaner if you:

  1. Do manual test runs and want to delete attachments without deleting the test runs
  2. Do automated test runs and want to delete attachment for builds which have been deleted already, but the build definition’s retention policy was not set to delete “test results” (because this is turned off by default)

You do not need the Test Attachment Cleaner if you:

  1. Have automated test runs triggered by a build, and you have configured the build definition’s retention policy to delete “test results” (which is not set by default)
  2. Delete the Test Runs manually (as this deletes the attachments)

 SQL Query to get the attachment type associated with the team project.

Select projects.ProjectName, SUBSTRING(attachments.filename,

len(attachments.filename)-CHARINDEX('.',REVERSE(attachments.filename))+2,999) as Extension, sum(f.compressedlength)/1024/1024 as SizeInMB
From tbl_Attachment as attachments
INNER JOIN tbl_File as f on attachments.TfsFileId=f.fileid
INNER JOIN tbl_TestRun as tr on attachments.TestRunId = tr.TestRunId
INNER JOIN tbl_Project as projects on tr.ProjectId = projects.ProjectId
Group by projects.ProjectName, SUBSTRING(attachments.filename,len(attachments.filename)-CHARINDEX('.',REVERSE(attachments.filename))+2,999)
Order by sum(f.compressedlength) desc


Download Attachment Cleaner

Command to preview the attachments before delete
tcmpt attachmentcleanup /collection:TfsUrl /teamproject:TeamProjectName /settingsfile:SettingsFile /outputfile
:<Output dir>/teamproject.log /mode:preview
Command to delete the attachments
tcmpt attachmentcleanup /collection:TfsUrl /teamproject:TeamProjectName /settingsfile:SettingsFile /outputfile:<Output dir>/teamproject.log

Sample settingsfile

<DeletionCriteria>
  <TestRun/>
  <Attachment>
    <SizeInMB GreaterThan="50"/>   
  </Attachment>
  <LinkedBugs>
    <Excludestate="New"/>
    <Excludestate="Committed"/>
    <Excludestate="Approved"/>
  </LinkedBugs>
</DeletionCriteria>

Tags:

MTM | TFS 2010 | TFS 2012 | TFS 2013

Unknown domain users displayed in the work items "assigned to" field

by Xavier Dilip Kumar 29. January 2014 16:57

Description:

IT administrators account get populated in the work item "assigned to" field.

By default, [TEAM FOUNDATION]\Valid Users include [TEAM FOUNDATION]\Team Foundation Administrators which holds [BUILT IN]\Administrators.

Workaround:

In the TFS Server Administration Console

1. Select Application Tier and clicked Group Membership. I

2. Double-click on [TEAM FOUNDATION]\Team Foundation Administrators 

3. Remove [BUILT IN]\Administrator

Tags:

TFS 2010 | TFS 2012 | TFS 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