Soultion

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

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 :)

Solution:

Execute the following command:

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

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.

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