TFS 分析重建错误:列不包含有效的数据绑定,无法处理

发布于 2025-01-07 10:26:15 字数 1834 浏览 1 评论 0原文

我的 TFS 2010 实例遇到问题。在 TFS 的报告选项卡中重建后,当多维数据集完全同步发生时,我没有收到错误。因此,看起来仓库构建成功,但分析服务构建却没有成功。这是错误。

[完整分析数据库同步]: AnalysisDatabaseProcessingType=Full, 需要CubeSchemaUpdate = True。 Microsoft.TeamFoundation.Server.WarehouseException:TF221122:错误 为团队项目运行作业完整分析数据库同步 集合或 Team Foundation 服务器 TEAM FOUNDATION。 Microsoft.TeamFoundation.Server.WarehouseException:无法处理 分析数据库“Tfs_Analysis”。 Microsoft.TeamFoundation.Server.WarehouseException:错误(数据 挖掘):在“Tfs_AnalysisDataSource Structure”结构中, “BuildSK”列不包含有效的数据绑定,因此无法 已处理。

在 Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ExecuteXmla(字符串 最终Xmla)在 Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType 处理类型,WarehouseChanges 仓库更改,布尔值 最后处理失败,布尔立方体SchemaUpdateNeeded) --- 内部异常堆栈跟踪结束 --- 在 Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType 处理类型,WarehouseChanges 仓库更改,布尔值 最后处理失败,布尔值cubeSchemaUpdateNeeded)位于 Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.RunInternal(TeamFoundationRequestContext requestContext、TeamFoundationJobDefinition jobDefinition、日期时间 队列时间、字符串&结果消息)在 Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext requestContext、TeamFoundationJobDefinition jobDefinition、日期时间 队列时间、字符串&结果消息) --- 内部异常堆栈跟踪结束 ---

任何帮助将非常感激,

我已经尝试重建并查看可能导致此问题的结构。我实际上已经改变了任何采矿立方体等中的任何内容,所以不知道为什么会发生这种情况。


更新!!! 来使增量同步工作

  1. 我已经通过关闭分析
  2. 禁用所有仓库同步作业
  3. 。 1 by 1 启用所有仓库作业并运行它们
  4. 再次启动分析作业 5 运行增量同步。

所以在我看来这可能与某种锁有关。我还没有尝试过完全同步,因为我有点害羞,早上要对报告进行演示。


更新!!! 完整的分析数据库同步已在一夜之间完成,没有任何问题。

因此,上述步骤应该适用于锁不允许架构更改的情况。 戴夫

I am having an issue on my TFS 2010 instance. After a rebuild in the Reporting Tab of TFS I am not getting an error when the Cube full sync happenings. So it looks like the warehouse build happens successfully, but the analysis services build does not. Here is the error.

[Full Analysis Database Sync]: AnalysisDatabaseProcessingType=Full,
needCubeSchemaUpdate=True.
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'.
Microsoft.TeamFoundation.Server.WarehouseException: Error (Data
mining): In the 'Tfs_AnalysisDataSource Structure' structure, the
'BuildSK' column does not contain valid bindings to data and cannot be
processed.

at
Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ExecuteXmla(String
finalXmla) at
Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType
processingType, WarehouseChanges warehouseChanges, Boolean
lastProcessingFailed, Boolean cubeSchemaUpdateNeeded)
--- End of inner exception stack trace --- at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType
processingType, WarehouseChanges warehouseChanges, Boolean
lastProcessingFailed, Boolean cubeSchemaUpdateNeeded) at
Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.RunInternal(TeamFoundationRequestContext
requestContext, TeamFoundationJobDefinition jobDefinition, DateTime
queueTime, String& resultMessage) at
Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext
requestContext, TeamFoundationJobDefinition jobDefinition, DateTime
queueTime, String& resultMessage)
--- End of inner exception stack trace ---

Any help would be really appreciated,

I have tried rebuilding and looking to see what structure that might be causing this. I have actually changed anything in any of the mining cubes etc so don't know why this has started happening.


UPDATE !!!!
I have gotten the incremental sync to work by

  1. Switching off the Analysis
  2. Disabling all of the Warehouse sync jobs.
  3. 1 by 1 enabling all of the Warehouse jobs and running them Starting
  4. the analysis jobs again 5 Running the incremental sync.

So it seems to me like it may be to do with a lock of some kind. I havent tried the full sync yet as I am a little gun shy and have a presentation on the reports in the morning.


UPDATE !!!!
The full analysis database sync has happened over night without any issues.

So the steps above should work where locks are not allowing schema changes.
Dave

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文