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

How to add users to Team Foundation Service Accounts group?

by Xavier Dilip Kumar 8. August 2013 11:19

Solution:

Execute the following command:

TFSSecurity.exe /g+ "Team Foundation Service Accounts" n:"[Domain]\[User Id]" /server:http://tfs:8080/tfs

Tags: , ,

TFS | TFS 2010 | TFS 2012

TF30171: The Microsoft.ProjectCreationWizard.Portal plug-in used to create the new team project could not be initialized and returned the following error: TF30270: Project site folder “ProjectName” already exists.User Action

by Xavier Dilip Kumar 4. August 2013 12:16

Explanation:

I was not able to create a new team project due to the following exception even though the site with the new team project name does not exist in share point.

Module: Initializer
Event Description: TF30207: Initialization for plugin “Microsoft.ProjectCreationWizard.Portal” failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: TF30270: Project site folder “ProjectName” already exists
Stack Trace:
at Microsoft.VisualStudio.TeamFoundation.WssSiteCreator.Initialize(ProjectCreationContext context)
at Microsoft.VisualStudio.TeamFoundation.EngineStarter.InitializePlugins(MsfTemplate template, PcwPluginCollection pluginCollection)

Solution:

Exception message misguided me. The real problem was with the Share Point connectivity. I was not able to connect to Share Point server using the server name but IP worked. I changed the Share Point sever name to IP in TFS administration console which fixed the issue.

Tags: ,

TFS | TFS 2010 | TFS 2012

How to remove the alerts from TFS event subscription

by Xavier Dilip Kumar 1. August 2013 12:55

Solution:

1. Query tbl_EventSubscription table in the collection DB to identify the Event ID

 select id, * from  [Tfs_DefaultCollection].[dbo].[tbl_EventSubscription]

2. log on to TFS App tier --> Open console window (cmd.exe)

3. goto cd C:\Program Files\Microsoft Team Foundation Server 2010\Tools 

4. use BisSubscribe /unsubscribe command

Syntax:

BisSubscribe /unsubscribe /id <id> (/server <serverNameOrUri> | /collection <collectionNameOrUri>)

Example:

bissubscribe /unsubscribe /id 100 /collection http://tfs:8080/tfs/defaultCollection

Tags:

TFS | TFS 2010 | TFS 2012

A script on this page is causing your web browser to run slow. If it continues to run, your computer might become unresponsive

by Xavier Dilip Kumar 1. August 2013 12:00

Explanation:

Unable to view the build report.  

 

Solution:

View the build report in IE 9 or latest version

 

Tags:

TFS | Supporting Tools | 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