TFS not sync'ing with Project Server

Question

Hello,
I’m having some trouble getting TFS to sync with project server, the setup was done by someone else and im not very familiar with project server, if I change or update a project in Project Server, the changes get pushed over to TFS, but if I change something in TFS, they don’t get pushed over to the project server.

I’m editing project server 2010 using Project Professional 2010 and the machine also has Team Explorer 2010 installed. When editing TFS, im editing using Visual Studio 2010 with service pack 1 installed.

I’ve tried running a tfsadmin /getsyncmessages /collection:http://mytestingtfs:8080/tfs/collectionOne
And it shows alot of the following:

Microsoft.TeamFoundation.Sync.ProjectServerAPI.ProjectServerException: TF289004: An error occurred while communicating with Project Server. Contact your Project Server administrator. ---> System.Web.Services.Protocols.SoapException: <PSIEXTENSIONERROR>|Error_GeneralServerErrorSql|A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.); at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall); at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters); at Microsoft.TeamFoundation.Sync.ProjectServerAPI.TfsPsiExtensionAPI.TfsPsiExtension.ReadProjectChanges(Guid[] projectIds, Int32[] projectRevisions, Int32[] projectRevisionRanks, QueryFieldInfo queryFieldInfo, String syncToTfsField, String activeTfsAssignmentField); at Microsoft.TeamFoundation.Sync.Services.PsiExtensionService.ReadProjectChanges(Guid[] projectIds, Int32[] projectRevisions, Int32[] projectRevisionRanks, QueryFieldInfo queryFieldInfo, String syncToTfsField, String activeTfsAssignment); --- End of inner exception stack trace ---; at Microsoft.TeamFoundation.Sync.Services.PsiExtensionService.ThrowProjectServerException(SoapException ex); at Microsoft.TeamFoundation.Sync.Services.PsiExtensionService.ReadProjectChanges(Guid[] projectIds, Int32[] projectRevisions, Int32[] projectRevisionRanks, QueryFieldInfo queryFieldInfo, String syncToTfsField, String activeTfsAssignment); at Microsoft.TeamFoundation.Sync.ProjectServer.Providers.ProjectChangeBatchBuilder.ReadProjectChanges(); at Microsoft.TeamFoundation.Sync.ProjectServer.Providers.ProjectChangeBatchBuilder.ResetProjectChangesBatch(); at Microsoft.TeamFoundation.Sync.ProjectServer.Providers.ProjectChangeBatchBuilder.InitializeServices(ServiceContext serviceContext); at Microsoft.TeamFoundation.Sync.ProjectServer.Providers.ProjectServerProjectPlanProvider.GetSyncChangeBatch(UInt32 batchSize, ChangeLog`1 destinationKnowledge, ISourceDataProvider& sourceDataProvider, IProcessingFeedback& processingFeedback); at Microsoft.TeamFoundation.Sync.Services.ServiceContextSyncProvider`1.GetChangeBatch(UInt32 batchSize, Object destinationKnowledge, ISourceDataProvider& sourceDataProvider, IProcessingFeedback& processingFeedback); at Microsoft.TeamFoundation.Sync.Framework.SyncOrchestrator.Sync(); at Microsoft.TeamFoundation.Sync.Session.ProjectSyncExecutor.ExecuteSerial(IEnumerable`1 syncOrchestrators); at Microsoft.TeamFoundation.Sync.JobExtension.JobServicePlugin.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime jobQueueTime, String& resultMessage)

System.Web.Services.Protocols.SoapException: TF246018: The database operation exceeded the timeout limit and has been cancelled. Verify that the parameters of the operation are correct.; at Microsoft.TeamFoundation.Proxy.SyncService.GetSyncMappingChange(Guid serverId, Int32 rev, SyncMapping& mapping); at Microsoft.TeamFoundation.Sync.Shared.ProjectServerMappingDatastore.GetMappingData(Stream& stream, SyncConfigurationRevision& mappingRevision); at Microsoft.TeamFoundation.Sync.Mapping.Impls.MappingManager`2.LoadMappingFile(MappingLoadOption loadOption); at Microsoft.TeamFoundation.Sync.Mapping.Impls.MappingManager`2.GetMapping[T](MappingLoadOption loadOption, TRev& revision, Func`2 get); at Microsoft.TeamFoundation.Sync.Mapping.Impls.MappingManager`2.GetSyncConfiguration(MappingLoadOption loadOption, TRev& revision); at Microsoft.TeamFoundation.Sync.Services.SyncConfigurationService.Initialize(SyncConfigurationStore store, Guid tpcId); at Microsoft.TeamFoundation.Sync.Session.ProjectSyncSessionBuilder.BuildContext(IDictionary`2 parameters); at Microsoft.TeamFoundation.Sync.ServiceExecution.SyncCatalyst.Execute(ISyncModule syncModule, ISyncExecutionControl syncExecutionControl, ISyncSessionBuilder syncSessionBuilder, IDictionary`2 parameters); at Microsoft.TeamFoundation.Sync.JobExtension.JobServicePlugin.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime jobQueueTime, String& resultMessage)

TF292902: Could not connect to Project Server. Details: "TF285018: Cannot access the following PWA instance: http://mytestingtfs/PWA. Project Server returned this error: "Unhandled Communication Fault occurred". Verify that the PWA instance exists, and that the necessary permissions have been granted to the service account for the team project collection to access the PWA.". The server may not be valid or a network problem may exist. If the problem persists, contact your Project Server administrator.

System.NullReferenceException: Object reference not set to an instance of an object.; at Microsoft.TeamFoundation.Sync.ProjectServer.Providers.StatusingErrorHelper.IsResourceException(Exception exception); at Microsoft.TeamFoundation.Sync.ProjectServer.Providers.ProjectServerChangeBatchHelper.ProcessBatchTaskUpdates(IProcessingFeedback processingFeedback, Dictionary`2 resNameToTaskUpdatesDictionary, Dictionary`2 projectProperties); at Microsoft.TeamFoundation.Sync.ProjectServer.Providers.ProjectServerChangeBatchHelper.ApplyChanges(ChangeBatch changeBatch, ISourceDataProvider sourceDataProvider, IProcessingFeedback processingFeedback, ServiceContext serviceContext); at Microsoft.TeamFoundation.Sync.Framework.SyncOrchestrator.Sync(); at Microsoft.TeamFoundation.Sync.Session.ProjectSyncExecutor.ExecuteSerial(IEnumerable`1 syncOrchestrators); at Microsoft.TeamFoundation.Sync.JobExtension.JobServicePlugin.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime jobQueueTime, String& resultMessage)

TF287030: An error was returned while trying to synchronize a task with ID: 072c3f44-20ce-48f2-9803-02df9011bfcb. Error = "TF287005: An item that was changed does not contain a value for the work item type.". Contact your administrator for Team Foundation Server to verify that the required permissions to perform this operation are assigned, and that the work item type and team project exist.

I would really appreciate any suggestions on how I can fix these errors, Ive tried searching but I cant seem to find many detailed solutions, as Im somewhat new to tfs and project server would appreciate detail. Thanks in advance :)

 

 

Answer 1

Hi, can you confirm that the PWA mentioned in the message below does still exist and that the TFS service account has all the proper permissions on it?

 

TF292902: Could not connect to Project Server. Details: "TF285018: Cannot access the following PWA instance:http://mytestingtfs/PWA. Project Server returned this error: "Unhandled Communication Fault occurred". Verify that the PWA instance exists, and that the necessary permissions have been granted to the service account for the team project collection to access the PWA.". The server may not be valid or a network problem may exist. If the problem persists, contact your Project Server administrator.

---

Federico Kolliker Frers - MSFT