TF221122: 为团队项目集合或 Team Foundation 服务器 TEAM FOUNDATION 运行作业完整分析数据库同步时发生错误 [英] TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION

问题描述

当我尝试在 TFS 2015 分析数据库中创建代码流失报告时，我注意到数据已经相当陈旧了几个月左右.我发现在这种情况下，我们可以执行以下操作:

When I tried to create a Code Churn report in TFS 2015 analysis database, i have noticed that the data is quite old around months. I found out that in these kind of situations we can do the below:

手动处理TFS 数据仓库和分析服务立方体

运行 GetProcessingStatus 时出现错误:

While running the GetProcessingStatus i got the error:

[完整分析数据库同步]:---> AnalysisDatabaseProcessingType=Full，needCubeSchemaUpdate=True.---> Microsoft.TeamFoundation.Warehouse.WarehouseException: TF221122: 运行团队项目集合或 Team Foundation 服务器团队基金会的完整分析数据库同步作业时出错.---> Microsoft.TeamFoundation.Warehouse.WarehouseException:无法处理分析数据库Tfs_Analysis".---> Microsoft.TeamFoundation.Warehouse.WarehouseException:内部错误:操作未成功终止.发生以下系统错误:不允许此用户登录此计算机.高级关系引擎中的错误.无法连接到 DataSourceID 为Tfs_AnalysisDataSource"、名称为Tfs_AnalysisDataSource"的数据源.OLAP 存储引擎中的错误:处理 ID 为Dim Build"、名称为Build"的维度时出错.OLAP 存储引擎中的错误:处理Tfs_Analysis"数据库中Build"维度的Build BK"属性时发生错误.服务器:当前操作被取消，因为事务中的另一个操作失败.发生以下系统错误:不允许此用户登录此计算机.高级关系引擎中的错误.......

[Full Analysis Database Sync]: ---> AnalysisDatabaseProcessingType=Full, needCubeSchemaUpdate=True. ---> Microsoft.TeamFoundation.Warehouse.WarehouseException: TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION. ---> Microsoft.TeamFoundation.Warehouse.WarehouseException: Failed to Process Analysis Database 'Tfs_Analysis'. ---> Microsoft.TeamFoundation.Warehouse.WarehouseException: Internal error: The operation terminated unsuccessfully. The following system error occurred: This user isn't allowed to sign in to this computer. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Tfs_AnalysisDataSource', Name of 'Tfs_AnalysisDataSource'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Build', Name of 'Build' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Build BK' attribute of the 'Build' dimension from the 'Tfs_Analysis' database was being processed. Server: The current operation was cancelled because another operation in the transaction failed. The following system error occurred: This user isn't allowed to sign in to this computer. Errors in the high-level relational engine.......

请帮忙.

推荐答案

为了解决这个问题，我不得不在使用 SSMS 删除 Tfs_Analysis 和 Tfs_Warehouse 数据库后重新创建它们.

To solve this i had to recreate the Tfs_Analysis and Tfs_Warehouse databases after deleting them using SSMS.

点击此链接:https://social.msdn.microsoft.com/Forums/en-US/83db0db7-7118-40f3-af14-4e3871a7be7f/tf53010-the-following-error-has-occurred-in-a-team-foundation-component-or-extension-tf221122?forum=tfsadmin

这篇关于TF221122: 为团队项目集合或 Team Foundation 服务器 TEAM FOUNDATION 运行作业完整分析数据库同步时发生错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！