none
TFS 2013 Integration with Project Server 2013 - TF244069 + TF400958 Errors when attempting to register collection RRS feed

  • Question

  • Dears,

    When i try to RegisterPWA faced the following:

    TF244069: An error occurred while checking the provisioning status of the report
    ing database schema for a PWA instance.
    Project Server returned the following error: "TF400958: The Project Server service account does not have sufficient permissions to call the Project Server Web services. Contact your Project Server administrator to verify that the Project Server service account has the required permissions.".

    Trace Log

    tfsadmin Information: 0 : [Info, PID 4832, TID 5060, 2015/02/15 11:13:37.383, 17 ms, General] Initializing NotificationManager.GetMessageInfos
    tfsadmin Information: 0 : [Info, PID 4832, TID 5060, 2015/02/15 11:13:37.388, 21 ms, General] Leaving NotificationManager.GetMessageInfos
    tfsadmin Information: 0 : [Info, PID 4832, TID 5060, 2015/02/15 11:13:37.388, 21 ms, General] Entering NotificationManager()
    tfsadmin Information: 0 : [Info, PID 4832, TID 5060, 2015/02/15 11:13:37.388, 21 ms, General] Leaving NotificationManager()
    tfsadmin Information: 0 : [Info, PID 4832, TID 5060, 2015/02/15 11:13:37.564, 197 ms, General] Running RegisterPwa
    tfsadmin Information: 0 : [Info, PID 4832, TID 5060, 2015/02/15 11:13:37.575, 207 ms, General] TfsCredentialCache.GetCredentials(): name - http://tfs2013:8080/tfs
    [Verbose, PID 4832, TID 5060, 2015/02/15 11:13:37.591, 223 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\LocationServerMap.xml
    [Verbose, PID 4832, TID 5060, 2015/02/15 11:13:37.592, 224 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    [Verbose, PID 4832, TID 5060, 2015/02/15 11:13:37.742, 375 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    [Verbose, PID 4832, TID 5060, 2015/02/15 11:13:39.028, 1661 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    [Verbose, PID 4832, TID 5060, 2015/02/15 11:13:39.037, 1670 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.SyncToTFSLT.DoNotDelete,
                              Id : 50abda75-cddb-4e73-93ba-2462da2c28e7,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 654aec1d-d3e6-44a9-b3e6-023cb761a2c8,
                              Value : Publish to Team Project,
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.WorkItemIdLT.DoNotDelete,
                              Id : 36a61322-6c2f-46c0-9c12-78fa07b10621,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 5a9a2843-62c9-49fc-b37f-6be7ea701857,
                              Value : Work Item Id (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.WITypeLT.DoNotDelete,
                              Id : 776debbf-261f-41c6-8217-2c4d604cf48c,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 9a495335-63c2-404e-8007-673a1e178ac1,
                              Value : Work Item Type (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.TFSMapLT.DoNotDelete,
                              Id : 2904cada-1553-47bf-a379-7441ce5f7a64,
                              SortOrder : 2
    tfsadmin Information: 0 : Adding LookupTable Value - Id : b9958e91-35f2-4716-aaab-b6b84a061e0e,
                              Value : http://tfs2013:8080/tfs,
                              Description : eb474274-ebe3-4256-bc62-dd81353295e8
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.SubmittedRevLT.DoNotDelete,
                              Id : 43c00108-dfc4-4cf4-8cda-e46e884f5b43,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 30215bc9-781f-4154-a6ee-02849eb10bf4,
                              Value : Submitted Revision (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.TfsAssnLT.DoNotDelete,
                              Id : e69a5935-e6ec-46b4-9ca8-0ca18643668b,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : df982087-1afa-4114-911a-f3577cd5eff9,
                              Value : Active Assignment (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : 244c576a-101a-4dea-8a16-f5e41a1e891c,
                              CoreCustomFields : WorkItemId,
                              DataType : 21,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : ccedcd76-166b-44c5-81a9-ba1aedce308a,
                              CoreCustomFields : WorkItemType,
                              DataType : 21,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : d096e3db-56c8-42f5-b4e9-0222a3ce6c18,
                              CoreCustomFields : SyncToTFS,
                              DataType : 17,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : f57b0fca-61fc-4b08-90d0-3dfe5f435d3e,
                              CoreCustomFields : SubmittedRevision,
                              DataType : 21,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : 4d841e91-8e9f-4857-bb24-08ae6cd69252,
                              CoreCustomFields : IsTaskTypeInitialized,
                              DataType : 17,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : ebcb9952-b1be-45e7-8d4b-0048b95eb914,
                              CoreCustomFields : ActiveTfsAssignment,
                              DataType : 17,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin check whether PWA Reporting DB Schema is provisioned
    tfsadmin Error: 0 : [Error, PID 4832, TID 5060, 2015/02/15 11:13:42.287, 4920 ms, General] 
    {
    Exception:  {
    Exception Message: <PSIEXTENSIONERROR>|Error_ProjectServerAccountUnauthorized (type SoapException)SoapException Details: <detail />
    Exception Stack Trace:    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.IsDBSchemaProvisioned()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.IsDBSchemaProvisioned()
     }
    }
    tfsadmin Error: 0 : [Error, PID 4832, TID 5060, 2015/02/15 11:13:42.303, 4935 ms, General] 
    {
    Exception:  {
    Exception Message: 
    TF244069: An error occurred while checking the provisioning status of the reporting database schema for a PWA instance.
    Project Server returned the following error: "TF400958: The Project Server service account does not have sufficient permissions to call the Project Server Web services. Contact your Project Server administrator to verify that the Project Server service account has the required permissions.".
     (type ProvisionException)
    Exception Stack Trace:    at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.HandleSoapException(SoapException soapException, String errorResourceString)
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.IsDBSchemaProvisioned()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionManager.Provision()
     }
    }
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    [Verbose, PID 4832, TID 5060, 2015/02/15 11:13:45.903, 8535 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    tfsadmin Error: 0 : [Error, PID 4832, TID 5060, 2015/02/15 11:13:45.988, 8620 ms, General] 
    {
    Exception:  {
    Exception Message: 
    TF244069: An error occurred while checking the provisioning status of the reporting database schema for a PWA instance.
    Project Server returned the following error: "TF400958: The Project Server service account does not have sufficient permissions to call the Project Server Web services. Contact your Project Server administrator to verify that the Project Server service account has the required permissions.".
     (type ProvisionException)
    Exception Stack Trace:    at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.HandleSoapException(SoapException soapException, String errorResourceString)
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.IsDBSchemaProvisioned()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionManager.Provision()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionCommands.RegisterPwa(String pwaUrl, String tfsUrl, Dictionary`2 customFieldNameDictionary, Boolean provision, Boolean force, String previousPwaUrl)
       at Microsoft.TeamFoundation.Sync.Provisioning.RegisterPwaCmdlet.ProcessRecord()
     }
    }
    tfsadmin Information: 0 : [Info, PID 772, TID 3388, 2015/02/15 11:18:47.261, 18 ms, General] Initializing NotificationManager.GetMessageInfos
    tfsadmin Information: 0 : [Info, PID 772, TID 3388, 2015/02/15 11:18:47.264, 20 ms, General] Leaving NotificationManager.GetMessageInfos
    tfsadmin Information: 0 : [Info, PID 772, TID 3388, 2015/02/15 11:18:47.265, 21 ms, General] Entering NotificationManager()
    tfsadmin Information: 0 : [Info, PID 772, TID 3388, 2015/02/15 11:18:47.265, 21 ms, General] Leaving NotificationManager()
    tfsadmin Information: 0 : [Info, PID 772, TID 3388, 2015/02/15 11:18:47.439, 195 ms, General] Running RegisterPwa
    tfsadmin Information: 0 : [Info, PID 772, TID 3388, 2015/02/15 11:18:47.450, 205 ms, General] TfsCredentialCache.GetCredentials(): name - http://tfs2013:8080/tfs
    [Verbose, PID 772, TID 3388, 2015/02/15 11:18:47.465, 221 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\LocationServerMap.xml
    [Verbose, PID 772, TID 3388, 2015/02/15 11:18:47.465, 221 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    [Verbose, PID 772, TID 3388, 2015/02/15 11:18:47.620, 376 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    [Verbose, PID 772, TID 3388, 2015/02/15 11:18:48.881, 1637 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    [Verbose, PID 772, TID 3388, 2015/02/15 11:18:48.890, 1645 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.SyncToTFSLT.DoNotDelete,
                              Id : 9e761f3b-f493-420a-97fd-52c7b235a857,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : b50fcbe7-9e0c-4110-b3ae-5a10ef39cf73,
                              Value : Publish to Team Project,
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.WorkItemIdLT.DoNotDelete,
                              Id : 7479cf6f-ba71-4b02-868b-32295a212d5d,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 5d1db736-acde-452f-9564-4f318a9a3c67,
                              Value : Work Item Id (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.WITypeLT.DoNotDelete,
                              Id : b9aefb29-d47c-4621-8af3-32edaad0a0d8,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 87ec08f8-e1c1-4088-8c16-307550776410,
                              Value : Work Item Type (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.TFSMapLT.DoNotDelete,
                              Id : 759ca57e-7b05-4e48-a077-6f06af7493ae,
                              SortOrder : 2
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 43d3b9e2-2d93-4989-a230-0a74883d7c5a,
                              Value : http://tfs2013:8080/tfs,
                              Description : eb474274-ebe3-4256-bc62-dd81353295e8
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.SubmittedRevLT.DoNotDelete,
                              Id : 13559241-573b-427b-91ee-96020f695df3,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : 3b06f55e-e79a-4600-921d-fe02e51e5c20,
                              Value : Submitted Revision (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether LookupTables related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Adding LookupTable - Name : Microsoft.VSTS.ProjSrv.TfsAssnLT.DoNotDelete,
                              Id : b89a3622-4040-4a42-b065-3373f8502bcb,
                              SortOrder : 1
    tfsadmin Information: 0 : Adding LookupTable Value - Id : dd60101c-38b4-4eaa-87e7-a75825bc7f69,
                              Value : Active Assignment (TFS),
                              Description : 
    tfsadmin Information: 0 : End - Create LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : a1502fcb-1382-4579-b2ee-46b2795a3abb,
                              CoreCustomFields : WorkItemId,
                              DataType : 21,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : da408b60-bfaa-43b4-84bc-4d57434a1f4e,
                              CoreCustomFields : WorkItemType,
                              DataType : 21,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : 003a358e-fbb6-48f1-8e8d-940bbe7b553d,
                              CoreCustomFields : SyncToTFS,
                              DataType : 17,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : 20911a5b-03ca-425f-85ca-45c4df5d0eb9,
                              CoreCustomFields : SubmittedRevision,
                              DataType : 21,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : e94ab5b0-ba3a-433e-867b-afd537874682,
                              CoreCustomFields : IsTaskTypeInitialized,
                              DataType : 17,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : End - Check whether CustomFields related to TFS-PS Integration exists
    tfsadmin Information: 0 : Begin - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Adding CustomField - Id : 4242c4a1-1cdd-49b5-9a28-9eb29a81390d,
                              CoreCustomFields : ActiveTfsAssignment,
                              DataType : 17,
                              IsRequired : False,
                              EntityType : ebad93e7-2149-410d-9a39-a8680738329d,
                              LookupTableId : 00000000-0000-0000-0000-000000000000,
                              LookupTableDefaultValueId : 00000000-0000-0000-0000-000000000000
    tfsadmin Information: 0 : End - Create CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin check whether PWA Reporting DB Schema is provisioned
    tfsadmin Error: 0 : [Error, PID 772, TID 3388, 2015/02/15 11:18:52.240, 4996 ms, General] 
    {
    Exception:  {
    Exception Message: <PSIEXTENSIONERROR>|Error_ProjectServerAccountUnauthorized (type SoapException)SoapException Details: <detail />
    Exception Stack Trace:    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.IsDBSchemaProvisioned()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.IsDBSchemaProvisioned()
     }
    }
    tfsadmin Error: 0 : [Error, PID 772, TID 3388, 2015/02/15 11:18:52.258, 5014 ms, General] 
    {
    Exception:  {
    Exception Message: 
    TF244069: An error occurred while checking the provisioning status of the reporting database schema for a PWA instance.
    Project Server returned the following error: "TF400958: The Project Server service account does not have sufficient permissions to call the Project Server Web services. Contact your Project Server administrator to verify that the Project Server service account has the required permissions.".
     (type ProvisionException)
    Exception Stack Trace:    at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.HandleSoapException(SoapException soapException, String errorResourceString)
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.IsDBSchemaProvisioned()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionManager.Provision()
     }
    }
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting CustomFields related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : Begin - Deleting LookupTables related to TFS-PS Integration
    tfsadmin Information: 0 : End - Deleting LookupTables related to TFS-PS Integration
    [Verbose, PID 772, TID 3388, 2015/02/15 11:18:56.726, 9482 ms, General] Using cache file path C:\Users\tfs_admin\AppData\Local\Microsoft\Team Foundation\5.0\Cache\eb474274-ebe3-4256-bc62-dd81353295e8\LocationServiceData.config
    tfsadmin Error: 0 : [Error, PID 772, TID 3388, 2015/02/15 11:18:56.812, 9568 ms, General] 
    {
    Exception:  {
    Exception Message: 
    TF244069: An error occurred while checking the provisioning status of the reporting database schema for a PWA instance.
    Project Server returned the following error: "TF400958: The Project Server service account does not have sufficient permissions to call the Project Server Web services. Contact your Project Server administrator to verify that the Project Server service account has the required permissions.".
     (type ProvisionException)
    Exception Stack Trace:    at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.HandleSoapException(SoapException soapException, String errorResourceString)
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionPwaDBSchema.IsDBSchemaProvisioned()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionManager.Provision()
       at Microsoft.TeamFoundation.Sync.Provisioning.ProvisionCommands.RegisterPwa(String pwaUrl, String tfsUrl, Dictionary`2 customFieldNameDictionary, Boolean provision, Boolean force, String previousPwaUrl)
       at Microsoft.TeamFoundation.Sync.Provisioning.RegisterPwaCmdlet.ProcessRecord()
     }
    }
    
    i review Permission check list more than once, please help

    Sunday, February 15, 2015 11:29 AM

All replies

  • Hi,

    I would review if the service account for Project Server Event handler has the proper permissions to access the project server service application

    Hope this helps

    Paul

    Wednesday, February 18, 2015 12:43 PM
  • The application was able to create the Custom Fields and Lookup tables, but the process failed while checking the reporting database schema.

    I hope you followed this article: https://msdn.microsoft.com/en-us/library/gg412653.aspx

    An error occurred while checking the provisioning status of the reporting database schema for a PWA instance.
    Project Server returned the following error: "TF400958: The Project Server service account does not have sufficient permissions to call the Project Server Web services. 

    Cause: TFS service account is unable to communicate to the project server web services.

    Suggestion 1: Provide all the permissions according to the MSDN article.

    Suggestion 2: Ensure that the TFS service account is part of administrators group in that PWA instance.

    Suggestion 3: Add the TFS service account as member of local administrators group.

    Suggestion 4: If possible, use the same service account for TFS service and Project Application service and PWA instance admin account.


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management

    Wednesday, February 18, 2015 11:32 PM
    Moderator